August 23, 2010 at 12:10 am
Good afternoon everyone
I am currently developing a new website and try to see how i could explore my data stored in our corporate 2008 SQL server . The data i want to display is not changing too much and instead of having ASP or PHP pages accessing directly the DB for requesting similar outputs and overloading the DB, i would like to create twice a day web pages which would contain HTML tables, stored them on my web server and would be accessed direcly by the users.
I spent the whole afternoon exploring on the Web, the different possibilities such as SQL server Agent, reporting services but don' t really know how to achieve such a task...
Would any of you could give some ideas, some simple ways on how to do that?
-Creating the output based on my query or view
-Put it on my web server to be accessed by web users.
Thanks a lot in advance for your help
Sylvain
August 23, 2010 at 1:23 pm
You may use the Scheduled Reporting feature in SSRS
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 24, 2010 at 10:03 pm
Thanks Adiga
We don' t have reporting services with a report server installed in our SQL Server configuration.
Is there any other ways using a stored procedure for example to be executed periodically through a SQL Server Job in order to store the result page in my web Server?
Thanks
Sylvain
August 24, 2010 at 10:48 pm
Here is one such example.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 24, 2010 at 10:49 pm
One more example[/url] at SSC using SSIS
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 5 posts - 1 through 4 (of 4 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