PDA

View Full Version : Mssql 2008



RonRattie
April 25th, 2012, 01:22 PM
Quick question about MSSQL 2008.

Do you support connecting remotely from a Hostek MSSQL 2008 server to a outside MSSQL 2008 server?
Example: If I put up a site on hostek and there was a form that fed into one of your hosted SQL DBs.
Could I setup a connect so that nightly all new records were transferred to my external SQL Db?

Regards,
Ron

davidd
May 10th, 2012, 07:52 AM
We do not have any options on our shared MSSQL servers that would allow this to take place completely on the database layer. However, this would be possible with one of our VPS servers.

If I needed this functionality personally, the approach that I would probably take would be to create a script on the site that would access both servers and insert any new rows into the external database. I could then schedule the script to be run each evening.

Another option if you have administrative access to the external SQL server is that you could possibly setup an SQL job on the external server to import the data.

David D.