Usage

  • No Parameters
    • Double-clicking the file will prompt you for the database name and server name
    • Executing the command from a dos window will prompt you for the database name and server name
  • Parameters supplied
    • -S is the server name
    • -D is the database server name
    • The order of the parameters do not matter
    • There must be a space between the parameter and it's value
  • Valid Examples
    • SQLDeployTool -S sqlserver01 -D database01
    • SQLDeployTool -D database01 -S sqlserver01
    • SQLDeployTool -s sqlserver01 -d database01
    • SQLDeployTool -d database01 -s sqlserver01
  • Directory Structure
    • Files are read in alphabetically so they process in that order
    • This program is designed around the concept that you will keep your files in the order of execution by prefixing the file with a numbering scheme
    • For example, 00.Create.Table.dbo.theTable will process before 01.Insert.Table.dbo.thetable
    • I typically skip numbers by 5 or 10 so I'll have room later to add files between executions if needed.

Last edited Apr 12, 2011 at 12:43 PM by jjoiner, version 6

Comments

saycale May 23, 2014 at 7:39 AM 
Suggest to add the parameter for the initial directory with SQL scripts. It would really help for the big projects with complex directory structure. Thank you.