Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am looking for a tool to copy a sql database tables, stored procedures, functions etc and also the data contained within the database from a server to my local pc. Both have sql server management studio 2008 installed. Any tools that would be recommended to do this?

share|improve this question

closed as off-topic by Mokubai Jul 23 '15 at 18:11

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions seeking product, service, or learning material recommendations are off-topic because they become outdated quickly and attract opinion-based answers. Instead, describe your situation and the specific problem you're trying to solve. Share your research. Here are a few suggestions on how to properly ask this type of question." – Mokubai
If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 6 down vote accepted

You can do a backup and then restore it on your PC, or you can detach the database and copy the logs and db and reattach on both your pc and the server.

share|improve this answer

There is a free xSQL Bundle edition that may work for you, in case you need to keep the two databases in sync (URL). The limitations of the lite edition are:

  • up to 25 tables
  • up to 40 views
  • up to 40 stored procedures
  • up to 40 functions
share|improve this answer

Another alternative, if you can temporarily bring the server offline/detach the Database is to copy the MDF and LDF files, copy them over and reattach them on your computer.

Otherwise, the SQL Server BACKUP and RESTORE commands will work well.

If you have access to SQL Server Management Studio, it can be done from the GUI by right-clicking on the database's icon and using the items in the contextual menu.

share|improve this answer
That isn't another alternative - it is "copy the logs and db". :) – The Dag May 12 '12 at 14:51

If you are looking to do it on a regular basis (say from a production machine to a development machine), take a look at the Red Gate tools @

I use the software frequently for determining changes to schema or for syncing data between my production machines and local development machines. The software isn't free but worth the money if you have the need.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.