Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
Licensing, Cloud and Web Services
  • Welcome to Bentley Communities
  • Bentley's Communities
  • Licensing, Cloud and Web Services
  • More
  • Cancel
Licensing, Cloud and Web Services
Licensing, Cloud and Web Services Wiki Migrating a license database using SQL Server Management Studio
    • Sign in
    • Eastern Europe Continuity Plan
    • Guest Accounts - Review Access
    • +Web Services
    • +SES Activation
    • +CONNECTION Client
    • +CONNECT Advisor
    • +Federated Identity
    • -SELECTserver based Activation
      • Understanding the (Legacy) SELECTserver Workflow
      • +Deployed SELECTserver Application Usage TechNotes and FAQs
      • Activating Against SELECTserver OnLine (a Bentley hosted server)[TN]
      • Activating Applications Using SELECTserver Based Licensing as a non-SELECT User
      • Activating Non-Licensed Trial Mode Software
      • Activation of Client Side Products and Registry Basics
      • Client Check In and Out Instructions for XM and Higher [TN]
      • Importing a Checked Out License (XML file) for XM and Higher [TN]
      • Disconnected Mode [FAQ]
      • Generating a License Debug Log
      • +License Management Tool
      • Product Activation [FAQ]
      • Product Activation Modes of Behavior
      • Renewal Process for All Licensing
      • Server does not support this Activation Key
      • Troubleshooting Product Activation for XM and Higher
      • -SELECTserver TechNotes and FAQs
        • "An Error Has Occurred" when manually transmitting usage logs using a preconfigured URL
        • About SELECTserver
        • Connecting to the Bentley servers through Firewalls and Proxy Servers [FAQ]
        • Could not load type 'System.ServiceModel.Activation.HttpModule' from assembly 'System.ServiceModel...'
        • Data Update Service Warning [TN]
        • Database Maintenance
        • Database Setup Tool Configuration and Explanation [FAQ]
        • Deployed SELECTserver Database and Internet Connectivity Insight [TN]
        • Deployed SELECTserver issue with new Bentley SSL certificate
        • Deployed SELECTserver Knowledge Requirements [TN]
        • Deployed SELECTserver Technical Requirements [TN]
        • Enabling Diagnostic Logging for SELECTserver
        • Error 1068: Cannot start the Bentley SELECTserver service
        • Error 417 : in SELECTserver and GateWay logs
        • Glossary Of Licensing Terms [FAQ]
        • Group Policy Administration (ADM) files
        • How do I keep usage reports current?
        • How do I set up or prevent license checkouts?
        • How to create a new website in IIS7
        • How to create a Virtual Directory in IIS7
        • How To Install a Gateways on Vista and Windows 7, Server 2008
        • How to Install the SELECTserver application
        • HTTP Error 404.13 "The request filtering module is configured to deny a request that exceeds the request content length" when importing response file
        • HTTP Error 500.21 - Internal Server Error on SELECTserver Administrative Site
        • Import xml File on Deployed Server
        • IP Address Hosted Server
        • License and SELECTserver Administration [FAQ]
        • +License Manager
        • License Tool Command Line Options
        • Manual Installation of SQL Express (2008 - 2012)
        • Moving (relocating) the SELECTserver application to a new server.
        • Moving Your SELECTserver Database
        • +Older SELECTserver Versions
        • Opening Administration Site
        • Restricting access to a deployed SELECTserver Administration Site. Configuration example (video).
        • Running the Data Update Service and restarting IIS in order to immediately update a deployed license
        • Security [FAQ]
        • SELECT Server 08 11 Series [CS]
        • -SELECTserver
          • Access restriction via IP-address
          • Access to App_Offline.htm denied in SELECTserver Database Setup
          • +Administration - SELECTserver
          • Administration page does not open, page cannot be displayed
          • Create a log file on the client computer
          • Deployed SELECTserver Logs
          • Hosted server Administration page - Access for administrators only
          • How to start the Deployed SELECTserver and SELECTserver Gateway service via Windows Services
          • -Installation / Configuration - SELECTserver
            • Converting from a Deployed SELECTserver to Bentley CONNECT SELECTservices
            • +Group Policies - Installation / Configuration - SELECTserver
            • How do I install SELECTserver?
            • How to install SELECTserver in a secure environment
            • +IIS Configuration - Installation / Configuration - SELECTserver
            • SELECTserver and SELECTserver Gateway in a Cloud Environment
            • +SQL Installation - Installation / Configuration - SELECTserver
            • -SQL Management - Installation / Configuration - SELECTserver
              • Database size out of proportion
              • Error Truncating Usage Data
              • Error: Database not ready
              • Error: SQL Transaction Logs are Full
              • How do I control the growth of my SELECTserver license database?
              • Migrating a license database using SQL Server Management Studio
              • Setting up SELECTserver in a DMZ
              • Unable to start the SELECTserver service
            • +Windows Installer Errors - Installation / Configuration - SELECTserver
          • +Installation / Configuration - SQL Management
          • MSG_HIST_PEAK message on Deployed Administration page
          • No access to the Adminstration page
          • Ports and Domains
          • Process Responce File
          • Program starts up slowly after the creation of a log file
          • Reset the webserver IIS
          • Response File larger than 7.93 MB - Error 404
          • Restrict access to the Hosted Administration page
        • SELECTserver 9 Known Issues
        • SELECTserver 9.xx.xx.xx Gateway Update Process [FAQ]
        • SELECTserver 9.xx.xx.xx Upgrade Information [FAQ]
        • SELECTserver Database Backup [TN]
        • +SELECTserver Gateway
        • SELECTserver Gateway error 1053
        • SELECTserver Gateway error 1067
        • SELECTserver Gateway Explained
        • SELECTserver Gateway License Server Revoked License [TN]
        • SELECTserver Gateway Service Fails To Connect through Proxy Server [TN]
        • SELECTserver General [FAQ]
        • SELECTserver in a IPV6 Environment
        • SELECTserver Notifications
        • SELECTserver Online Technical Requirements [FAQ]
        • SelectServer V9 without connectivity and Bentley Passport
        • SELECTserver XM Database Backup [TN]
        • SQL Server 2005 Cachestore Flush Error
        • SQL Server Compatibility Mode - Internal Query Processor Error
        • The response file corresponding to the following logs is not processed.
        • The SQL transaction logs are full
        • Transmit Usage Logs - 0 Logs Found To Process [TN]
        • Trust Licensing Basics [FAQ]
        • Unlock the SQL Server SA Account
        • Usage Log Processing - ERROR with status code 15014
        • Using Active Directory Group Policy Objects to Configure Licensing for Users Centrally (video).
        • What options are available to allow the external (WAN) user to access a Locally Deployed SELECTserver?
        • What's New in the latest SELECTserver?
      • Where do I find my Activation Key?
      • Stopping SELECTserver Activation Key based Usage
    • +Pre-SELECTserver Based Activation
    • +Product-Specific Licensing
    • Understanding why you received a TL Invoice
    • Working from Home using Bentley Licensing
    • +Licensing Workflow
    • How to leave a Product Review
    • +Serviços ProjectWise 365
    • About Bentley Trust Licensing
    • How to delete Bentley account and all related data
    • Support for non-Bentley technologies utilized by Bentley products
    • Support for V8i SELECTseries 10 applications after December 31st, 2021
    • +Support Homepage - Localized
    • What you need to know/request when consolidating Accounts

    Migrating a license database using SQL Server Management Studio

      Product(s): SELECTserver
      Version(s): N/A
      Environment: Windows XP 32 bit,Windows XP 64 bit,Windows Server 2003,Windows Vista 32 bit,Windows Vista 64 bit,Windows 7 32 bit,Windows 7 64 bit,Window Server 2008 64 bit,Windows Server 2008 R2
      Area: Installation / Configuration
      Subarea: SQL Management

    The following support solution provides instructions for moving a SELECTserver license database from one server to another using a free database utility named SQL Server Management Studio.

    Background

    A license database includes historical usage data and various license settings such as temporary activation keys, custom activation groups, and client access restrictions. When installing SELECTserver on a new server, the license database can be copied over and used as an alternative to creating a new license database.

    The instructions below, while detailed, are best performed by a system administrator with knowledge of SQL Server databases.

    Steps to Accomplish

    Installing SQL Server Management Studio (if needed)

    If the old server is running an Express edition of SQL Server, then SQL Server Management Studio must be installed. These instructions will use SQL Server 2008 Management Studio, but any version that is the same version or higher will be sufficient. Standard and Enterprise editions of SQL Server should include it already. The following installation instructions posted on a Microsoft blog provide a helpful reference for navigating the various screens of the installer.

    Backing up the database

    1. Open SQL Server Management Studio.
    2. In the window that appears, enter server and instance name and any credentials to access the database. For a database locally created by the SELECTserver installer, a server name of ".\SELECTserver" with Windows Authentication selected should work.
    3. In the Object Explorer on the left edge, expand the Databases folder, right-click on the license database to move, and select Tasks -> Backup from the contextual menu.
    4. In the window that appears, note that file path in the Destination section at the bottom. Click the OK button to generate a BAK file, and then navigate to this location to retrieve it.
    5. A BAK file can be rather large (i.e. several gigabytes). So compressing the BAK file in a zip or 7-zip archive prior to transferring is recommended.

    Restoring the database

    1. On the new server, copy the BAK file to a location accessible by an administrator, and expand it if compressed.
    2. If the new server is running an Express edition of SQL Server, install SQL Server Management Studio.
    3. Open SQL Server Management Studio, right-click on the Databases folder, and select Restore Database from the contextual menu.
    4. In the Destination section, specify a name for the license database. It can be different than the database name on the old server if necessary.
    5. In the Restore section, select the From Device radio button, and click the button with the elipse to specify a file.
    6. Click the Add button, select the BAK file, and click the OK button.
    7. Depending on the version of SQL Server installed, backup sets may need to be explicitly selected in the Restore Column before proceeding.
    8. Click the OK button to restore the database file.
    9. If successful, the new license database will appear under the Databases folder.

    Configuring SELECTserver to use the restored database

    1. From the Windows Start menu select:
      All Programs -> Bentley -> SelectServer
    2. Unless running Windows XP or Windows Server 2003, right-click on SELECTserver Database Setup, and select Run As Administrator from the contextual menu. Otherwise, just select SELECTserver Database Setup normally.
    3. Select the restored database from the Database drop-down menu, and click the OK button. If a connection string error occurs instead, ensure that the server name and login credentials are entered correctly.

    Other Language Sources

    Español

    Deutsch

    See Also

    Database Setup Tool Configuration and Explanation [FAQ]

      Original Author: Jeremy Hoesly
    • Windows 7 32 bit
    • connect
    • Installation / Configuration
    • Windows 7 64 bit
    • Windows XP 64 bit
    • Windows Vista 32 bit
    • SQL ManagementWindows XP 32 bit
    • en
    • Windows Server 2003
    • Windows Vista 64 bit
    • Windows Server 2008 R2
    • Window Server 2008 64 bit
    • SELECTserver
    • SELECTsupport
    • Share
    • History
    • More
    • Cancel
    • jeremyhoesly Created by Bentley Colleague jeremyhoesly
    • When: Wed, Oct 28 2015 7:58 PM
    • jeremyhoesly Last revision by Bentley Colleague jeremyhoesly
    • When: Wed, Apr 26 2017 5:57 PM
    • Revisions: 6
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2021 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies