ApexSQL Knowledgebase: ApexSQL Edit's Centralized Mapping

LINKS

General

Apex SQL Audit
Apex SQL Clean
Apex SQL Code
Apex SQL Diff
Apex SQL Doc
Apex SQL Edit
Apex SQL Enforce
Apex SQL Log
Apex SQL Script

Knowledgebase Home

SITE FEED

Site Feed

Support Forum

The fastest and most effective to get answers to your questions quickly. Click Here for more info.

FAQs

Quick answers to common questions. Click Here for more info.

Troubleshooting

Known issues and basic troubleshooting techniques for problems or unexpected behaviors. Click Here for more info.

Knowledgebase

Technical tips, How-to articles, and other tutorials about ApexSQL Tools. Click Here for more info.

Online Documentation

All of our help files for download or convenient viewing online. Click Here for more info.

Videos

Watch product demos, training videos, or tutorials of our products' main features. We frequently upload new videos so check often for updates. Click Here for more info.

ApexSQL Knowledgebase

Tips and How-to Articles for Apex SQL Tools

ApexSQL Edit's Centralized Mapping

DESCRIPTION
There are source codes for the client application; then there are source codes for database objects (create scripts). In this KB, we discuss how to use ApexSQL Edit to maintain a Source Code control system for the latter.

What is centralized mapping?
ApexSQL Edit offers you two methods of storing source code information:

1. Local
2. Central

Simply put, these two methods differ in the location where data is stored. The "Local" method literally uses a location on the workstation, while the "Central" method uses a dedicated SQL Server database to store the data. For a development team working simultaneously on one project, the Central method should be used.

How do you set up centralized mapping?
To set up centralized mapping, open the Options dialog by choosing Tools -> Options... from the Main Menu:

Here we find the Source Control Options:

This Source Control Option group is comprised of two items:

Our focus on this KB is "Mapping Options". By clicking on this item, you'll see the various mapping options and settings currently available in ApexSQL Edit:

The above screenshot shows how this dialog initially looks like with the default values. The first thing you need to do to set up centralized mapping is to select the central SQL Server database that should be used as source code repository. Place the cursor in the "Central Database" field and click

.

This opens the Login form where you can select the server and the database and provide your login credentials:

Once this is done, click on the Ok button. Next, set the "Source Control Data Store Type" from "NA" (this is only initially displayed and then disappears unless manually typed in) to "Central":

The general options for centralized mapping have now been set.

Mapping databases
Next, we map a database to our central data store. Using the Schema Explorer in ApexSQL Edit, you can easily check the mapping state of any database. Simply move the mouse over that particular database and ApexSQL Edit displays the mapping state of the database in a tooltip:

This shows that the SQL Server Northwind sample database is currently unmapped. To initiate the mapping process, right-click on the Northwind database node in the Schema Explorer and select Source Control... -> Map Database from the Context Menu:

This invokes the Source Control Mapping Wizard:

Click here for more information on the Source Control Mapping Wizard. Since we have already specified a central database, the Mapping Wizard displays the Setup Source Control Mapping Data Store page:

Selecting the "Centralized Data Store" option will activate the "Choose Connection" and "Create DB Schema" buttons.

The Choose Connection button

Clicking this button

enables you to choose your centralized data storage. There is no need to do this if you prefer to use the database already specified in the General option.

The Create DB Schema button

Clicking this button

enables you to initially set the central database that holds the source control data. All the necessary database objects will be created:

Follow the remaining steps of the Source Code Control Mapping Wizard as described in the online help. After the Mapping Wizard has successfully finished, you can see the changed mapping state when you move the mouse of the database in the Schema Explorer:

You have successfully set up a centralized data store in ApexSQL Edit.

AUTHOR
Frank Kirkland

LAST REVIEW
26 August 2007

Labels: Apex SQL Edit

posted by Janice Lee on Monday, July 16, 2007

0 Comments: