Publish Login to Production with Schema

In this post i am going to publish LocalDb to product database with some simple step in Visual Studio 2013 Edition with Sql Server 2014 .

1.Views ->Sql Server Object Explorer
2.Login to Your Data base by Windows Authentication
3.Right click the database+Extra data tier Application
4.Choose Schema or Data with database with yourName.dacpac
5.Then Publish Data tier with select yourName.dacpac file (it works as Backup file) and Target database will be your production.

Then check it works…

Leave a Reply

Your email address will not be published. Required fields are marked *