?
Solved

Copy SQL Database to another server

Posted on 2011-02-17
7
Medium Priority
?
337 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
Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

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…
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

762 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