Utility to Convert MS SQL Server to Postgres

On Saturday 11 November 2006 01:26, novnov wrote:

Any recommondations for a util that helps with conversion of MS SQL Server
databases to Postgres? Constraints, triggers, etc?

Thanks

There are a couple of articles on this at
http://www.postgresql.org/docs/techdocs.3, which I believe have some pointers
to afew scripts. (Right click and save to file any pdf docs you run across)

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

You can use the DTS of SQL Server by specifying ODBC source for PostgreSQL.

Thanks,
-------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

I didnt' think that DTS would export all ascpects of a MS SQL database
(constraints etc), which task specifially does that?

Shoaib Mir wrote:

You can use the DTS of SQL Server by specifying ODBC source for
PostgreSQL.

Thanks,
-------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 11/12/06, Robert Treat <xzilla@users.sourceforge.net> wrote:

On Saturday 11 November 2006 01:26, novnov wrote:

Any recommondations for a util that helps with conversion of MS SQL

Server

databases to Postgres? Constraints, triggers, etc?

Thanks

There are a couple of articles on this at
http://www.postgresql.org/docs/techdocs.3, which I believe have some
pointers
to afew scripts. (Right click and save to file any pdf docs you run
across)

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

--
View this message in context: http://www.nabble.com/Utility-to-Convert-MS-SQL-Server-to-Postgres-tf2611970.html#a7305557
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Thank you I'd not seen that page.

Robert Treat wrote:

On Saturday 11 November 2006 01:26, novnov wrote:

Any recommondations for a util that helps with conversion of MS SQL
Server
databases to Postgres? Constraints, triggers, etc?

Thanks

There are a couple of articles on this at
http://www.postgresql.org/docs/techdocs.3, which I believe have some
pointers
to afew scripts. (Right click and save to file any pdf docs you run
across)

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

--
View this message in context: http://www.nabble.com/Utility-to-Convert-MS-SQL-Server-to-Postgres-tf2611970.html#a7305567
Sent from the PostgreSQL - general mailing list archive at Nabble.com.