March 5, 2012 at 12:35 am
I have a SQL Server 2005 based application that is being hosted by a third party on the web. The application is written in Java and collects data entered by my customers on my web site. It looks like a could save significant money by porting the application to a SQL Server 2008 Web Edition. Looking at a feature comparison, it looks like the most significant limitation is the lack of a SQL query tool.
I understand from a 2009 post to this forum that
>>SQL Server 2008 Web may be used only to support public and Internet accessible web pages, web sites, web applications and web services. It may not be used to support line of business applications (e.g., Customer Relationship Management, Enterprise Resource Management and other similar applications).
Are there any third party open source web tools that could be used to provide a SQL query tool to the web edition. My intention is not to do development on the web site, but I occasionally find a need to quickly fix some erroneous data. The fastest way to do this is through the use of SQL going against the web hosted database. Would this violate the license?
My normal mode of operation is to develop an application on my internally licensed copy of SQL Server, upload the code and data to the web server, let my customers enter data for their event, download the data to my local server, process the data and upload the new data and reports back to the web server for customer access.
Any other gotchas I should be aware of? Thanks!
March 5, 2012 at 1:52 am
You can query the remote web edition using your locally installed SSMS.
SSMS Express can be downloaded free of charge and used to query any edition of SQL Server. Honestly, I don't know if that would break the license.
If you're looking for a query tool, you could use SQirreLSQL.
-- Gianluca Sartori
March 5, 2012 at 10:20 am
Thanks for the quick reply. I will check both those options out.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply