February 18, 2008 at 6:16 am
I've been tasked to create a staging Database for data warehouse. I need to extract about 89 tables. What would be the best way to copy all these tables. My live database is running SQL 2005 my staging DB is SQL 2000.
February 18, 2008 at 9:29 am
First you have to link the two servers together. Then I create a DTS package on the SQL Server 2000 to extract data from 2005 and load into the tables in 2000.
February 18, 2008 at 9:36 am
SSIS if this is repeatable.
If not, run the data export wizard.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
February 18, 2008 at 11:15 am
are you talking Data and Schema or just the Schema? You can use SSIS, DTS Depending on the server version, you can use a BCP to transport the data, The Import/export Wizard or just a simple backup and restore will do.
"We never plan to Fail, We just fail to plan":)
February 19, 2008 at 1:29 am
Thanks a lot.
I will first move everything Table and Data then data only.
February 21, 2008 at 1:06 am
I've setup linked server for 2 servers that I will be using. I can run a Query from sqlserver2000 querying sqlserver2005 database and the other way around. I then try to import table and data I got the following error Unable to connect to source server for Transfer. the error comes from DTS import/export wizard
February 23, 2008 at 7:41 am
hi
you can use SSIS 2005, it is most performent than DTS.
and you can planify your package in SQL server Agent to be executed every day, week, or month.
create SSIS project and use OLE DB source & destination component.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply