An old, archived database cannot be updated via the client. Attempted client update of the database schema keeps failing with a timeout error.
The client is unable to update the database schema on archived ChangeAuditor databases because the SQL scripts are taking longer to complete which results in a timeout error.
1. Gather the scripts from this directory: \Program Files\Quest\ChangeAuditor\Client\Scripts in one of the machines that has a client installed. The files are listed below.
2. Transfer the script files to the SQL server.
3. Manually upgrade the database by running the ChangeAuditor SQL scripts in SQL management studio against the ChangeAuditor database.
CA Archive DB use order specified below:
------------------------------------
a)'Quest-Database.sql'
b)'Quest-Types.sql'
c)'Quest-Procedures.sql'
d)'Quest-ChangeAuditor-Schema.sql'
e)'Quest-ChangeAuditor-Collation.sql'
f)'Quest-ChangeAuditor-Data.sql'
g)'Quest-ChangeAuditor-Roles.sql'
h)'Quest-ChangeAuditor-Indexes.sql'
i)'Quest-ChangeAuditor-Statistics.sql'
j)'Quest-ChangeAuditor-Functions.sql'
k)'Quest-ChangeAuditor-Views.sql'
l)'Quest-ChangeAuditor-Procedures.sql'
Current (online) CA DB in order specified below:
-----------------------------------------------------------
a)'Quest-Database.sql'
b)'Quest-Types.sql'
c)'Quest-Procedures.sql'
d)'Quest-ChangeAuditor-Schema.sql'
e)'Quest-ChangeAuditor-Collation.sql'
f)'Quest-ChangeAuditor-Triggers.sql'
g)'Quest-ChangeAuditor-Roles.sql'
h)'Quest-ChangeAuditor-Indexes.sql'
i)'Quest-ChangeAuditor-Statistics.sql'
j)'Quest-ChangeAuditor-Functions.sql'
k)'Quest-ChangeAuditor-Views.sql'
l)'Quest-ChangeAuditor-Procedures.sql'
m)'Quest-ChangeAuditor-Data.sql'
4. Browse to the following table in the ChangeAuditor database that is being upgraded: dbo.SystemProperty.
5. Change the PropKey value "ProductVersion" to the same version of the ChangeAuditor client.
6. Use client to connect to the archive database via direct SQL connect.
© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center