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 can easily reproduce this. I would agree with Joseph, moving between databases on the same server is a legitamate requirement.-Jamie|||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|||Paul,
Sorry about the curt response. Please reactivate the bug and follow through until you're satisfied with either the explaination or the resolution.
thanks,
ash|||
Dear Sharma,
Could you please update everyone whether the bug is resolved or yet to be resolved as we are facing a lot of issues in this task even after installing Service Pack Sp1.
Thanks,
Pradeep
+91 99451 20960
Pradeep.au@.gmail.com
|||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 -
No comments:
Post a Comment