pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPorting from MS SQL Server to PostGres
3+ messages / 3 participants
[nested] [flat]
* Porting from MS SQL Server to PostGres
@ 2004-09-23 19:47 pwbyrne@hotmail.com
0 siblings, 0 replies; 3+ messages in thread
From: pwbyrne@hotmail.com @ 2004-09-23 19:47 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Porting from MS SQL Server to PostGres
@ 2004-09-24 15:06 Goulet, Dick <DGoulet@vicr.com>
0 siblings, 1 reply; 3+ messages in thread
From: Goulet, Dick @ 2004-09-24 15:06 UTC (permalink / raw)
To: pwbyrne@hotmail.com; 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@hotmail.com [mailto:pwbyrne@hotmail.com]
Sent: Thursday, September 23, 2004 3:47 PM
To: pgsql-admin@postgresql.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@postgresql.org
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Porting from MS SQL Server to PostGres
@ 2004-09-24 20:57 Rosser Schwarz <rosser.schwarz@gmail.com>
parent: Goulet, Dick <DGoulet@vicr.com>
0 siblings, 0 replies; 3+ messages in thread
From: Rosser Schwarz @ 2004-09-24 20:57 UTC (permalink / raw)
To: Goulet, Dick <dgoulet@vicr.com>; +Cc: pwbyrne@hotmail.com; pgsql-admin
while you weren't looking, Goulet, Dick wrote:
> I'd precreate all of the tables/indexes and then move the data...
If you have a lot of data, it's probably better to punt on creating
the indices until after you've moved the data. Bulk populating
indexed tables, particularly if the table has more than just the
primary key index, can be awfully slow. At one point, we tried
dumping several million tuples into a table with a dozen-odd indices.
Only did that once.
/rls
--
:wq
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-09-24 20:57 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-09-23 19:47 Porting from MS SQL Server to PostGres pwbyrne@hotmail.com
2004-09-24 15:06 Re: Porting from MS SQL Server to PostGres Goulet, Dick <DGoulet@vicr.com>
2004-09-24 20:57 ` Rosser Schwarz <rosser.schwarz@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox