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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 3:47 PM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
