Hello, I have a question on importing a database from MSSQL 2000 to MSSQL 2005. I hope someone on here can help me answer it.
I am trying to import a database from MSSQL 2000 to 2005. But, when I tried to import it, the data and tables came in just fine, but the properties such as Identity Values, Column Defaults, Indexes did not import. Also the stored procedures did not import.
This causes a problem as I have a lot of tables and I have to manually go in and change the default values, indexes, and identity values.
I used SQL server management studio to import the database directly. But it doesn't seem to import everything as stated above.
Any help or suggestions would be appreciated. Thank you in advance.