Question on MSSQL 2005 database import

  • 123bargains
  • Newbie
  • Newbie
  • 123bargains
  • Posts: 14

Post 3+ Months Ago

Hello, I have a question about 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. However, when I tried to import it, the data and tables came in just fine, but the properties such as Identity Values, Column Defaults, Indexes didn't import. Also the stored procedures did not import either.

I used SQL server management studio to import the database directly.

Any suggestions would be appreciated. Thank you in advance.
  • joebert
  • Fart Bubbles
  • Genius
  • User avatar
  • Posts: 13504
  • Loc: Florida

Post 3+ Months Ago

The Windows forum might be a better place for this question, left a pointer in Programming in case anywhere there has an answer for you though.
  • grinch2171
  • Moderator
  • Genius
  • User avatar
  • Posts: 6810
  • Loc: Martinsburg, WV

Post 3+ Months Ago

Have you read this:
http://www.campus.ncl.ac.uk/databases/s ... o2005.html
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23455
  • Loc: Woodbridge VA

Post 3+ Months Ago

See if this helps

Looks like what you need.
  • 123bargains
  • Newbie
  • Newbie
  • 123bargains
  • Posts: 14

Post 3+ Months Ago

Thank you so much for the fast reply. I will review those sites and get back on whether they contain the info I need. Again, thanks for the fast response. I really appreciate it.
  • 123bargains
  • Newbie
  • Newbie
  • 123bargains
  • Posts: 14

Post 3+ Months Ago

Would running this above script on the new database I copied onto the SQL 2005 copy those stored procedures, default values, etc… on the new database without erasing the contents already in the tables?

What is the best way to make an EXACT duplicate of a MSSQL 2000 database onto another MSSQL 2005 server? I just want an exact copy including the tables, contents, stored procedures, index, default values, auto increment, and everything in the old database.

Thanks for your help.
  • Rabid Dog
  • Web Master
  • Web Master
  • User avatar
  • Posts: 3245
  • Loc: South Africa

Post 3+ Months Ago

Have you tried to just attach the file to your SQL 2005 instance?

Post Information

  • Total Posts in this topic: 7 posts
  • Users browsing this forum: No registered users and 48 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.