August 22, 2008 at 5:04 am
I have inherited the upgrade of a major data warehousing project. Each night, information is transferred from an ERP system running on an AS/400 into a SQL 2000 database. The transfer uses a linked server to the AS/400 through an ODBC connection. The upgrade will be made to a box running SQL 2005. What options are available to move the data in this case? I am learning “on the job” so please excuse the “dumb questions”.
August 22, 2008 at 5:18 am
Hello,
The Linked Server should still work in SQL 2005. Do you specifically want to move to something else?
In which case, if you can find the budget, you could consider "DataMirror".
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
August 22, 2008 at 5:28 am
Hello again,
Rereading your post, may be I misunderstood your question. Are you asking about the daily transfer of data, or the migration of the DBs from 2000 to 2005.
In the first case my previous post applies, in the second case it depend on if you want to parallel run or have a straightforward back-out strategy. In which case look at a side-by-side installation rather than an upgrade of your SQL 2000 Server.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
August 22, 2008 at 5:47 am
Just interested in the most efficent way to move the data between the 2 environmants. Thanks for the updates!
August 22, 2008 at 5:57 am
Hello,
For data transfer, as well as sticking with the Linked Server, or buying DataMirror you could also consider an SSIS Package.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply