Category
主题
副主题
Database source control policy FAQs (4301259)
Summary ... This article gives answers to most frequently asked questions related to Database policies implemented in the shared development model. ... Optional policy ... A: Yes, object status icons are shown no matter which policy is active.
How to link a SQL Server database to a Git repository using the SSH protocol (4211286)
ApexSQL Source Control natively supports different protocols that can be used to connect to a Git repository. ... This includes HTTP, HTTPS, File and SSH protocols. ... In this article we‘ll go through the process of generating a key pair using Putty and OpenSSH and linking a database using the SSH protocol.
Working with static data (4213590)
This article explains how to work with static data in ApexSQL Source Control. ... Description ... The main focus of the ApexSQL Source Control tool is to track changes of object structure (schema level).
ApexSQL Source Control for a first-time user (4297575)
This article explains all necessary steps for successful use of ApexSQL source Control for the first time. ... ApexSQL Source Control is a Microsoft SQL Server Management Studio add-in, which integrate source control with SQL Server database development.
Object filtering FAQs (4214917)
Q: How to exclude objects from source control? ... A: Objects can be excluded from source control during the initial database linking process, in the Object filtering step, or at later stage from ApexSQL Source Control options and the Object Explorer pane for a single object.
How to utilize branching and merging with Subversion (4211452)
Similar to <a href="/utilize-branching-and-merging-team-foundation-server/" target="_blank">Team Foundation Server</a>, branching in Subversion means creating a new folder for each new branch. ... The content from a source branch is copied to a new branch, so the original branch is not affected by any changes committed to a new branch.
Source controlling custom scripts (4213476)
This article describes how to use the Custom scripts feature. ... In some situations, like the development of commercial software, it is a requirement to version control not only the database itself but custom SQL scripts and even programming code e.g.
How to use ApexSQL Source Control with local file system repositories (4214880)
The advantages of a local repository are easy setup and fast local data transfer since it bypasses the source control server. ... However, it is not recommended as a long-term solution because it is difficult to share it with other team members and setup a proper security for the repository.
Migration scripts introduction and general review (4297264)
This article describes how to work with the Migration scripts feature. ... Migration scripts are customizable SQL scripts created by user through ApexSQL Source Control containing any specific configuration changes, or overrides that need to be executed before or after applying an object change from source control, or they can be executed instead of a change.
Action center (4216211)
This article explains how to use the Action center tab to communicate with a source control repository in ApexSQL Source Control. ... Description ... The Action center tab is the central point of ApexSQL Source Control where all the current differences between the Database and Source control are presented.
How to utilize Team Foundation Server check-in policies (4215743)
that must be followed whenever a developer wants to check-in changes to a repository. ... Each policy that is previously set for the specific Team Foundation Server project requires a developer to take specific action prior to checking in changes.
How to resolve source control conflict (4216299)
Description ... Conflicts will be detected when the user made a change on an object version which is not the same as the one on the source control repository (the latest version). ... This is a common occurrence when two developers are working on the same object.
How to utilize branching and merging with Team Foundation Server (4219023)
Since branching in Team Foundation Server means creating a new folder (project) for a new branch and copying all the content from the initial folder to a new one, we’ll cover the process of linking a database to a folder (Team Foundation Server project) that will be treated as the main branch.
How to send an e-mail alert when a schema change occurs in a database (4273481)
model – which is used to track schema changes, help mark the objects as changed in the <strong>Object Explorer</strong> pane, enforce database policies, etc. ... This DDL trigger is important as it provides the functionalities mentioned above but it can be disabled or removed if the user wants to use only the basic functionalities of ApexSQL Source Control e.g. committing changes to the repository and reviewing the history of committed changes.
How to link a SQL Server database to a Mercurial repository (4218934)
This article describes how to link a SQL Server database to a Mercurial repository. ... Since a Mercurial repository can be accessed in various ways (using different protocols), we’ll go through these cases one by one.
How to link a SQL Server database to an Assembla.com repository using Perforce (4292409)
The <strong>D</strong><strong>epot</strong> field should always be “depot/main” as that is the internal structure of the depot defined in the P4HOST variable. ... </p> <p> ... The <strong>W</strong><strong>orkspace</strong> field represents the name of the workspace and it is left for the user to define it.
Object filtering (4298200)
This article explains how to work with the Object filtering feature in ApexSQL Source Control. ... Description ... Usually, there is no need to add all the database objects to source control at once.
How to treat Microsoft Team Foundation Server workspace to allow working with ApexSQL Source Control (4282919)
This article explains what to do and how to treat a Microsoft Team Foundation Server (TFS) workspace to allow working with ApexSQL Source Control and avoid common errors. ... <h2>Description</h2> <p>A Team Foundation Server workspace contains a set of working folder mappings.
Labels (4288869)
This article explains how to work with labels in ApexSQL Source Control. ... Description ... Labels represent a snapshot of current state of all objects in source control repository. ... That state can be restored at the later stage if there is a need for that.
Database development policies (4299368)
This article explains how to work with the Database development policies feature in ApexSQL Source Control. ... Description ... ApexSQL Source Control provides a possibility to establish and enforce behaviors among developers regarding source control, for example mandatory locking of files on checkout.
How to link a SQL Server database to a Subversion repository (4214912)
We’ll explain several situations related to the linking process that depend on the way the repository is specified and a protocol used to access the repository. ... </p> <p></p><div class="videoWrapper"><iframe frameborder="0" scrolling="auto" src="https://www.youtube.com/embed/IX5DP6ya-I4" width="640" height="360" allowfullscreen="allowfullscreen"></iframe></div> <h2>Description</h2> <p> For the purpose of this article, we’ll describe all supported protocols: file, HTTP and HTTPS.
How to split a column without data loss using migration scripts (4278415)
table will be used as an example. ... columns, respectively, without data loss. ... When this change is made by one developer and committed to source control, the rest of the team should be able to apply that change without the data loss on their sides, or making additional changes after applying this one.
The Red Gate Source Control add-in overrides ApexSQL Version database overlay icon in the Object Explorer pane (4216282)
Symptoms ... Case 1: ... A database is linked to a source control using ApexSQL Version, and the ApexSQL Version database overlay icons identify all linked databases: ... When the user links the same database to a source control via the Red Gate SQL Source Control add-in the ApexSQL Version database overlay icon will be overwritten:
Branching and merging FAQs (4299310)
This article gives a list of frequently asked questions about branching and merging in ApexSQL Source Control. ... Description ... Q: Is it possible to utilize branching regardless of the development model?
Script comparison and synchronization options in ApexSQL Source Control (4214919)
provides the ability to extensively configure how objects from a local database are scripted in order to be compared with or committed to a repository, as well as the way changes are applied. ... Those options can be initially set when a database is being linked to a version control system, in the <strong>Source control setup wizard</strong> window, under the <strong>Script options</strong> tab.
新产品关联性