Search all the documentation for " ȿ cia169.net ̱þ˸ ͳ ƱԹ 彺̴ȿ Ծ౹ عٶ ˸ Ť ǰ ߱ġ ۿ"
https://documentation.red-gate.com/fd/flyway-cli-and-api/concepts/migrations#sql-based-migrations - database-specific syntax (such as PL/
('Hello'); END // DELIMITER; CALL AddData(); -- Placeholder INSERT INTO ${tableName} (name) VALUES ('Mr. T');
the T-SQL file that is generated when you perform a Build in Visual Studio, eg. AdventureWorks\bin\Debug\AdventureWorks.sql. This file co
, providing history and allowing you to revert any changes. To do this, set up a comparison project: Click image2016-8-31 13:17:39.png (Ne
/sc14/worked-examples/worked-example-using-a-scripts-folder-as-a-data-source
are created, and the type of authentication: visual-svn-server-authentication.jpg SVN authentication requires you to set up users and cre
/soco3/working-with-source-control-systems/setting-up-a-subversion-svn-server
Server Log in order for SQL Monitor to detect the deployment and mark it on the timeline for performance data. Picture1.png Once you depl
to classify. The example below shows all columns from Database_4 and Database_8 on a given SQL Server instance, that are primary keys. im
/sql-data-catalog/classification/manually-classifying-sensitive-data
); RAISE_APPLICATION_ERROR(-20078,'You can''t ' || ora_sysevent || ' ' || ora_dict_obj_owner || '.' || ora_dict_obj_name || ', it was loc
/soco4/using-source-control-for-oracle/locking-objects/setting-up-object-locking
Compare if it is not already running. The Project Configuration dialog is displayed: image2018-9-6_10-48-44.png You can edit the current
/sc15/worked-examples/worked-example-comparing-and-deploying-two-databases
documentation. Click generate-documentation-icon.png Generate documentation. On the Generate Documentation dialog box, in the Save in box
/sdoc4/generating-and-viewing-documentation/generating-the-documentation
:59.png This will display the connection dialog, from which you can either browse to the desired server or enter the connection details: i
and deploy them manually. To detect all BLOB columns in a database, these queries are useful: SELECT o.[name] AS [Table Name],c.[name] AS
/sdc14/troubleshooting/error-messages/troubleshooting-system-outofmemoryexception-during-comparison
. image2020-2-13_11-0-15.png image2020-2-13_11-0-57.png Error For annotating errors. Use SpecificInfo to specify error. image2020-2-13_11-
with the ALTER INDEX REORGANIZE or ALTER INDEX REBUILD T-SQL statements. There are many factors that you should consider carefully before
could result in slow queries when reading data, whilst having underused indexes can unnecessarily slow down writes. image-2024-1-15_10-31
reading data, whilst having underused indexes can unnecessarily slow down writes. image-2024-1-15_10-31-22.png Configuring indexes Index
choice. Note that for a class this will expand all the methods automatically, so in the picture above selecting "Text" will copy the enti
/ref11/working-with-net-reflector/using-the-net-reflector-power-commands
a table or view in the list of tables. image2016-8-31 15:48:43.png By default, all rows with differences are selected for deployment. Use
/sdc14/reviewing-the-comparison-results/viewing-the-row-differences
in to the GitHub website, go to the Applications https://github.com/settings/applications page, and click Generate new token: image2015-3
/soco4/troubleshooting/authentication-failed-when-cloning-from-github
this task twice before SSMS reports the database as being offline. or Make sure you are connected to the master database, then run the fo
need to run this task twice before SSMS reports the database as being offline. or Ensure you are connected to the master database, then r
/rp/sql-hyperbac/troubleshooting-sql-hyperbac/stopping-the-sql-hyperbac-control-service
choice. Note that for a class this will expand all the methods automatically, so in the picture above selecting "Text" will copy the enti
/ref10/working-with-net-reflector/using-the-net-reflector-power-commands
-> Logging -> Minimum log levels, and then click the required log level. image2016-8-31 15:29:56.png Select a minimum log level based on
. Launch Redgate Change Control from the start menu and click Open project... image2019-12-6_19-44-19.png Navigate to your existing Flyway
/rcc4/developing-databases/opening-an-existing-project/working-with-existing-flyway-configurations
2021-07-29 at 15.05.59.png A dialog will appear allowing you to fill in the connection details for the database you want to use as your b
/rcc4/developing-databases/creating-a-new-project/creating-a-baseline-script