How to generate script that includes schema and static data

• 
  There isn't actually a way to do it within the graphical user interface, but it's possible to do it using the command line interface using the command line.
  Here's the full documentation on using the command line interface - https://documentation.red-gate.com/sc13/using-the-command-line
  
  An example for Static Data: switch /include:"StaticData". 
  So for instance, if I wanted to compare a scripts folder with a database and generate a deployment script including the static data, I would save a project file containing the source and target of the comparison and then use the following command line
  "C:\Program Files (x86)\Red Gate\SQL Compare 13\sqlcompare.exe" /project:"c:\path\myProject.scp" /scriptfile:"deploymentScript.sql" /include:"StaticData"
  If I wanted to perform the deployment at the same time then I would add /sync to the end of the command line.
  
  

  squigley April 08, 2019 10:19

  - 0 +
• 
  There isn't actually a way to do it within the graphical user interface, but it's possible to do it using the command line interface using the command line.
  Here's the full documentation on using the command line interface - https://documentation.red-gate.com/sc13/using-the-command-line
  
  An example for Static Data: switch /include:"StaticData". 
  So for instance, if I wanted to compare a scripts folder with a database and generate a deployment script including the static data, I would save a project file containing the source and target of the comparison and then use the following command line
  "C:\Program Files (x86)\Red Gate\SQL Compare 13\sqlcompare.exe" /project:"c:\path\myProject.scp" /scriptfile:"deploymentScript.sql" /include:"StaticData"
  If I wanted to perform the deployment at the same time then I would add /sync to the end of the command line.
  
  

  squigley April 08, 2019 10:19

  - 0 +
• 
  There isn't actually a way to do it within the graphical user interface, but it's possible to do it using the command line interface using the command line.
  

  
  

  Here's the full documentation on using the command line interface - https://documentation.red-gate.com/sc13/using-the-command-line

  
  

  An example for Static Data: switch /include:"StaticData". 
  

  
  

  So for instance, if I wanted to compare a scripts folder with a database and generate a deployment script including the static data, I would save a project file containing the source and target of the comparison and then use the following command line

  
  

  "C:\Program Files (x86)\Red Gate\SQL Compare 13\sqlcompare.exe" /project:"c:\path\myProject.scp" /scriptfile:"deploymentScript.sql" /include:"StaticData"

  
  

  If I wanted to perform the deployment at the same time then I would add /sync to the end of the command line.

  
  

  squigley April 08, 2019 10:19

  - 0 +
• 
  There isn't actually a way to do it within the graphical user interface, but it's possible to do it using the command line interface using the command line.
  

  
  

  Here's the full documentation on using the command line interface - https://documentation.red-gate.com/sc13/using-the-command-line

  
  

  An example for Static Data: switch /include:"StaticData". 
  

  
  

  So for instance, if I wanted to compare a scripts folder with a database and generate a deployment script including the static data, I would save a project file containing the source and target of the comparison and then use the following command line

  
  

  "C:\Program Files (x86)\Red Gate\SQL Compare 13\sqlcompare.exe" /project:"c:\path\myProject.scp" /scriptfile:"deploymentScript.sql" /include:"StaticData"

  
  

  If I wanted to perform the deployment at the same time then I would add /sync to the end of the command line.

  
  

  squigley April 08, 2019 10:19

  - 0 +
• 
  Thanks squigley!  That is what I was finding as well, but wanted to make sure.  The command line will really help though.  Thanks again!

  jnik April 08, 2019 13:36

  - 0 +

Add comment

Please sign in to leave a comment.