Chat now with support
Tchattez avec un ingénieur du support

Automatically comparing and synchronizing SQL Server database schema changes (302216)

Retour

Feedback submitted.

Avez-vous trouvé cet article utile ?

  [Select Rating]

Automating the schema synchronization process

Since automating process for building a new database from a source control repository is explained in article: How to deploy changes directly to a SQL database from a source control repository, the part for schema synchronization of the new database with an existing QA database should be added to the sequence, in order to have the whole process for the sync step when there are only schema changes in the source control repository.

The part that should be added is:

# calling a 3rd party application

ApexSQLDiff.com

# the application’s path

/pr:”SchemaSync.axds”

# the path for the ApexSQL Diff project file

/sync

# executes the synchronization script

/v

# prints all messages in console

/f

# overwrites an existing build script

/out:output.txt

# redirects console output to specified file

@echo ApexSQL Diff return code is %errorlevel% >> /out:output.txt

# specifies a return code upon finished build process


Find out more about ApexSQL Diff’s CLI switches from an article on this: ApexSQL Diff Command Line Interface (CLI) switches.

If for any reason, the synchronization process fails, due to the Transaction handling option, all changes will be reverted back and no changes will be applied to a QA database.

 "


Feedback submitted.

Avez-vous trouvé cet article utile ?

  [Select Rating]

Demander ou créer un article de la base de connaissances »

Leave a Comment

Pour envoyer des commentaires, veuillez sélectionner de 1 à 5 étoiles
Recommended Content
Produit(s) :
ApexSQL Compare
2018.04
ApexSQL DevOps Toolkit
2018.15
Sujet(s) :
How To
Historique de l’article :
Créé le : 7/1/2019
Dernière mise à jour le : 7/1/2019
Author:
Kona Praveen Kumar Reddy
Rechercher tous les articles