Checking the Content Matrix Console License
To check the status of the license key in use, open the About dialog. Here, information such as the license type, expiration date (if any), size limitations for migrations, and how much data has already been migrated can be seen.
NOTE: If an offline license is used, the offline activation process will need to be used to do this update instead, unless the system that the Content Matrix Console is installed on has internet access.
To check the current license:
1.In the Content Matrix Console ribbon toolbar, choose Help > About.
2.In the dialog that opens, click [Refresh]. This will initiate a refresh of this data from the licensing servers and update the information.
Selecting the SQL Database You Want to Connect to
The first time you launch the Content Matrix Console you will be prompted to select the SQL database that you want to connect to. Options are:
·Connect to Job Database (SQL Server)
·Connect to Distributed Database (SQL Server). In order to use this option, Distributed Migration must be configured.
·Connect to New Job List (SQL Server Compact 4.0* required)
·Connect to Existing Job List (SQL Server Compact 4.0* required)
* NOTE: The use of SQL CE in a production environment is discouraged because of the following limitations:
§It uses a single .lst file that is less robust and reliable and may be corrupted after the database reaches 4 GB.
§Data compression is not supported.
§Support for large objects is limited.
§Microsoft support for SQL CE has ended.
If you still want to use SQL CE for evaluation purposes, SQL Server Compact 4.0 must already be installed on your machine. You can download it from Microsoft, install it, then restart the Console.
NOTE: If you have upgraded from version 9.3 or earlier and are using SQL CE (.lst) files but SQL Server Compact is not installed, a pop-up will display. You will be given the option of either installing SQL Server Compact 4.0 or selecting a different Job database.
To create or connect to a full SQL database:
IMPORTANT: If you are connecting to an Azure SQL database, the database must already have been created via Azure Portal. You cannot create or delete an Azure SQL database from within Content Matrix.
1.From the Please connect to a job database dialog, select Connect to Job Database (SQL Server) or Connect to Distributed Database (SQL Server).
2.Complete the Connect to SQL Server dialog:
§If you are connecting to an on premises SQL database, create (using the New Database option) or select the database you want to use.
§If you are connecting to an Azure SQL database, select the database that has been created in Azure Portal for use by Content Matrix. (Note that the New Database and Delete Database options will be disabled.)
3.If you want to use an encrypted connection to the database, check the Encrypt Connection box.
NOTE: If the certificate used for encryption is not trusted, you will also need to check the Trust Server Certificate box.
4.Select an Authentication method for connecting to SQL server:
·Use Current Windows User
OR
·Use SQL Server Login
NOTE: Currently, Use SQL Server login is the only valid option for an Azure SQL server.
5.Click [OK].
Content Matrix Console End User Interface
The Content Matrix Console User Interface (UI) is simple and easy to use. There are three high level components to the configurable interface:
·Explorer View 1 - At minimum, the interface will always display one Explorer Control, providing multiple ways to view the content for any active connections to source and target environments.
·Explorer View 2 - A second explorer control can be displayed simultaneously. Having two explorers visible allows the user to simultaneously view two different parts of the connected content set. For example, in many cases it makes sense to show a migration source on the left in Explorer Control 1, and a SharePoint migration target on the right in Explorer Control 2.
·Job List - Beneath the Explorer Control windows is a Job list that shows the history of migration jobs and other tasks that have been run or batched in Content Matrix.
More information on these UI components is provided in the topics that follow.
Main (Ribbon) Toolbar
At the top of the Content Matrix Console is a ribbon toolbar allowing access to the following five menu group settings:
·Connection
·View
·Settings
·Help
The Content Matrix Console menu ribbon can be expanded or minimized to fit the user's needs. When expanded, a set of options will be available depending on the selected menu heading.
When minimized, options will only be visible when a menu heading is selected. Otherwise, only menu headings will show. The minimize and expand options can also be accessed by right clicking an option in the ribbon itself. This opens a context (right-click) menu where the Minimize the Ribbon option can be selected or deselected.
