Showing posts with label transfer. Show all posts
Showing posts with label transfer. Show all posts

Wednesday, March 7, 2012

Data Migration using SSIS in SQL 2005


Greetings,

I am using SQL Server 2005 and I want a clue if there is some good built-in support to do the following.

I want to transfer all the data from one source database to another destination database having same number to tables and schema like source database. I also want to ensure that the old data on the destination database should be secure too.

I have an idea that this can be done through SSIS in coding but can anyone give me a guide, tip, link, sample code that can be helpful.

Thanx a million in advance.

Regards

Try the link below for code samples from DTS/SSIS expert. Hope this helps.

http://www.sqlis.com/

Saturday, February 25, 2012

data migration from sql server 2000 to 7.0

Hi ,
I want to transfer the data from SQL server 2000 to a SQL server 7.0
Can anyone help me in providing the steps I need to follow..
Thanks in advanceHow much data, how often, how much time allowed?

Easiest way which is still low impact probably is to produce a staging table on the 2000 server with an identity and the data that has to be transferred.
The v7 server has an identical table but with an int for the ID field.
Thev7 calls a stored proc on 2000 with its last ID via a linked server or remote server (could even use replication for this but I wouldn't advise it). This sp returns the next 500 say (recs) which the v7 server inserts into its staging table.
The v7 server can then do whatever it wishes with the data (may have a status field on the recs to say they have been processed.

This has very little impact on the 2000 server as it's production processes just have to get data into the staging table - doesn't matter if the v7 server is down.
If the v7 server has to be restored then it will automatically recover the data from the v2000 server. You will have to cater for the 2000 server being restored though.