March 21, 2012 at 11:29 am
Hi,
I want to migrate data from SQL 2000 (running in 6.5 compatibility mode) to SQL 2012.
Is it possible? or do i need to move it to SQL 2005/2008.
If some guide or steps will be helpful.
Thanks,
Mickey
March 21, 2012 at 11:44 am
It depends on what you want to do with the data. If it's a straight table-to-table copy, with the same structures, then this should be quite easy to do.
You should even be able to use the Import wizard in SSMS to build the package for you.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 21, 2012 at 12:05 pm
Using SSIS to move the data or the Data import can do it for you.
Alternatively, you could backup the databases and restore to a 2005/2008 server first - upgrade the compatibility mode, then backup and restore to 2012. That is a very significant jump in DBMS - will the app support it?
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
March 22, 2012 at 10:16 am
Thanks for your reply!
The schema of tables is different in both databases. Also, source database will have transactional records, so we need to run the package many times or at interval of sometime.
Is this possible with SSIS?
Thanks,
Mickey Mouse
March 22, 2012 at 1:56 pm
Oh. I didn't know you were trying to move multiple databases into a single database. That wasn't mentioned previously.
If you are trying to build a mechanism to sync data from two databases on a regular basis, we need considerably more information than what you have provided.
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
March 23, 2012 at 2:52 am
Hi,
Information i can give right now is that,
Source database - sql 2000 6.5 compatibilty mode
Destination database - sql 2012
Schema in both are different.
please let me know if its feasible and any links for sample is appreciated.
Thanks!
March 23, 2012 at 6:14 am
It's feasible.
You'll just have to put a bit more development effort in it.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 23, 2012 at 7:36 am
SSIS can definitely do that. It's the tool I'd use for it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2012 at 9:03 am
Agreed with the others. I use SSIS to do this sort of thing all the time.
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
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply