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! :)

link|improve this question

43% accept rate
feedback

2 Answers

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...

link|improve this answer
feedback

Backup and Restore? Detach and Attach?

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

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