February 26, 2014 at 9:04 pm
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?
Thanks
February 26, 2014 at 11:43 pm
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...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 27, 2014 at 6:18 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply