October 4, 2011 at 2:53 pm
Hi everyone,
I'm planning to migrate 15 tables(really huge) from SQL 2000 to SQL 2008? Backup/Restore is not being considered because there are 300 other tables and there is space issue as well.
Is it possible to automate the process(if it's done with 1 table it should proceed on to the next table)?
If someone has already done it, would you please provide the script to do it?
I'm not good with DTS but if someone has a sample package with error handling, that will be awesome.
Thanks.
October 4, 2011 at 7:53 pm
You could use different techniques like :
•DTS through either :
•Wizard of Import +Export of SQL Server Management studio of 2008 better (Just right click destination DB and identify the source DB)
•SSIS packages of BI Visual studio
•Bulk Merge codes of 2008 technology which superseded sufficiently old 2005 codes insert +update +delete
[font="Arial Black"]Performance Guard[/font]
[font="Courier New"]Just ask me to get 0 sec for all queries[/font]
October 4, 2011 at 9:55 pm
My favorite method of those listed is to use SSIS if you are looking to automate 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
October 5, 2011 at 8:33 am
Indeed, did something similar to what you are doing - i used ssis
October 5, 2011 at 11:08 am
SSIS may be the fastest performer but if you're not versed in it you can use bcp. It is quite fast when using Native format between two SQL Servers. You can run both of these command lines from the command line on the server hosting the 2008 instance as the bcp client will happily connect to a 2000 instance.
Get data out of source 2000 database:
bcp dbo.TableName out C:\Data\TableName.dat -n -S ServerInstanceName -T -k -d DatabaseName
Put data into destination 2008 database:
bcp dbo.TableName in C:\Data\TableName.dat -n -S ServerInstanceName -T -k -E -d DatabaseName
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply