SQL migration: MS SQL 6.5 -> what?
SQL migration: MS SQL 6.5 -> what?
Author
Discussion

_dobbo_

Original Poster:

14,619 posts

279 months

Wednesday 15th August 2007
quotequote all
Hello PH computer boffins!

I've got a legacy server here that runs a collection of old applications including but not limited to the "ancient" MS SQL 6.5

I'd like to get it bought up to date a bit with new hardware and possibly a virtualised operating system. The upgrade path from SQL 6.5 to the latest is a little bit cumbersome - and the pricing of multi CPU MS SQL is to say the least painful.

So I'm looking at alternatives - does anyone have any knowledge or experience of porting a modest sized (i.e. 20GB) multi table MS SQL 6.5 database to another platform, such as postgres?

Ta in advance!

nerd

Famous Graham

26,553 posts

256 months

Wednesday 15th August 2007
quotequote all
MySQL would be the simplest migration, no?

_dobbo_

Original Poster:

14,619 posts

279 months

Wednesday 15th August 2007
quotequote all
Probably - I believe MySQL has native support for MS dat file format. We're actually a mySql partner as well so this would probably be a benefit.

However - I've reason to believe performance wise MySQL wont cut the mustard, hence why I've been looking at postgres. The DB is a backend for an in house CRM package running cold fusion - it's reasonably heavily used and we can't afford for worse performance to be the result of the upgrade!

I've found an application that claims to do an export->import ms sql and postgres in either direction which if it works will be a bargain at $30

kiwisr

9,335 posts

238 months

Wednesday 15th August 2007
quotequote all
Does it really matter about the upgrade path - in any case you can do a bulk export/load to get tables and data across.

cottonfoo

6,053 posts

241 months

Wednesday 15th August 2007
quotequote all
PostgreSQL is nice, like a baby Oracle, although it is lacking in some areas (like replication) there are options such as Slony.

_dobbo_

Original Poster:

14,619 posts

279 months

Wednesday 15th August 2007
quotequote all
kiwisr said:
Does it really matter about the upgrade path - in any case you can do a bulk export/load to get tables and data across.
No it probably doesn't - to be honest we aren't particularly keen to stick with MS solutions anyway (we're an MS partner too, there seems to be a theme here) - a linux based solution is preferred, as such there is no upgrade path.



Edited by _dobbo_ on Wednesday 15th August 16:56