Your third option is what you want I think. Right-click on your DB in management studio -> tasks -> copy database. It brings up a wizard that will let you choose to copy it locally without bringing ...
We have an ancient AS/400 730 system that still houses some old budget/financial data. We'd like to decommission this box, and migrate the data to a SQL server. The data won't be modified or changed ...