December 30, 2013 at 7:32 am
We have an existing windows application using a database. We migrated to web application using the same database, but made few changes like changing the table name and added few columns in tables.
Now if my customer has this windows application already installed in his system and he now migrates to web application.
My requirement is , if my customer already has the windows application database installed in his system, he need not install new database for web application.
What is the best way to migrate the changes from web application database to the already installed windows application database?
December 30, 2013 at 9:28 am
Have you got a db upgrade script? You should be able to include this as an executable to upgrade the in-situ db.
If not you can use a third party app such as Red Gates SQL Compare to generate the difference script. You will need to account for the fact that any new columns will not have existing data populated on the old rows but the tool should get you started.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply