We have many SQL 2000 servers and are beginning to plan our upgrade path. Has anyone had experience running SQL 2005 and SQL 2000 on the same machine This would be in a development environment to aid in our analysis. Is this possible Any issues or concerns
SQL 2005 and SQL 2000, one Dev server, co-existence
Hot Topic
- Separate date and time datatypes - come on guys!
- DTC Transaction Abort error
- Newbie: sql 2005 encryption --- or where do I put that key?
- How to get a row committed
- RS2005 Crashed After Editing and Restoring Config Files
- "Windows can not open this file: splash.hta" while trying to install SQL Server STD2005 through EN_SQL_2005_STD_X86_DVD.ISO fil
- Package executing correctly in Visual Studio, but NOT through Execute Package Utility
- Reporting Services Error -- Could not find stored procedure 'spPM_ProjectManager'
- Location of default instance SQL server 2005 files
- Help! hresult DTS_E_VARIABLEALREADYONREADLIST
SQL Server
- Inconsistent package failures
- SQL Agent Job fail
- Timeout Report Model Wizard
- Query performance
- How do you determine the size difference of transaction log per million INSERTs?
- can't get the complete list of tables owned by the dbo
- Conversation Groups
- SQL Server 2005 SP 1 Failed during Reporting Services installation
- UDT using Format.UserDefined and Hashtable -> Security Error in SQL 2005
- try to setup membership with ASP.NET configuration
SQL 2005 and SQL 2000, one Dev server, co-existence
cjb-
Dan
http://blogs.msdn.com/dtjones/
BillCondo
Dan
http://blogs.msdn.com/dtjones/
Ravi Krishnaswamy
I'm bit disappointed with lack of information about this topic. I would have thought most people will ask this question in the beginning before migrating.
Jake2
Your explanation is clear to me, however one thing isn't clear yet...
If I install only SQL 2005, can I support the SQL 2000 servers with it e.g. Can I edit my 'old' DTS, my 'old' measures within MSAS, etc Or do I need the SQL 2000 for these things
Thanks in advance,
Marco.
Matholroyd
This is supported, and you shouldn't have any problems as long as you install SQL 2005 after SQL 2000.
Ed Blankenship
I'm not an expert on the CDW. You should post this to: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=84&SiteID=1 for a quicker reposnse.
Sorry I couldn't help.
Dan
Dinesh Rathi
what SKU (enterprise, developer, express, etc.) is your SQL Server 2000
what SKU (enterprise, developer, express, etc.) of SQL 2005 are you trying to install
iknowstuff
Hello Dan,
I tried the copy database wizard between a SQL 2000 and a SQL 2005 server. I first registered the SQL 2000 on the SQL 2005 server. I could access all the tables and views.
Then I started the wizard and after a while a got the next message:
"The job failed. Check the event log on the destination server for details. (Copy Database Wizard"
In the event log I found two messages:
"Package CDW_SERVER1_SERVER2_1 failed" Event id 12291
and:
"SQL Server Scheduled Job 'CDW_SERVER1_SERVER2_1' (0x2c664338B69874418A6BE999ACBC972) - Status: Failed - Invoked on: 2005-11-11 10:05:39 - Message: The job failed. The job was invoked by User DEVELOP\Administrator. The last step to run was step 1 (CDW_SERVER1_SERVER2_1_Step)." Event id 208
So, still no database on the new server.
Any ideas
Thanks in advance.
Gerry Whitworth
I know you can use the new tools to upgrade your DTS packages but I'm not sure how much administration you can do to the SQL 2000 packages without upgrading them to full SQL Server Integration Services packages. We will have a download of the DTS designer that will give you full adminsitration capabilities but it's not available yet - it should be soon.
Cheers,
Dan
http://blogs.msdn.com/dtjones