I want to import data from a live site database into a development database (SQL Server 2005 Express) using the DTSWizard. Once I copy/paste the live database to my dev machine, I cant attach the live site database because it has the same name as the database on the dev site.
A simple solution I would assume is to change one of the names. But I can't seem to change the "orignal file name".
A backup/restore won't work for me because I made table/field changes to the dev database.
--Dietrich
Are you using SQL2000 or SQL2005?
Hi Dietrich,
1. Before copying the database .mdf and .ldf files, you'd better first make the database offline.
2. Copy the database to your new machine, and rename them.
3. In the new database server, attach the database and you can specify new name of the database.
HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!
No comments:
Post a Comment