If you don't have sufficient rights to successfully click the "Upgrade Database" button, you won't be able to execute the upgrades scripts manually, either. We're you planning on getting a DBA or someone with sufficient access, like dbo_owner access, to do this?
Look into this:
4.6. Generate Manual SQL Create and Upgrade Scripts
For scenarios where it is necessary for database creation or update operations to occur manually, the SQL scripts for the operation can be generated.
Create Script AutomateC.exe can be used to generate a script and save it on a local device which, when run against a blank database, generates the Blue Prism schema and carries out essential configuration.
Automatec.exe /getdbscript > "c:\temp\CreateScript.sql"
Upgrade Script AutomateC.exe can be used to generate a script and save it on a local device which, when run against an existing Blue Prism database, updates the schema and configuration to be appropriate for the version of Blue Prism.
Automatec.exe /getdbscript /fromrev 10 > "c:\temp\UpgradeScript.sql"
I'd recommend instead to ask the database to temporarily grant you dbo rights long enough for you to hit the upgrade button. Take the happy path if you can.
------Original Message------
We created a new instance (SAT) for our test regions in organization. I took the database copy from Existing BP server and copied to new DB server. Initially I was not able to validate the database because I installed v.6.5.1 on the new application server, previous version was v5.0.33. Then when I hit upgrade database since I am on older version, it gave me some user issue like "sysadmin" grant, I got that granted but not able to authenticate after the sysadmin role granted.
Getting two different errors: "The database in invalid for the version" . I am assuming I can run some sql scripts to apply the Blue Prism schema for the database.
Can someone provide me the scripts that I can manually create a database.
Thanks,
Abhilash.
------------------------------
Abhilash Makkena
------------------------------
