Thread: Migrating a Microsoft-SQL database to Postgres

Hi,

i want to migrate a MS-SQL database to postgres. I have a SQL-script for the tables (definitions, indices a.s.o.), created by the MS-Enterprise-Manager. How can i create a postgres database with this script. Does a tool exist for reading such a script ?

Best Regards,
Josef Springer

 -- the software company --

Orlando-di-Lasso Str. 2
D-85640 Putzbrunn

Tel.	++49(0)89 600 6920
Fax	++49(0)89 600 69220
mailto	Josef.Springer@joops.com
Website	http://www.joops.com

Josef Springer wrote:
>   Hi,
>
> i want to migrate a MS-SQL database to postgres. I have a SQL-script for the
> tables (definitions, indices a.s.o.), created by the MS-Enterprise-Manager. How
> can i create a postgres database with this script. Does a tool exist for reading
> such a script ?

You probably want to give the manuals a quick scan before starting anything.
   http://www.postgresql.org/docs/

Details on client applications are in the section: Reference / Client
Applications
   http://www.postgresql.org/docs/8.0/static/reference-client.html

In particular, I'd recommend exploring the item on psql.
   http://www.postgresql.org/docs/8.0/static/app-psql.html

Don't forget that you will almost certainly have to tweak the script
before importing it.

--
   Richard Huxton
   Archonet Ltd