Solved

Copy SQL Database to another server

Posted on 2011-02-17
7
323 Views
Last Modified: 2012-06-27
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.
0
Comment
Question by:ChrisMDrew
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 9

Expert Comment

by:Ken Fayal
ID: 34914731
One option is to generat a script of all database objects in a new query window - including scripting data.  Then run that script on your local SQL Server.
0
 
LVL 2

Expert Comment

by:treetop3
ID: 34914768
Express version will not allow you to do this as it is the free version.

How big is the Database?

Can you gain access to mapped network share and copy it to that?
0
 
LVL 7

Expert Comment

by:mkobrin
ID: 34915095
if you are using remote desktop to connect to their server you can set to share your drives in the advanced options when you make the connection and then you can copy the file as if it is a file on your machine.
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 7

Accepted Solution

by:
mkobrin earned 500 total points
ID: 34915109
Alternatively in the SQL management studio you can right click on your databases, select all tasks and then import. You can then choose to import their data base. Be carefull with the identity columns.

0
 

Author Comment

by:ChrisMDrew
ID: 34915190
Unfortunately I cannot RDP or map drives so it has to be something I do within SQL I think.  I'll try the All Tasks>Import and see if that works
0
 
LVL 2

Expert Comment

by:treetop3
ID: 34915381
Depending on how big the DB is you could use FTP

Can an admin give you access to mapped share
0
 

Author Closing Comment

by:ChrisMDrew
ID: 34965191
Thanks - this works but not really what I want to do as pretty long winded.  I ended up just getting them to email it to me...
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now