Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Copy SQL Database to another server

Posted on 2011-02-17
7
Medium Priority
?
339 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 7

Accepted Solution

by:
mkobrin earned 2000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

618 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