Hello !

I'm using VB.net 2013 , Entity Framework 6 , SQL server 2008R2 and SMO.
I have the application that use the database.
But sometime I make changes to database structure , and I want to add to my application a "Refresh Database" command.
Let's say that I have a database model called "Model" ( as a .bak offline file). The refresh command should compare the current database with this model and after make all the changes needed to make the current database up to date according to model.

How this can be done using SMO ( or something else ) ?

Thank you !