Error at Transfer Objects Task: The source server can not be the same as the destination server.
SQL Server 2005 - June CTP
Error at Transfer Objects Task [Transfer Objects Task]: The source server can not be the same as the destination server.
Why not? I'm trying to transfer a set of tables from one database to another. Both databases happen to be on the same server. I understand that the source *database* cannot be the same as the destination *database*. But why can't I use the Transfer Objects task to transfer objects from one database to another on the same server?
Thanks for your help!
I bumped into this problem several weeks ago and was only told "there are known problems with the transfer objects task"
My work around is to use an execute sql task that uses a fully qualified Insert statement to insert records into database 2 from database 1
Insert database2.dbo.tableA select * from database1.dbo.tableA
While it is a royal pain to have to have a line per table (250+ tables..changing on a regular basis) it does work and I get my records from the staging DB to the production
Paul Pisarek
As far as I can see, with the production release of VS 2005, the original bug which I reported 'the source server cannot be the same as the destination server' has been corrected. I just used the Transfer SQL Server Objects task to transfer all objects (i.e. Tables, Views, Data, Indexes, etc.) from one database to another on the same server.
What 'issues' specifically are you encountering?
- Joe Geretz -
