Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Data migration from 2005 to 2008, table structure not same? Expand / Collapse
Posted Wednesday, February 26, 2014 9:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 26, 2014 8:57 PM
Points: 1, Visits: 0
I need to migrate 10 yrs data from sql2005 table to sql2008 table where both tables have different columns. What is good approach here/ any tool? Suggestion?
Post #1545684
Posted Wednesday, February 26, 2014 11:43 PM



Group: General Forum Members
Last Login: Thursday, October 20, 2016 4:13 PM
Points: 20,009, Visits: 18,250
SSIS, tsql, linked servers could help get the job done.

You would probably want to batch the migration. It wouldn't be hard to do it via a sql agent job and run a regular schedule to migrate the top n records.

The hard part would be that you would need to do is map out the source to the destination columns.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...


Posting Performance Based Questions - Gail Shaw
Post #1545708
Posted Thursday, February 27, 2014 6:18 AM



Group: General Forum Members
Last Login: Today @ 12:26 PM
Points: 17,065, Visits: 31,963
You've pretty much outlined what SSIS was built for. But, there's no automatic way to do it. You'll have to build the processes by hand.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1545825
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse