Last post Jul 05, 2016 06:36 AM by Angie xu - MSFT
Jul 04, 2016 08:53 PM|claudia888|LINK
I'm supporting an asp.net MVC3 application, which use SQL server 2008 R2.
I'm preparing for a new release, where there are several new tables added, and a couple stored procedures got changed, also to a table, a new column has been added - this is the difference between my dev laptop and the db sever in our dev environment.
My question is: how do I migrate the new tables + stored procedure changes + new column for a table from my dev laptop to the Dev DB Server? They both are using SQL server 2008 R2.
Also: after the deployment to the dev server is done, I will need to make the same change to Prod DB server. what is the best way to do that?
Note: the dev db server has a SQL Agent Job set up, which my dev laptop does not have. I want to keep this Agent Job untouched on the Dev DB server.
If anyone can provide step-by-step instruction, that'd be great.
Any suggestion is appreciated,
Jul 05, 2016 04:17 AM|anuj_koundal|LINK
Hi You need to make script of your database objects. Follow these:
In the fifth image where author has described to select "Schema and data" change this to "Schema only".
Jul 05, 2016 06:36 AM|Angie xu - MSFT|LINK
guide shows a database change and related code changes, test the changes in Visual Studio, then deploy the update to the test, staging, and production environments.
It is available for your situation.