Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

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 heard this was not available with the free express version.

I need to move a moderately sized database to another computer. How can I most easily accomplish this task?

We are not in a position to buy any software at the moment.

Thanks for any suggestions! :)

share|improve this question
up vote 1 down vote accepted

By default there's no tools visible in the IDE but you can access the DTSWizard to do import/export if you've got the SQL with Advanced Services installed (free).

You'll find it in Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe - I add it as an External Tool in the Tools menu for ease.

But if you're just moving the whole DB then then joeqwerty's options should do you fine...

share|improve this answer

Backup and Restore? Detach and Attach?

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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