pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Porting 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>
  2004-09-24 20:57 ` Re: Porting from MS SQL Server to PostGres Rosser Schwarz <rosser.schwarz@gmail.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 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>
  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