Hi,
I'm trying to import data to my database on the live server from my local server. However when I do this it doesn't seem to be importing the properties for the fields in the tables. How can I import the properties of the fields too?
Thanks,
Curt.
What do you mean by properties? And how are you doing the import?
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.
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!
