Click here to Skip to main content
15,888,144 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Entity Framework : Filter child entities Pin
dilkonika1-Feb-15 5:02
dilkonika1-Feb-15 5:02 
AnswerRe: Entity Framework : Filter child entities Pin
Kenneth Haugland1-Feb-15 19:09
mvaKenneth Haugland1-Feb-15 19:09 
GeneralRe: Entity Framework : Filter child entities Pin
dilkonika2-Feb-15 4:45
dilkonika2-Feb-15 4:45 
GeneralRe: Entity Framework : Filter child entities Pin
Kenneth Haugland2-Feb-15 4:55
mvaKenneth Haugland2-Feb-15 4:55 
GeneralRe: Entity Framework : Filter child entities Pin
dilkonika2-Feb-15 5:13
dilkonika2-Feb-15 5:13 
QuestionOverriding events in an inherited Control Pin
Sam Marrocco30-Jan-15 9:20
Sam Marrocco30-Jan-15 9:20 
AnswerRe: Overriding events in an inherited Control Pin
Mycroft Holmes1-Feb-15 11:59
professionalMycroft Holmes1-Feb-15 11:59 
QuestionUpdate a database structure according to a model Pin
dilkonika29-Jan-15 18:16
dilkonika29-Jan-15 18:16 
Hello !
I have project in vb.net using a sql server 2008r2 database and Entity Framework.
Several clients are using this program.
But sometimes I make modifications to program and to database structure ( for example new fileds are added to several tables , new tables are added...etc ).
I give to the clients the new ".exe" file , but the problem is that their database is not up to date according to my last modifications.
Let's suppose that I have the new database model as a empty SQL server backup file "Model.bak".
I want to add in my applications a "Update Database" command. This command should do the update process of the current client database according to the new structure of "Model.bak".

I want suggestions , how can I do this on vb.net ? ( I don't want to do this with other tools and programs. I want to give users only the new ".exe" file and the new template "Model.bak" and do te update process from my application )

I read somewhere that is possible to prepare a updating sql script that can do this process.
If this Is true , I have some questions :
1) How this script can be created ?
2) Is possible to store this script inside the "Model.bak" file , and to call inside my program ?

If this story of the script it's not true , any other suggestions ?
Thank you !
AnswerRe: Update a database structure according to a model Pin
Richard Deeming30-Jan-15 1:26
mveRichard Deeming30-Jan-15 1:26 
GeneralRe: Update a database structure according to a model Pin
dilkonika30-Jan-15 18:07
dilkonika30-Jan-15 18:07 
AnswerRe: Update a database structure according to a model Pin
Mycroft Holmes30-Jan-15 13:44
professionalMycroft Holmes30-Jan-15 13:44 
GeneralRe: Update a database structure according to a model Pin
dilkonika30-Jan-15 18:16
dilkonika30-Jan-15 18:16 
GeneralRe: Update a database structure according to a model Pin
Mycroft Holmes31-Jan-15 21:09
professionalMycroft Holmes31-Jan-15 21:09 
GeneralRe: Update a database structure according to a model Pin
dilkonika2-Feb-15 4:35
dilkonika2-Feb-15 4:35 
GeneralRe: Update a database structure according to a model Pin
Mycroft Holmes2-Feb-15 11:44
professionalMycroft Holmes2-Feb-15 11:44 
QuestionVB.Net programming Pin
John Schlaff28-Jan-15 16:26
John Schlaff28-Jan-15 16:26 
AnswerRe: VB.Net programming Pin
Richard Deeming29-Jan-15 1:02
mveRichard Deeming29-Jan-15 1:02 
QuestionShellExecute problem Pin
AccessDeveloper28-Jan-15 6:52
AccessDeveloper28-Jan-15 6:52 
QuestionRe: ShellExecute problem Pin
jkirkerx28-Jan-15 8:13
professionaljkirkerx28-Jan-15 8:13 
AnswerRe: ShellExecute problem Pin
AccessDeveloper29-Jan-15 6:45
AccessDeveloper29-Jan-15 6:45 
GeneralRe: ShellExecute problem Pin
jkirkerx29-Jan-15 7:54
professionaljkirkerx29-Jan-15 7:54 
QuestionStringBuilder Pin
KukuhSP28-Jan-15 2:52
KukuhSP28-Jan-15 2:52 
AnswerRe: StringBuilder Pin
Richard MacCutchan28-Jan-15 4:26
mveRichard MacCutchan28-Jan-15 4:26 
GeneralRe: StringBuilder Pin
KukuhSP28-Jan-15 5:16
KukuhSP28-Jan-15 5:16 
GeneralRe: StringBuilder Pin
Richard MacCutchan28-Jan-15 5:27
mveRichard MacCutchan28-Jan-15 5:27 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.