Posted by Plamen Ratchev on 11/26/07 04:06
If the host that has SQL Server 2005 allows remote connections, then you can
download SQL Server Management Studio Express
(http://msdn2.microsoft.com/en-us/express/bb410792.aspx) and use it to run
queries. You will need the IP address (or full DNS name) of the host (and
valid account credentials) to register in SSMS. The link above has the
download for SQL Server Books Online which is the official documentation for
SQL Server 2005 and will be useful to find your way around SSMS.
However, some hosts do not allow remote connections. In that case you would
have to use some mechanism to load the data via a Web page on your site.
There are different ways to do it. I prefer loading via XML files as both
..NET and SQL Server 2005 provide good support to parse XML data. Essentially
you would load the new data via files and then build some routines to
process and update the appropriate tables. Alternatively, this process could
be fully automated via Web service that feeds data changes.
HTH,
Plamen Ratchev
http://www.SQLStudio.com
[Back to original message]
|