June 21, 2006 at 9:46 am
Hi everybody,
I have started the project using sql server 2K.
It turned out that we have to switch to SQL Server 7.
I would like to get advice about how to proceed?
Shoul I remove SQL Server 2K installation, install SQL 7 and then reinstall SQL 2K; or I can simply install SQL 7 besides instance of SQL 2K. I'm talking here about development mashine.
Also I would appreciate if I can get advice about how to (if possible painlesly) preserve all the databases I had on my 2K in case I have to reinstall 2K server.
I hope I was clear enough.
Thanks
June 22, 2006 at 2:40 am
I have no links to back this up, but I believe that you will be forced to uninstall SQL Server 2000 and then install SQL Server 7.
The databases are not backwardly compatible, so you will have to script / bcp them out of SQL 2000 and then recreate on SQL7. you must also perform a verification that no SQL 2000 specific features are being used, like UDF, TABLE variables, etc. Search BOL for "compatibility issues, between SQL Server 2000 and SQL Server 7.0"
Why not test with your SQL Server 2000 databases set to SQL Server 7 compatibility, in EM choose Properties for the database, choose the Options tab, and change the Compatibility Level to "Database compatibility level 70". This just might save you from reverting back to an "unsupported" version of SQL Server.
Andy
June 22, 2006 at 12:06 pm
Thank you very much for your comprehensive answer.
I will try SQL Server 7 Compatibility.
That will do it.
Thanks again Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply