July 27, 2010 at 6:43 am
In a off-line vb.net app (about 20 users) which will use local SQL saver to store all objects, such as tables, store procedures. How to update local server store procedures in each lap top if I update store procedures in server? For example, I create a new store procedure, sp_order_new, I want to load it into 20 lap top local SQL server to be ran for app. So far, I have to update it in all lap top local SQL server. I knew that this is not the best way but I have no idea of how to.
July 27, 2010 at 7:41 am
You may choose your pick from the options available in Replication.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 27, 2010 at 9:10 am
I would second a look at replication
If you don't want that, you would have to run a script on each server to add the stored procedure. You can script that if everyone is online, but it's cumbersome if they are not all connected at once.
July 27, 2010 at 11:16 am
Replication sounds like a good option to me for that. Other options may take us beyond SQL Server to creating a package that gets deployed to the laptop when the laptop signs-on to the network.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply