Use of another SQL Database in paralled with SmartAssembly to use SA 6.9 and SA 8

edgardurao · March 30, 2021 7:24PM

I'm currently in migrating out build server which is currently in SA 6.9 to use the new SA 8.
Despite being possible to run in parallel the two softwares for compatiblity, all our error reports are stored in a Database "SmartAssembly" in out SQL Server.
Is there a away to create another database for use with version 8 ?

I can´t find any option, or have connected it to another instance in order to separate SA 6 in one DB, and SA 8 in another DB.

Any suggestion?

I'm trying this approach since possible the tables and information are different between versions.

Any help ?

Martin_K · April 1, 2021 8:38PM

You can use any valid SQL Server connection string. Unfortunately you can't set it from UI. To do that, you'll need to edit SmartAssembly.settings with text editor of your choosing. See following documentation links for an example:

(SA 8) https://documentation.red-gate.com/sa8/configuring-smartassembly/configuring-reporting-on-multiple-computers#Configuringreportingonmultiplecomputers-UsingSQLauthentication

(SA 6) https://documentation.red-gate.com/sa6/configuring-smartassembly/configuring-reporting-on-multiple-computers#Configuringreportingonmultiplecomputers-UsingSQLauthentication

As a side note: DbCreatorConnectionString property was called MasterConnectionString in versions <= 7.4.

Use of another SQL Database in paralled with SmartAssembly to use SA 6.9 and SA 8

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk