November 11, 2002 at 1:42 pm
What are the things to look for if we buy a benefits package that was witten in 6.5, upgraded to sql2000, but we have sql7. We were told "it should work but ..."
I'm interested in asking the developer "do your sp use xyz" and thus will only work in 2000?
Am interested in any responses. Thanks
November 11, 2002 at 3:49 pm
user defined functions
computed columns
indexed views
table variables
bigint datatypes
These are some of the things that are new to 2000 from sql7.
The database would have to be created in sql7 as databases are not backwardly compatible.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
November 11, 2002 at 3:55 pm
Databases in 2000 cannot be resotred to 7 and 7 databases attached to 2000 servers cannot be moved directly back. There are internal changes made to the file that make them incompatible. The best you can do is create the tables, views, constraints, procedures, udts, roles and user accounts on the 7 server and using the Export wizard in the 2000 move the data. Keep in mind that some code items and features available in 2000 are not available in 7.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply