1 / 21

Visual studio-databas-project

Visual studio database project assists you in <br>designing deployment dialogue(s) in a compact time and with <br>more manageable steps.<br>

clariontech123
Download Presentation

Visual studio-databas-project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Visual Studio DataBase Project Copyright 2019 Clarion. All Rights Reserved

  2. Visual studio database project helps you in creating deployment script(s) in short time and with simpler steps. Overview

  3. Manual Process* • List out all the database related changes that needs to be deployed. • Right click on database object in SQL Server and create the script based on the need like ‘Create/Alter/Drop’ script. • Execute all those scripts on Targeted database one-by-one. Note* Manual Process might miss out the dependent object script(s).

  4. Process using Database Project • Create Database Project from File > New project > Sql Server(Template). • Right click on project from solution explorer and select ‘Schema compare’. • Configure and Select ‘Source’ and ‘Target’ database. • Click ‘Compare’ button in the Schema Compare Window toolbar to start the comparison process. • When the comparison is completed, select the appropriate schema changes. • Update the schema directly by clicking on ‘Update’ button or generate the script from ‘Generate Script’ button and then execute it on Targeted database.

  5. Advantages of using Database Project • Reduce Manual work • Save deployment time • Easily deployable in any conditions • Helpful in versioning db object / deployment scripts • Automatically detects dependent objects • It will cover all schema related changes like Table, Column Data type/size change, Constraints, User defined objects, View, Indexes, properties etc

  6. Prerequisite Disadvantage of using Database Project • Can be time consuming due to server traffic/speed • Active connection can interrupt schema comparison process • Visual studio ( 2015 / 2013 / 2012 / 2010 / 2008 / 2005 )

  7. Lets get started

  8. Create Solution Create Database project Select ‘Schema compare’ object Select Source and Destination database(s) Start Comparison Start Comparison for both schema Generate Script Select schema changes from the comparison list and click on ‘Generate Script’ Compare schema Database selection Start Comparison Generate Script

  9. Step 1 Create Database Project

  10. Step 2 Right click on project from solution explorer and click on ‘Schema Compare’

  11. Step 3 Select respective ‘Source’ and ‘Target’ db

  12. Step 3 Configure ‘Source’ and ‘Target’ db

  13. Step 4 To start comparison bw both schema, Click on ‘Compare’

  14. Step 4 Comparison will list out the differences found in both schema

  15. Step 4 Comparison will list out the differences found in both schema

  16. Step 4 Select the respective db objects

  17. Step 5 Click on ‘Generate Script’

  18. Step 5 Generated Script based on selected db objects

  19. Step 5 Generated Script based on selected db objects

  20. Step 5 Generated Script based on selected db objects

  21. Thank You Copyright 2019 Clarion. All Rights Reserved

More Related