Chat now with support
Chat with Support

ApexSQL Build - Knowledge Base

Filter Your Results

Category

Product Version

Topic

Subtopic

Filter Search Results

Search Knowledge Base by keyword

(Choose different product)



DateRelevanceViews Displaying 1-25 of 122
What authentication method does ApexSQL use? (4377107)

When including ApexSQL tools on you environment, it is important to understand the authentication types available. ... <p><img alt="1" src="https://prod-support-images-cfm.s3.amazonaws.com/KB_kA0RP0000002TcD0AU_authenticationapexsql.png"></img></p>

Product(s): ApexSQL Compare and Sync Toolkit Subscription, ApexSQL Analyze, ApexSQL...
Last Updated On: 9/26/2024
NA rating | 425 views
FAQ
ApexSQL Offline Activation Failed to login (4375394)

Merge License files, the file should look like the one from below:

Product(s): ApexSQL Fundamentals Toolkit Subscription, ApexSQL Build, ApexSQL...
Last Updated On: 4/16/2024
NA rating | 6153 views
Knowledge Article
ApexSQL Snapshot utility throwing Invalid name character error (4374798)

The &#39;&lt;&#39; character, hexadecimal value 0x3C, cannot be included in a name</pre> <br> The error is reported as a bug # 230622 for the ApexSQL Snapshot utility inside ApexSQL Diff, ApexSQL Doc, ApexSQL Build.

Product(s): ApexSQL Build, ApexSQL Diff, ApexSQL Doc
Last Updated On: 2/8/2024
NA rating | 1424 views
Knowledge Article
ApexSQL Licensing Permissions Requirements (4373139)

When trying to open ApexSQL 2022 version products, an &quot;Internet connection is required to continue&quot; message comes up. ... ApexSQL 2022 version tool does an internet connection verification process by pinging id.quest.com <br>And needs to reach <span style="font-size: 11.0pt;"><span style="font-family: &quot;Calibri&quot;,sans-serif;"><a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Flicensing.ism.quest.com%2F&amp;data=05%7C01%7CNodier.Garcia%40quest.com%7Cebe23feb25c24b96aa7708dbb45616ad%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C638302054068664027%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=07YCu2O3DF5omdsa8njCOb9hDj%2Flsdo02nXJzjwJvp8%3D&amp;reserved=0"

Product(s): ApexSQL Doc Subscription, ApexSQL Source Control Subscription, ApexSQL...
Last Updated On: 9/13/2023
NA rating | 20844 views
Knowledge Article
How to build a SQL database from source control without dependency problems (4288499)

Even if a single copy of the database isn&#39;t shared among the developers, but rather each developer has its own local copy of the database objects&#39; scripts which are synchronized with source control on a regular basis, building a deployment SQL script may prove to be a rather challenging task.</p>

Product(s): ApexSQL Build, ApexSQL Source Control
Last Updated On: 5/7/2023
NA rating | 608 views
Knowledge Article
How to build a SQL database directly from scripts (4283908)

How to build a SQL database directly from scripts &quot;<p> In a SQL database lifecycle two major deployment tasks are: the building of a new SQL database and an upgrade of the existing one. ... ApexSQL Diff is a <a href="" target="_blank">SQL database comparison</a> tool that can help for both of them; it allows deploying SQL scripts saved in a script folder to a new or an existing SQL database.

Product(s): ApexSQL Backup, ApexSQL Build, ApexSQL Diff
Last Updated On: 5/7/2023
NA rating | 1321 views
Knowledge Article
How to activate ApexSQL software manually (4216052)

To activate an ApexSQL product online, a Hardware ID and a product activation key are needed. ... To manually activate an ApexSQL product online: ... Navigate to ‘ Product activation’ web page ... Select the ApexSQL product to be activated from the ‘Product’ pick list and the appropriate product version from the ‘Version’ pick list

Product(s): ApexSQL Analyze, ApexSQL Audit, ApexSQL BI Monitor, ApexSQL Backup...
Last Updated On: 5/7/2023
NA rating | 15749 views
Knowledge Article
SQL Server bulk copy and bulk import and export techniques (4277577)

SQL Server bulk copy and bulk import and export techniques &quot;<p> Sometimes, it is necessary to export or import large amounts of data into or out of a database. ... Those operations are called bulk export and import operations.

Product(s): ApexSQL Build, ApexSQL Data Diff
Last Updated On: 5/7/2023
NA rating | 706 views
Knowledge Article
How to check whether you can safely deploy to production database (4287843)

How to check whether you can safely deploy to production database &quot;The time when source control systems were used only for code development is gone. ... Today, database versioning is quite common, even in small companies.

Product(s): ApexSQL Build, ApexSQL Diff
Last Updated On: 5/7/2023
NA rating | 753 views
Knowledge Article
How to work with SQL database source control labels (4307110)

How to work with SQL database source control labels &quot;<p> A SQL database source control “label” or “tag” (aka revision tag) (name depends on the particular source control system) represents a snapshot in time of the source control repository and its contents.

Product(s): ApexSQL Build, ApexSQL Diff, ApexSQL Source Control
Last Updated On: 5/7/2023
NA rating | 1089 views
Knowledge Article
Create a database script from a backup without restoring it (4272918)

Create a database script from a backup without restoring it &quot;There are certain situations when creating a build script from a database is necessary – when a specific object (table, view, stored procedure, user, etc.) needs to be recreated or rolled back to a state it had earlier.

Product(s): ApexSQL Build, ApexSQL Diff
Last Updated On: 5/7/2023
NA rating | 560 views
Knowledge Article
How to create a SQL build script from the source control repository (4287807)

How to create a SQL build script from the source control repository &quot;<p>It’s quite common for developer teams to use database object versioning. ... The creation scripts for every table, view, stored procedure, and other objects in the database are added to a source control system.

Product(s): ApexSQL Build, ApexSQL Source Control
Last Updated On: 5/7/2023
NA rating | 596 views
Knowledge Article
How to automatically build a database from SQL Server source control (4278366)

section in the <strong>Optional information</strong> tab, where a script version number can be specified and it will be written in the script header of the created build script. ... Additionally, the <strong>Increment build number automatically </strong>option can be checked and each time this process is run, the build number will be increased.

Product(s): ApexSQL Build, ApexSQL DevOps Toolkit
Last Updated On: 5/7/2023
NA rating | 787 views
Knowledge Article
How to deploy static data from SQL source control to database (4287666)

Static data can be linked and committed to source control using various tools and approaches. ... The goal for this article is to cover deploying database static data from SQL source control to database using <a href="" target="_blank">ApexSQL Build</a>.

Product(s): ApexSQL Build, ApexSQL Source Control
Last Updated On: 5/7/2023
NA rating | 584 views
Knowledge Article
SQL Server database continuous integration workflow BUILD step – Building a SQL database from a source control repository (4300313)

In this article, the second <strong>Build</strong> step of the CI workflow will be described. ... The <strong>Build </strong>step is a step in which a database is built using the latest changes in the source control repository and once the build process is finished, a feedback of success/failure is provided to developers.

Product(s): ApexSQL Build, ApexSQL DevOps Toolkit, ApexSQL Source Control
Last Updated On: 5/7/2023
NA rating | 1235 views
Knowledge Article
How to create a SQL database build script directly from a backup (4293042)

There is no need to waste time and resources on restoring the SQL Server database backup. ... </p> <p> ... As seen in the screen shot above, precise information about the creation time and date were included for each differential backup as well as the full backup.

Product(s): ApexSQL Build, ApexSQL Diff
Last Updated On: 5/7/2023
NA rating | 808 views
Knowledge Article
Setting up the Source control wizard for a Git repository (4216313)

This article explains how to set up the Source control wizard for the Git repository in ApexSQL applications. ... Description ... A prerequisite for setting up the Source control wizard in ApexSQL application is creating a repository on one of the hosting services.

Product(s): ApexSQL Build, ApexSQL Data Diff, ApexSQL Diff, ApexSQL Script, ApexSQL...
Last Updated On: 5/7/2023
NA rating | 1873 views
Knowledge Article
Minimal SQL Server permissions for ApexSQL Developer tools (4216304)

Description ... In order to properly use ApexSQL Developer tools certain minimal SQL Server permissions need to be allowed on databases that are being used. ... Required permissions ... Required permissions are public SQL Server role and the public role membership that need to be configured along with the login.

Product(s): ApexSQL Build, ApexSQL Complete, ApexSQL Data Diff, ApexSQL Decrypt...
Last Updated On: 5/7/2023
NA rating | 4867 views
Knowledge Article
Save project as automation script (4213614)

Most ApexSQL tools have a CLI switch to consume a project file. ... This allows for the simplicity and ease of using a project file but also for unattended automation of a batch file or a PowerShell script.

Product(s): ApexSQL Build, ApexSQL Compare, ApexSQL Data Diff, ApexSQL Diff, ApexSQL...
Last Updated On: 5/7/2023
NA rating | 3156 views
Knowledge Article
All about ApexSQL database installer packages (4214921)

This article explains all about ApexSQL database installer packages. ... ApexSQL products offer two ways of database packaging: An executable installer and a C# solution. ... The difference between these two is that C# solution is source code that can be edited and built in Visual Studio, while the Executable installer is the compiled end product that cannot be edited.

Product(s): ApexSQL Build, ApexSQL Data Diff, ApexSQL Diff, ApexSQL Script
Last Updated On: 5/7/2023
NA rating | 1498 views
Knowledge Article
Using ApexSQL's Snapshot Utility (4216317)

This article describes the ApexSQL Snapshot Utility and how to use it in other ApexSQL applications. ... This article describes the ApexSQL Snapshot Utility and how to use it in other ApexSQL applications.

Product(s): ApexSQL Build, ApexSQL Diff, ApexSQL Doc
Last Updated On: 5/7/2023
NA rating | 1021 views
Knowledge Article
Transfer SQL logins for users with a large number of SQL-authenticated logins (4298006)

SQL Server logins are the credentials that enable users to connect to the Database Engine instance. ... One SQL login can be mapped to only one user in each database. ... Database users represent the identity of a SQL Server login when connected to a database.

Product(s): ApexSQL Build
Last Updated On: 5/7/2023
NA rating | 174 views
Knowledge Article
ApexSQL Build Command Line Interface (CLI) switches (4300405)

Format: <span style="font-family: Consolas;font-weight: bold;">/include_static_data</span> </td></tr><tr><td colspan="1" rowspan="1" valign="top" class="polje1" style="font-family: &#39;Consolas&#39;;font-weight: bold;border: none;width: 50px;">/invalid_objects

Product(s): ApexSQL Build
Last Updated On: 5/7/2023
NA rating | 345 views
Knowledge Article
How to re-order scripts to avoid dependency-based errors (4301160)

Having a database scripted to a script folder or to a source control, it enables to use these DDL scripts to recreate it. ... However, it might not go smoothly due to some missing dependencies. ... <p>When creating a database object from scratch, the needed objects are created along the way.

Product(s): ApexSQL Build
Last Updated On: 5/7/2023
NA rating | 205 views
Knowledge Article
How to use regular expressions (RegEx) in SQL Server to generate randomized test data (4213386)

A regular expression (abbreviated regex or regexp and sometimes called a rational expression) is a sequence of characters that forms a search pattern, mainly for use in pattern-matching and "search-and-replace" functions.

Product(s): ApexSQL Build
Last Updated On: 5/7/2023
NA rating | 255 views
Knowledge Article
Search All Products
Recommended Content
Updating results
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Technical Support
View All