Can I run an instance of SQL Server 2000 in SQL Server 2005?
I was planning on restoring a backup of my SQL Server 2000 db to SS 2005, but keep the SS 2000 configuration. The main reason for doing so is to maintain the DTS packages I have in SS 2000 because my understanding is that these are not easily duplicated in SS 2005 Integration Services.
Thanks-Dave
You cannot run "an Instance of SQL Server 2000 in SQL Server 2005".
However, you can attach a SQL 2000 database to SQL 2005, and leave the 'compatibility level' set for SQL 2000.
But perhaps you mean to ask if you can ALSO have a SQL 2000 server INSTANCE on the same computer as a SQL 2005 server Instance -and if so, that would be 'Yes'. (You would actually 'install' the SQL 2000 software...)
|||Arnie,
I do plan on attaching a SQL 2000 database to SQL 2005 and leaving the 'compatibility level' set for SQL 2000...
With that said, will I be able to access my DTS packages from SQL 2000? Where do I reference these in SQL 2005? If i'm running in SQL 2000 compatibility level will the SQL 2000 DTS packages function the same?
Thanks-David
|||When you Attach /Resotre a SQL Server 2000 database in SQL Server 2005 instance , the compatibility level will be 80 (that is of sql server 2000) for this database. But its nothing to do with DTS. For DTS in sql server 2005 , you have an option for backward compatibility.
Open your SQL Server 2005 -- You can find "Management " node expand it -- you will find "Legacy" -- under it DTS
you can import DTS package of sql server 2000 here and you can run. But i would always recomment to re-design the DTS packages in SSIS , coz you have to anyway migrate this if not today , tomarrrow
Madhu
|||Madhu,
Thanks for the response. I will import the SS 2000 DTS packages into SS 2205 and test. As for re-designing these in SSIS I will have to wait and see before moving forward.
David
sql