Solved

Copy SQL Database to another server

Posted on 2011-02-17
7
325 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

776 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