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
<cid:part1.07050204.00090802@netscape.com> -- 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 <mailto:Josef.Springer@joops.com>
Website http://www.joops.com
Attachments:
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