December 20, 2005 at 7:10 am
Has anybody had any experience trying to export/push data from SQL Server 2000/2005 to a Postgres database? I currently have a SQL Server 2000 server at running at the corp HQ. We have approx 300 store locations and have been asked to look into replacing the current system at the stores with a PostGres DB. Management doesn't want to go with SQL Server because of licensing cost. I have seen where people have ported a SQL Server db to a PostGres db but has anyone had a SQL Server "replicating" to a PostGres db?
December 20, 2005 at 7:50 am
You might try using a linked server or http://pgfoundry.org/projects/dbi-link/
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
December 21, 2005 at 4:57 am
H!!!,
Yes we have done complete migration form SQL server 2000 to postgres by porting data from six diffrent databses to Postgres due to licencing issue for one of our client(app 1 crore records ) .
1) First you have to take the table ceation and constraints from sql server change the syntax and run in postgresdb
2) port data using DTS or PG data import
3)change the syntax for procedures and functions and run in PostgresDB
4) If you feel any difficulty you can use SQL ways 3.0 tool for migrating ,but the trial version will truncate column name to six characters in table creation script as well as procedures (which should be changed mannualy)
regards,
Vinod (DBA)
HTC Global Services ph 09840856202
December 21, 2005 at 8:24 am
There should be no technical obstacles, but depending on requirements there are several possible solutions.
How often must the data be transferred; nightly or near real-time? How much data will be transferred (# of tables, # of records)? Are the criteria applied the same or different for each client?
It seems that your intent is to keep SQL Server as the master copy; correct?
It's great that you are considering a mixed environment. Keep us informed as to your decision and progress.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply