Migrate a Sentinel Visualizer Database to Microsoft Azure

Preparation

Sentinel Visualizer stores its data in Microsoft SQL Server databases. The databases can be hosted in a local copy of SQL Express on your machine or SQL Server on your network.

Identify the SQL Server database to migrate to the Microsoft Azure cloud. If you want to start with a blank one, create a new database and migrate that.

Quick Instructions

  1. Create a Microsoft Azure account (subscription).
  2. Within your Azure account, select or create a SQL Server, and add a new database to it.
  3. Using Microsoft SQL Server Management Studio (SSMS) on your desktop, open your local SQL Server, right-click on the Sentinel Visualizer database to move to the cloud, and select "Deploy database to Microsoft SQL Azure database".
  4. After it's migrated, from Sentinel Visualizer, open the database hosted in your Azure account.

Microsoft SQL ServerFull Instructions

Assumptions

These instructions assume that you:

  • are familiar with the basics of SQL Server database management
  • have a Microsoft Azure account
  • have security permissions to perform the tasks to copy and create a new database

Microsoft AzureMicrosoft Azure Account

These instructions assume that you already have:

  • a Microsoft Azure subscription
  • a SQL Server exists on the subscription or you can add one
  • a new (empty) database is on your Azure SQL Server

If the server or database doesn't exist, you'll need to create them from the Azure Portal.

Migrating a Sentinel Visualizer Database to the Cloud

There are three ways to migrate a database to SQL Azure:

  1. Use Microsoft SQL Server Management Studio (SSMS) on your desktop to deploy the database to your cloud account.
  2. Create a backup (.BAK file) of the Sentinel Visualizer database. Copy/move the BAK file to your Azure storage account, then restore the BAK file from within your cloud account.
  3. Deploy the database directly from within your SQL Server host.

For any of the three options, you need to install Microsoft SQL Server Management Studio (SSMS) on your Sentinel Visualizer computer. (Microsoft SQL Server Management Studio is free)

  1. Use Microsoft SQL Server Management Studio (SSMS) to deploy the database to your cloud account. Within Microsoft SQL Server Management Studio (SSMS), connect to you local or shared instance of Sentinel Visualizer. If you're connecting to the local instance (SENT4EXPRESS), the login information is below.
    • Login: sa
    • Password: S3ntinElL0gin:7@FMS
  2. Consult your Administrator for your shared server credentials.

    Connect to SQL Server

  3. Click the plus sign (+) in the top-left to expand the Databases Folder.
  4. Microsoft SQL Server Management Studio

  5. Right-click on the database that you want to move to the cloud. Select [Tasks] and then [Deploy Database to Microsoft Azure SQL Database...].
  6. Deploy Database to Microsoft Azure SQL Database

  7. Connect to the cloud server. You'll need the cloud account login credentials.
  8. Cloud Server

  9. Choose your desired Azure settings (this can/will affect the cost of your Azure services). Click Finish.

The restore can take more than a few minutes, especially with a large database. After you see "Completed" at the top of the screen, try opening that database from within Sentinel Visualizer.

  1. Launch Sentinel Visualizer
  2. Open Database
  3. Browse
  4. Enter cloud services account name and click [List Databases].
  5. Server Name

    If you get this response:

    Server Name

    Click [Yes] and then enter the appropriate log-in credentials from your cloud account,here:

    Server Login Information

    Choose the desired database from the results list.

  6. If prompted for Windows or SQL Authentication, choose the desired authentication option.
  7. SQL Server Authentication

    For SQL Server Authentication, enter your cloud account credentials.

  8. Upon opening the database, if prompted, enter your database (Sentinel Visualizer) login credentials or use these default credentials:
    • Username: admin
    • Password: password

    Login Credentials

  9. Confirm that you are on the correct server and the correct database by looking in the lower-right part of the Sentinel Visualizer software.
  10. Correct Server

Microsoft Certified Partner

Microsoft Partner Netework

Partners Welcome

Do you provide services to government and commercial customers seeking analytic solutions?
Contact us

In-Q-Tel Portfolio Company

InQTel Portfolio Company
Learn more

Discover

Sentinel Visualizer Comparison to IBM's i2 Analyst's Notebook