VB.NET - database customization of erp w.r.to clients

Asked By siji on 20-Sep-13 02:03 AM
iam working in erp solution(vb.net front end,sql server 2005).it is a customized 
package .working in more than  50 clients .if i make a change in database .i willput the 
query in a notepad and update in each clent location.but handling notepad is a risk taking work for me.some times me or my supporting team forget to update notepad files with database queries.but exe will change.in this case database fields or stored procedueres mismatch wit h exe.error will come out.after reporting this error we updated the database changes.all things will be ok after this.but clients will irritated by this.so i need more flexible solution to update database.if any one have suggestions please guide me
thank u
Robbe Morris replied to siji on 20-Sep-13 07:43 AM
Write sql scripts and run them.

https://www.nullskull.com/a/833/net-setup-deployment--msi-cassini-sql-server-ntfs.aspx

https://www.nullskull.com/articles/20030609.asp

https://www.nullskull.com/a/696/sql-server-stored-procedure-script-generator-by-dependency-ii.aspx