This is not a programming question!
-
Just a theory.. We are currently using SQL 2000 in our Development & Production Environments. Due to the current Fiscal Climate I am having to find a justification to Potentially upgrade to SQL 2008, this will mainly centre around reporting tools.. We are currently using Reporting Services Addon for 2000. To this end I have come up with this scenario and want to run it past the community.. If I Download SQL 2008 Express with Reporting Services and install it on a seperate "Evaluation" Server, Is there anything stopping me using the existing SQL 2000 Datasources on that server for reporting? I just want to demonstrate to our managers the new reporting functionalities available, but connect to existing Data. Mainly so we have a comparisom over a period of time of 2008 & 2000 running side-by-side. Once a (positive) decision has been made Hopefully I will be able to fully upgrade the SQL 2000 Databases Could this work or are there licensing issues? I dont really want to have to install an evaluation that runs out after 60/90 days as they can be very slow to make decisions here!
-
Just a theory.. We are currently using SQL 2000 in our Development & Production Environments. Due to the current Fiscal Climate I am having to find a justification to Potentially upgrade to SQL 2008, this will mainly centre around reporting tools.. We are currently using Reporting Services Addon for 2000. To this end I have come up with this scenario and want to run it past the community.. If I Download SQL 2008 Express with Reporting Services and install it on a seperate "Evaluation" Server, Is there anything stopping me using the existing SQL 2000 Datasources on that server for reporting? I just want to demonstrate to our managers the new reporting functionalities available, but connect to existing Data. Mainly so we have a comparisom over a period of time of 2008 & 2000 running side-by-side. Once a (positive) decision has been made Hopefully I will be able to fully upgrade the SQL 2000 Databases Could this work or are there licensing issues? I dont really want to have to install an evaluation that runs out after 60/90 days as they can be very slow to make decisions here!
Forgot to mention I wouldnt want to put the SQL 2000 databases into 2008, just link from SQL 2008 Reporting Services to SQL 2000.
-
Just a theory.. We are currently using SQL 2000 in our Development & Production Environments. Due to the current Fiscal Climate I am having to find a justification to Potentially upgrade to SQL 2008, this will mainly centre around reporting tools.. We are currently using Reporting Services Addon for 2000. To this end I have come up with this scenario and want to run it past the community.. If I Download SQL 2008 Express with Reporting Services and install it on a seperate "Evaluation" Server, Is there anything stopping me using the existing SQL 2000 Datasources on that server for reporting? I just want to demonstrate to our managers the new reporting functionalities available, but connect to existing Data. Mainly so we have a comparisom over a period of time of 2008 & 2000 running side-by-side. Once a (positive) decision has been made Hopefully I will be able to fully upgrade the SQL 2000 Databases Could this work or are there licensing issues? I dont really want to have to install an evaluation that runs out after 60/90 days as they can be very slow to make decisions here!
afaik the only limit to using sql express in a production environment is that it's optimized for 4 concurrent users. For a test of the reporting services this shouldn't matter.
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots. -- Robert Royall
-
afaik the only limit to using sql express in a production environment is that it's optimized for 4 concurrent users. For a test of the reporting services this shouldn't matter.
Today's lesson is brought to you by the word "niggardly". Remember kids, don't attribute to racism what can be explained by Scandinavian language roots. -- Robert Royall
Are you sure about that? It used to be a 'feature' of MSDE but that has changed for Sql Express.
-
Are you sure about that? It used to be a 'feature' of MSDE but that has changed for Sql Express.