Copy SQL Database to another server
Posted on 2011-02-17
I have an SQL database on a server on a clients site. I can connect via VPN to their site and access their SQL Server using my copy of Microsoft SQL Server 2008 R2 (Express Edition) and can create a backup of the database. The backup is obviously created locally on their server and I do not have access to copy the backup file from their system to mine.
As I can access both my local SQL Server and their remote SQL Server is there a way to 'copy' their database to my server?
Googling this seems to suggest that there is a database copy wizard somewhere but I think this must only be part of the commercial version of SQL Server as I do not have it under tools.