1 Reply Latest reply on May 16, 2017 11:11 AM by jlittle RSS
    あ中村 Newbie

    using Azure SQL Database for ThingWorx database storage

    Hi All,

    I am triying to using Azure SQL Database for ThingWorx database storage.

    However, thingworxMssqlDBSetup.bat and thingworxMssqlSchemaSetup.bat are not applicable for Azure SQL Database because I already made database and so on through setup Azure SQL Database.

     

    How should I modify the batches to use Azure SQL Database for ThingWorx database storage?

      • Re: using Azure SQL Database for ThingWorx database storage
        jlittle Explorer

        Even though your DB is in Azure, you should still be able to use the batch scripts to set up the database.  You will need to pass in the following parameters for each: (Anything in bold is a required parameter.)

         

        thingworxMssqlDBSetup.bat -h <your SQLServer IP or hostname> -i <SQL Instance name if necessary> -p <port if different than 1433> -a <Admin username for your database instance> -l <Username that was created for ThingWorx> -d <Database Name for Thingworx, otherwise uses "thingworx"> -u <same user as -l prior>

         

        thingworxMssqlSchemaSetup.bat -h <your SQLServer IP or hostname> -i <SQL Instance name if necessary> -p <port if different than 1433> -l <Username that was created for ThingWorx> -d <Database Name if different than "thingworx">

         

        You will need to have a SQL client installed on the machine that these scripts are run from, and the sqlcmd executable should be in your path.

         

        If you need to move the scripts to another machine, make sure you copy the entire install folder and not just the batch scripts.  The batch scripts run the SQL scripts also in the same folder.