Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

2 Answers 2

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
add comment

Backup and Restore? Detach and Attach?

share|improve this answer
add comment

Your Answer

 
discard

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.