By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,483 Members | 1,063 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,483 IT Pros & Developers. It's quick & easy.

Question on MSSQL 2005 database import

P: 1
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.
Dec 20 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.