Thread: Utility to Convert MS SQL Server to Postgres
Any recommondations for a util that helps with conversion of MS SQL Server databases to Postgres? Constraints, triggers, etc? Thanks -- View this message in context: http://www.nabble.com/Utility-to-Convert-MS-SQL-Server-to-Postgres-tf2611970.html#a7289969 Sent from the PostgreSQL - general mailing list archive at Nabble.com.
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)
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
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.