February 1, 2007 at 7:48 am
Ok, Folks. I finally got these tables to copy over to my new database. BUT, as I was setting up the database for replication I noticed that the Primary Key fields were no longer set within the two tables that I copied? Is this normal? What else has been lost? Are the indexes still set? etc. Any ideas.
February 1, 2007 at 10:24 am
The Transform Data task only moves data. Use the Copy SQL Server Objects task to copy tables and all their attributes. Alternatively, you can create the tables in the destination database then copy the data.
Greg
Greg
February 5, 2007 at 8:19 am
I tried copying the objects and the data but received this error: [microsoft][ODBC SQL Server Driver][SQL Server] The login 'Datawarehouse does not exist.
While doing this process I noticed that all the tables where being copied over to the new database. I only want a select few. Is there a way to select only a couple tables to copy along with its objects and data?
February 5, 2007 at 8:38 am
Nevermind, I think I've got it figured out!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply