BBWells
07-07-2009, 05:43 PM
Dear DASP,
I have created my first .ASP site that populates about 60 pages with Rodeo Results. You can see the site here with test data at www.cfdresults.com (http://www.cfdresults.com). These .asp grid views are populated from SPROCs in the SQL data source; cfdresults.mdf and .ldf.
Here is what I need. This data needs to be "updated/refreshed" about 4x per day during the course of the rodeo.
Right now the site and SQL web server are hosted at Network Solutions. I do not have the rights to "attach" a database using SSMS 2008; and I cannot "restore" the database from a locally generated copy either. My only method at this point to get new data on the site is to open a support ticket requesting their server engineers attach or restore from a file I send them. This is totally unacceptable.
I am an noob with .ASP so I don't know how to write or code a web service to do this.
Here is the $6M question. If I transfer the hosting to DASP can I connect directly to the remote SQL Server and attach a new .mdf file and display new data using the SSMS, whenever I need to? Or, can I create a backup from the new data, upload (FTP) backup to remote SQL server and restore the database using the tools on the server?
If there is another way, please advise.
DESPERATE
Most grateful for a reply,
Brian Wells
I have created my first .ASP site that populates about 60 pages with Rodeo Results. You can see the site here with test data at www.cfdresults.com (http://www.cfdresults.com). These .asp grid views are populated from SPROCs in the SQL data source; cfdresults.mdf and .ldf.
Here is what I need. This data needs to be "updated/refreshed" about 4x per day during the course of the rodeo.
Right now the site and SQL web server are hosted at Network Solutions. I do not have the rights to "attach" a database using SSMS 2008; and I cannot "restore" the database from a locally generated copy either. My only method at this point to get new data on the site is to open a support ticket requesting their server engineers attach or restore from a file I send them. This is totally unacceptable.
I am an noob with .ASP so I don't know how to write or code a web service to do this.
Here is the $6M question. If I transfer the hosting to DASP can I connect directly to the remote SQL Server and attach a new .mdf file and display new data using the SSMS, whenever I need to? Or, can I create a backup from the new data, upload (FTP) backup to remote SQL server and restore the database using the tools on the server?
If there is another way, please advise.
DESPERATE
Most grateful for a reply,
Brian Wells