Re: Migrating a Microsoft-SQL database to Postgres - Mailing list pgsql-general

From Richard Huxton
Subject Re: Migrating a Microsoft-SQL database to Postgres
Date
Msg-id 42D4CDEE.4090106@archonet.com
Whole thread Raw
In response to Migrating a Microsoft-SQL database to Postgres  (Josef Springer <Josef.Springer@JOOPS.COM>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Nee.mem(倪明)"
Date:
Subject: Fw: Re: Windows version of PostgreSQL 8?
Next
From: Ropel
Date:
Subject: Re: CreateTable --> schema not found