Postgres Pro
Downloads
Home   >   mailing lists

Thread: Migration from MS SQL 2K

Migration from MS SQL 2K

From
TheNice Spider
Date:
Hi,
 
Currently I have serious problem to migrate a "production" MS SQL 2K to Postgres 8 for Windows.
Is there any tools to import MS SQL 2K to Postgres 8 including:
- PK and FK
- View, Trigger, Store Procedure
- Username
- Index and Constraint
- Diagrams
 
Regards.

Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.

Re: Migration from MS SQL 2K

From
"Roger Hand"
Date:
PGAdmin II had a "Migration Wizard" plugin that did a great job. I used it a lot to convert MS SQL 7 and 2000 db's to Postgres 7.x.
 
It did not convert views, but I wrote some code that did that.
 
Unfortunately, PGAdmin II doesn't work with PG 8.
 
And PGAdmin III doesn't have the Migration Wizard plugin, at least it didn't the last I checked.
 
So ... you could use PGAdmin II and the Migration Wizard to convert to Postgres 7.x.
 
Then dump the db, and import into PG 8.
 
Or course, there may be more sophisticated (and possible $$) software that will do what you want more simply.
 
-Roger
-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]On Behalf Of TheNice Spider
Sent: Wednesday, September 28, 2005 10:48 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Migration from MS SQL 2K

Hi,
 
Currently I have serious problem to migrate a "production" MS SQL 2K to Postgres 8 for Windows.
Is there any tools to import MS SQL 2K to Postgres 8 including:
- PK and FK
- View, Trigger, Store Procedure
- Username
- Index and Constraint
- Diagrams
 
Regards.

Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.

Re: Migration from MS SQL 2K

From
"A. Kretschmer"
Date:
am  28.09.2005, um 22:48:06 -0700 mailte TheNice Spider folgendes:
> Hi,
>
> Currently I have serious problem to migrate a "production" MS SQL 2K to Postgres 8 for Windows.
> Is there any tools to import MS SQL 2K to Postgres 8 including:
> - PK and FK
> - View, Trigger, Store Procedure
> - Username
> - Index and Constraint
> - Diagrams

Maybe you can find tipps on http://techdocs.postgresql.org/#convertfrom


Regards, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===