These are just a quick list of things that I have noticed during imports from Microsoft SQL 2000 to Microsoft SQL 2008 R2 that, if you are doing this, you should watch for.  This is probably not the complete list of issues, but one's that I have noticed so far:

1. Stored Procedures do not get imported.  You will need to deal with these manually.
2. User-Defined Functions do not get imported.  You will need to deal with these manually.
3. Views get imported as tables instead of Views.  I've imported these manually as well.
4. There are much more strict rules in SQL 2008 R2, so some bad programming that may have passed in Stored Procedures and Functions in 2000 will not just come across, even manually to 2008 R2.  You may have some programming to deal with.

If you have more you would like to add, please feel free and I'll update the list.  I've found that this upgrade for a database is a royal pain unless it's a simple database to begin with.

This entry was posted on August 22, 2011 at 9:10 am. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Posted in Web Development / Programming by admin No Comments Yet