Updating MSSQL database remotely 1

[multiplex77]

Hi,

I have an ASP application that uses a MSSQL 2000 database. It has been installed on several client sites. Currently when ever I make changes to the database, I need to make a trip down to the client's site and run a SQL query (using Query Analyzer) to update the database. This is very time consuming and expensive for me because of the travel.

Does anyone have a suggestion of how I can just send a patch to them via email and have them install it themselves? I've thought of sending them the .sql file and have them run the query themselves, but is this the most professional way to do it?

Look forward to hearing your advice. Thanks!

 

[mrdenny]

You could compile a little app that looks all pretty to run the SQL Command.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[mrdenny]

You could compile a little app that looks all pretty to run the SQL Command.

Or have them give you remote access to the SQL Server, so you don't have to drive down.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[Corran007]

i would use osql utility in a batch file. osql can accept an input file as one of the paramaters. check out osql Utility in bol to see if that would work for you.

the patch would include a batch file that would run the osql and the actual input file that has the commands in it. try it out see if it works for you.

As another option if you dont feel comfortable useing batchs. you could create your own program ( i use vb.net) that does the updates and you just send the file for them to apply