Script To Change The System Database

Legacy Poster

• 10. Juli 2014 09:23

If we move the system database to another SQL server is there a script that can be written and pushed down to computers so that we do not need to touch every installation of Bartender and change where the database resides manually?

0

• 

  Domingo Rodriguez

  Moderator

  ★ BarTender Hero ★

  • 10. Juli 2014 10:11

  I can give you the instructions on how to manually configure the connection to the system database. Some of these steps can probably be scripted / automated:

   

   

  1. Using Windows' "Services" control panel, stop the BarTender System Service:

   

  2. Open the Bartender System Service configuration file, "Config.xml", with a text editor.  This can be found in:

  «CommonApplicationData»\Seagull\System\Service

   

  Where «CommonApplicationData» depends on the Windows Version you're using:

   

  Windows 7 

  Windows Vista 

  Windows Server 2008     C:\ProgramData

   

  Windows XP 

  Windows Server 2003     C:\Documents and Settings\All Users\Application Data

   

  3. Remove the contents within the ConnectionString tag, so that you're left with the following:

   

  ....

      <ConnectionString>

      </ConnectionString>

  ....

   

  4. Insert your desired connection string and save the file:

   

  ** If a Windows Login is used, the connection string must also contain “Integrated Security=SSPI"

   

  5. Start the Bartender System Service from the Windows Services control panel.

   

  6. Run the System Database Setup utility again.  This will accomplish two things: It will allow you to confirm that you've correctly entered your connection string, and that you're now connected to the desired database. Your connection string will be re-encrypted once you press "OK" and exit the System Database Setup utility.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • 10. Juli 2014 14:28

  Sweet ... 

  0
• 

  Bart Deman

  ★ BarTender Hero ★

  • 20. Dezember 2016 11:33

  Hi

  I've tried the solution suggested by Domingo Rodriguez but when I go to the Administrative Console I get:

  

   I'm performing my test by creating a database using the database wizard. Then replacing the content inside the "connection string" tags with:
  Server=<local host>\BarTender;Database=<departement name>;Trusted_Connection=True;Integrated Security=SSPI;
  where <local host> and <departement name> are the name of my laptop and the name of a database.

  Any suggestions? I'm using BT 2016 R3 version 11.0.3.3094 (64-bit). It is a trial version of the Enterprise Automation. I'm preparing a migration path for an upgrade of BT10.1 to BT2016. My goal is to give each departement their own BarTender database. By using a group policy I want to change the config.xml so that the correct database is choosen.

  Kind regards
  Deman Bart

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.