May 26, 2009 at 9:32 am
Can a sql 2005 database that has a web front end, utilize a SQL Server 2008 reporting services database for reporting?
May 26, 2009 at 11:53 am
Can a sql 2005 database that has a web front end, utilize a SQL Server 2008 reporting services database for reporting?
If you mean using your SQL Server 2005 database as a datasource database for full implementation of SSRS 2008 the answer is yes but you will need to design and create Views and separate stored procedures so you will not create performance and deadlock issues for using same resources for both web and reporting.
The other option is to use SSIS package to populate another database and use that as your reporting datasource.
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy