changeNavRelease2016.bat
updateNavInterfaceToDBConn.bat
updateNavInterfaceToNew.bat
updateNavInterfaceToOld.bat
Content: changeNavRelease2016.bat
--------------------------------------------
@Echo Path: %4
@Echo=============================================================
@Echo dbo.GetBuyerPaidStatusByInvoiceNum.StoredProcedure.sql"
sqlcmd -S %1 -i"%4\dbo.GetBuyerPaidStatusByInvoiceNum.StoredProcedure.sql" -U %7 -P %8
@Echo Path: %5
@Echo===================================================================
@Echo MaRS.spGetInvoiceHeader.StoredProcedure.sql"
sqlcmd -S %2 -i"%5\MaRS.spGetInvoiceHeader.StoredProcedure.sql" -U %7 -P %8
@Echo Path: %6
@Echo=====================================================================
@Echo Web.GetInvoices.StoredProcedure.sql"
sqlcmd -S %3 -i"%6\Web.GetInvoices.StoredProcedure.sql" -U %7 -P %8
Content: updateNavInterfaceToDBConn.bat
--------------------------------------------
IF %1 == NewVersion Call changeNavRelease2016.bat "Server1,Port" Server2 Server3 %2 %3 %4 User Password
IF %1 == OldVersion Call changeNavRelease2016.bat "Server1,Port" Server2 Server3 %2 %3 %4 User Password
Content: updateNavInterfaceToNew.bat
--------------------------------------------
updateNavInterfaceToDBConn NewVersion C:\SVN\MaRS\Trunk\SQL\Navision C:\SVN\MaRS\Trunk\SQL\TurnersGroup_MSCRM C:\SVN\Database\trunk\InfoNow\SQL\InfoNow > changeResultNewVersion.log
pause
Content: updateNavInterfaceToOld.bat
--------------------------------------------
updateNavInterfaceToDBConn OldVersion C:\SVN\MaRS\Trunk\SQL\Navision\OldVersion C:\SVN\MaRS\Trunk\SQL\TurnersGroup_MSCRM\OldVersion C:\SVN\Database\trunk\InfoNow\SQL\InfoNow\OldVersion > changeResultOldVersion.log
pause
changeNavRelease2016.bat
updateNavInterfaceToDBConn.bat
updateNavInterfaceToNew.bat
updateNavInterfaceToOld.bat
Content: changeNavRelease2016.bat
--------------------------------------------
@Echo Path: %4
@Echo=============================================================
@Echo dbo.GetBuyerPaidStatusByInvoiceNum.StoredProcedure.sql"
sqlcmd -S %1 -i"%4\dbo.GetBuyerPaidStatusByInvoiceNum.StoredProcedure.sql" -U %7 -P %8
@Echo Path: %5
@Echo===================================================================
@Echo MaRS.spGetInvoiceHeader.StoredProcedure.sql"
sqlcmd -S %2 -i"%5\MaRS.spGetInvoiceHeader.StoredProcedure.sql" -U %7 -P %8
@Echo Path: %6
@Echo=====================================================================
@Echo Web.GetInvoices.StoredProcedure.sql"
sqlcmd -S %3 -i"%6\Web.GetInvoices.StoredProcedure.sql" -U %7 -P %8
Content: updateNavInterfaceToDBConn.bat
--------------------------------------------
IF %1 == NewVersion Call changeNavRelease2016.bat "Server1,Port" Server2 Server3 %2 %3 %4 User Password
IF %1 == OldVersion Call changeNavRelease2016.bat "Server1,Port" Server2 Server3 %2 %3 %4 User Password
Content: updateNavInterfaceToNew.bat
--------------------------------------------
updateNavInterfaceToDBConn NewVersion C:\SVN\MaRS\Trunk\SQL\Navision C:\SVN\MaRS\Trunk\SQL\TurnersGroup_MSCRM C:\SVN\Database\trunk\InfoNow\SQL\InfoNow > changeResultNewVersion.log
pause
Content: updateNavInterfaceToOld.bat
--------------------------------------------
updateNavInterfaceToDBConn OldVersion C:\SVN\MaRS\Trunk\SQL\Navision\OldVersion C:\SVN\MaRS\Trunk\SQL\TurnersGroup_MSCRM\OldVersion C:\SVN\Database\trunk\InfoNow\SQL\InfoNow\OldVersion > changeResultOldVersion.log
pause