Try Red-Gate tool, Its great.
There is a free demo. http://www.red-gate.com/index3.htm Regards Dale Fraser <http://learncf.com/> http://learncf.com <http://flexcf.com/> http://flexcf.com From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Wednesday, 26 November 2008 12:02 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Copying databases between virtual machines i tried both a DTS transfer and tried to attach the db and both didnt work. I am suprised the attach didnt work though. _____ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Wednesday, 26 November 2008 11:57 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Copying databases between virtual machines How are you copying exactly? Regards Dale Fraser http://learncf.com <http://learncf.com/> http://flexcf.com <http://flexcf.com/> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Wednesday, 26 November 2008 11:50 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Copying databases between virtual machines Dont know if anyone can help but no harm in asking I have a virtual machine wihich has an mssql2000 database on it. I recently made a copy of it and took it into the datacenter and loaded onto one of my servers. The VM runs fine but now i am trying to copy a database from my local VM to the one in the datanceter but i am getting an error message saying that i cant copy the database because the source and destination are the same database. I am connecting to them both using different IP addresses which i thought would have been enough but its not playing nice. Anyone else come across anything like this? Steve <BR --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---