Topic
How to verify that the PrepareForNewEnvironment script has run correctly.
Instructions
- Open SQL Manager and navigate to the Nintex Configuration database.
- Go to: Tables > dbo.Databases.
- Right-click "Select Top 1000 Rows" or run the following script:
SELECT TOP 1000 [DatabaseID] ,[DatabaseName] ,[ServerName] ,[Username] ,[Password] ,[UseIntegrated] ,[FailoverPartner] ,[DetailsKey] ,[Params] FROM [Your Database Name].[dbo].[Databases]
- Review the output to verify that the new servers and environment are displayed.
Additional Information
Output example:
| DatabaseID | DatabaseName | ServerName | Username | Password | UseIntegrated | FailoverPartner | DetailsKey | Params |
| 1 | NW2013DB | SP13-LAB-06 |
| NULL | 1 |
| NULL | NULL |
The information shown might vary, but must contain correct settings for the new servers and environment.
If this script is run directly after running the stored procedure, the table will be empty.
There should never be references to old servers/databases.
