Skip to main content
Search Again

We think these articles could help you:

    See More
    Nintex Knowledge Base

    Verifying PrepareForNewEnvironment Script

    Status: Validated

    TOPIC
    How to verify that the PrepareForNewEnvironment script has run correctly.
    INSTRUCTIONS
    1. Open SQL Manager and navigate to the Nintex Configuration database.
    2. Go to: Tables > dbo.Databases.
    3. 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]
    4. 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.

    • Was this article helpful?