February 6, 2007 at 5:45 am
I’ve created a production scenario by restoring the prod_database backup to a different server. I have named the restore “Test_DB.” I have copied all the logins and passwords to the new server and now I’m trying to create a DTS process to copy two tables from the “Test_DB” to a newly created Doc_DB on the same server. Essentially, I’m trying to separate my documents tables from Test_DB and place them in a separate database called Doc_DB. The steps that I am taking are as follows: I open the databases, right click on Test_DB, choose all tasks and export data. I then choose the server name and database(test_db) that I want to export data from using sql authentication. I do the same to choose my destination db(doc_db). I then choose to copy objects and data between sql server databases. I uncheck copy all objects as well as use default options, and choose only the tables that I want to copy and I uncheck the top 3 security checkboxes in the default options. I in turn get this…
Error: Failed to copy objecs from Microsoft SQL Server to Microsoft SQL Server.
[SQL – DMO]The Bulk Copy execution failed.
I have been able to successfully copy the tables themselves without their objects etc. But now that I’m trying to copy all of the objects as well, it barfs. Any Ideas?
February 6, 2007 at 4:27 pm
I wasn't able to replicate your error.
What I normally do is to generate scripts on the source database, then run those scripts on the destination. Then I just do a regular copy tables and views to move the data over.
Russel Loski, MCSE Business Intelligence, Data Platform
February 7, 2007 at 7:19 am
That is exactly what I'm doing now...but I was just trying to understand why I was receiveing the error doing it the other way? Who Knows?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply