be useful to start by looking at Live size or Live instances. Click on the column heading to sort the column, and look for classes with a
be useful to start by looking at Live size or Live instances. Click on the column heading to sort the column, and look for classes with a
the differences between your Development Database and your Schema Model on disk and save this into an artifact (in temp folder) for later
of a database. Please check our reference usage guide and sample scripts for more details. Clones A clone is a live clone (i.e. perfect r
/testdatamanager/redgate-test-data-manager-overview/glossary
-ServerInstance "staging01\sql2012" -Database "Staging" -Username "sa" -Password "P@ssw0rd" $test = New-DlmDatabaseConnection -ServerInst
/dlma2/using-sql-compare-options-with-dlm-automation-cmdlets
-ServerInstance your-server\sql2012 -Database WidgetStaging -Username sa -Password p@ssw0rd $productionState = New-DlmDatabaseConnection
/sr1/worked-examples/deploying-a-database-using-powershell-scripts
= New-DlmDatabaseConnection -ServerInstance "prod01\sql2014" -Database "Production" -Username "sa" -Password "P@ssw0rd" Test-DlmDatabaseC
and finishing the setup in MySQL Workbench, execute the following at a command prompt: mysql -uroot -p Enter your password when prompted.
Start scan of a registered database. Syntax Start-ClassificationDatabaseScan [-FullyQualifiedInstanceName] <string> [-DatabaseName] <strin
. The classification is stored in SQL Data Catalog only, no live database is modified. Parameters -SourceInstanceName <String> The fully-q
/sql-data-catalog/automation-with-powershell/powershell-cmdlet-reference/copy-classification
" -Username "sa" -Password "p@ssw0rd" $DB2 = New-DlmDatabaseConnection -ServerInstance "your-server\sql2014" -Database "WidgetProduction"
/dlma1/get-started/get-started-with-the-dlm-automation-cmdlets/deployment
Server user name to use to log in if you are using SQL Server authentication. -P -P <SQL_Server_password> Specifies the password to use t
nmap -p {port} --script ssl-cert {address} openssl cat /dev/null | openssl s_client -showcerts {address}:{port} 2>/dev/null | openssl x50
subsetting by any outside process. For example it must not be a live production database. The target database must: Be distinct from the
commands. PreDeployReport Compare the contents of Subversion with a live database and generate a report of the differences. Command Line
/ddfo/worked-examples/basic-ci-with-teamcity-or-jenkins-jobs
" -Database "Staging" -Username "sa" -Password "P@ssw0rd" $package = "C:\NuGetFeed\database.nupkg" $update = New-DlmDatabaseRelease -Sourc
"sa" -Password "P@ssw0rd" Sync-DlmDatabaseSchema -Source $scriptsFolder -Target $test This example show how to update a test database to
The following DLM Automation addon steps use SQL Compare to compare database schemas: Build (to validate the scripts folder against a tem
> Specifies the SQL Server user name to use to log in if you are using SQL Server authentication. -P -P <SQL_Server_password> Specifies th
, and will not accept a masking set file. To create a masked image from a live database, install Data Masker on the same machine as the SQ
/clone2/modifications-during-provisioning/image-modifications/data-masking
an image file is created. An image contains the source data from which clones can be derived. It can be created either from a live SQL Se
an image file is created. An image contains the source data from which clones can be derived. It can be created either from a live SQL Se
, and will not accept a masking set file. To create a masked image from a live database, install Data Masker on the same machine as the SQ
/clone3/modifications-during-provisioning/image-modifications/data-masking
-ServerInstance "your-server\sql2014" -Database "WidgetStaging" -Username "sa" -Password "p@ssw0rd" $DB2 = New-DlmDatabaseConnection -Ser
/dlma2/get-started/get-started-with-the-dlm-automation-cmdlets/deployment
against a live production database. It is recommended to restore a backup, and run the subsetter against the restored database. Features
/testdatamanager/command-line-interface-cli/subsetting/subsetter-release-notes