SQL migration: MS SQL 6.5 -> what?
Discussion
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!

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!

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
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 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
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff


