Skip site navigation (1) Skip section navigation (2)

Re: Porting from MS SQL Server to PostGres

From: "Goulet, Dick" <DGoulet(at)vicr(dot)com>
To: <pwbyrne(at)hotmail(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Porting from MS SQL Server to PostGres
Date: 2004-09-24 15:06:14
Message-ID: 4001DEAF7DF9BD498B58B45051FBEA650146C760@25exch1.vicorpower.vicr.com (view raw or flat)
Thread:
Lists: pgsql-admin
Given the "fun" I've had with Sql*Server and it's sister Access, you'd be much better off porting things manually.  I'd precreate all of the tables/indexes and then move the data with the aid of Access or a similar ODBC tool.  As for the rest, re-write it as Tsql is more like VB than pgplsql.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: pwbyrne(at)hotmail(dot)com [mailto:pwbyrne(at)hotmail(dot)com]
Sent: Thursday, September 23, 2004 3:47 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] Porting from MS SQL Server to PostGres


Hi,

I'm looking for details, or tools about porting a full Ms Sql Server
2000 database to Postgres on Linux.

Is this possible?  We have the whole nine yards, stored procedures,
triggers, and all.  

Is there a way to automate this process?

Thanks

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

Responses

pgsql-admin by date

Next:From: Kris KigerDate: 2004-09-24 17:06:55
Subject: tsearch2 poor performance
Previous:From: Manolatos TilemahosDate: 2004-09-24 12:47:09
Subject: How to pass initdb LC_COLLATE & locale parameters when using windows? (with or without pginstaller)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group