Cloning of SQL Server 7.0 and 2000 | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Cloning of SQL Server 7.0 and 2000Dear Sir,
We are planning to clone our existing ERP server which runs on SQL 2000, which I was told by vendor is no longer availbale for sale.
Can you advise if we can purchase a new SQL 2008 and downgrade it to SQL 2003 which is compatible to SQL 2000?
Welcome to the forums!
[quote user="sqlstarter"] new SQL 2008 and downgrade it to SQL 2003 which is compatible to SQL 2000? [/quote]
I can’t understand your question. There is no SQL 2003 version. Could you clarify?
[quote user="sqlstarter"] and downgrade it to SQL 2003 which is compatible to SQL 2000? [/quote]
Are you referring to SQL 2005? It too is not available for sale. However, you can run both SQL Server 2005 and SQL Server 2008 in SQL Server 2000 compatibility mode.
You need to verify with your vendor whether their software can work on SQL Server 2000 compatibility mode? Some software vendors have never tested their software on this. (Most probably it may work, but you need to make sure that they take the responsibility for it.)
You have multiple counters here, either you have to upgrade the database from SQL 7 to 2000 and then to 2008 version in order to take fullest advantage of the features. Next is to install SQL 2008 on new server then keep the source database under SQL 2000 compatibility mode (80) where you will not be able to take much of 2008 version features.
As you say this is a third party vendor, it is best to run by them to see whether application is compatible in connecting to a SQL 2008 instance though the database is in SQL 2000 compatibility mode, as Preeti referred above.
Do not rush the things …. better to plan and perform upgrade project.
[quote user="satya"]You have multiple counters here, either you have to upgrade the database from SQL 7 to 2000 and then to 2008 version in order to take fullest advantage of the features.[/quote]
Even though the subject line talks about SQL 7.0 and 2000, the actual question is only about SQL Server 2000. Is there something missing?
Preethi, true the thread itself is incomplete… hence we fly the different opinions, unless the OP clarifies its like that .