SQL 2000 and 2008 Instances - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

SQL 2000 and 2008 Instances

Author

Topic

DavidChel
Constraint Violating Yak Guru

474 Posts

Posted - 2009-08-03 : 16:15:29

The ERP system that I use is "stuck" in SQL 2000. The vendor states that it will not work, even in 2000 compatibility mode with any version of SQL higher than 2005.

Could I not install 2008 on the same server as a separate instance and then use the tools of 2008 to create SSRS and SSAS projects?

Can they read directly from the SQL 2000 databases?

If not, could I transfer data from the 2000 instance to the 2008 instance with log shipping or perhaps a simple daily back up and restore?

If necessary, I could set up 2008 on a separate server and then would attempt to move data from 2000 to 2008 periodically and run SSRS and SSAS on that. Would this work?

Any input would be appreciated.

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2009-08-05 : 20:41:36

quote:
Originally posted by DavidChel
Could I not install 2008 on the same server as a separate instance and then use the tools of 2008 to create SSRS and SSAS projects?

You can have multiple instances of different builds on same box.

quote:
Originally posted by DavidChel
Can they read directly from the SQL 2000 databases?

The client tools will work with some limitations.

quote:
Originally posted by DavidChel
If not, could I transfer data from the 2000 instance to the 2008 instance with log shipping or perhaps a simple daily back up and restore?

Yes either of these should work. However, its not backward compatible.. so you cannot logship/backup/restore from up level versino to a down level version.

quote:
Originally posted by DavidChel
If necessary, I could set up 2008 on a separate server and then would attempt to move data from 2000 to 2008 periodically and run SSRS and SSAS on that. Would this work?

Yes.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources