MSSQL 2005 import/export question
Hello, I wanted to ask a question on MSSQL. I am trying to move a MSSQL database from SQL 2000 to SQL 2005. I used the Server Management Studio to Import the database from the old server.
It seemed to work fine and the data and tables imported. However, it seems the properties such as Identity Values, Column Defaults, Indexes for the tables were not copied.
Is there any way to get the whole database including those properties to be copied so I don't have to go in each table and add them?
Any suggestion would be appreciated.
Thanks in advance.