September 30, 2005 at 3:37 am
I have two databases, with each a table X and I want to transfer only the data.
These tables are identical, the same number of rows, the same types, etc.
BUT the destination table has another physical order of the rows.
For example :
Table X source database : column row_id, column empl_id, column text
Table X destination database : column row_id, column text, column empl_id
When I do a database.Transfer, I'm never returning from the function, no exception at all
The CPU is 100% and the SQL profiler is returning nothing.
When I kill the application I can see suddenly in the profiler the query, but the data isn't transferred.
Using the DropDestObjectsFirst object is not a choice, because of constraints.
When using the DTS wizard in the enterprise manager, no problem, the data is transferred.
When I recreate the table X in the destination database so that it is exactly the same (also physical), there is no problem, the data is transferred.
Has somebody an idea?
(I'm running sql2000 sP3)
October 3, 2005 at 8:00 am
This was removed by the editor as SPAM
March 17, 2006 at 2:59 pm
I have run into a similar problem and all I did was drop the constraints, truncate the table, transfer the data and recreate the constraints. This should not be a problem especially if the same constraints exist on the source table.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply