September 4, 2002 at 3:12 pm
Hello,
I maintain an internal Windows application for a client. The front end is VB.Net and the backend is SQL Server. Occasionally I have to change the data structure of the database. Installing updates at the client site is a major pain if they don't have the query analyzer for SQL Server. I am wondering if there is a tool to update the structures automatically?
Thanks
Jim
Thanks
Jim
September 4, 2002 at 4:21 pm
You can execute scripts using DMO pretty easily. Make a lite QA for them to apply changes with, or possibly even build into your app - have a pickup folder where they would place scripts to be run. If your app has rights to apply the changes. Could be a security hole done that way too.
Andy
September 6, 2002 at 10:15 am
You should be able to redistribute osql.exe, which uses ODBC or OLEDB and run scripts through that automatically without the whole client tool install.
Steve Jones
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply