Not sure how ready you are to move to the cloud? With Tidal Migrations you have the option to analyze the databases associated with your applications.
The analysis will calculate the difficulty of migrating your databases to each target platform, and give details on database features that may complicate the migration.
It is capable of analyzing both Oracle and SQL Server databases. Providing analysis on migrating a database to a variety of services on AWS, Azure and Google Cloud.
NB: The entire analysis never queries or reads user or application data and does not collect database source code.
Currently, Oracle databases versioned 10.2 and newer can be analyzed. As well as SQL Server databases versioned 2008R2, 2016 and 2017. If you have a use case for a different version, definitely let us know at firstname.lastname@example.org, we are always adding new capabilities.
The databases are analyzed to look for patterns and feature usage that may be difficult to migrate due to lack of support or compatibility in their new environment. The databases are analyzed based on their metadata, looking at specific schema objects that are used within your databases as well as the usage of proprietary features that will not be available in the target platforms.
For example, in Oracle databases, the Data Dictionary and AWR repository tables are read and analyzed. The scoring is calculated based on the type of attributes, features or schema objects that are used and the frequency of use throughout the database.
- Over 100 unique characteristics are considered
- Feature-fit is executed against all supported cloud data platforms.
- Migration difficulty score is calculated based on a weighted model
- Enable the Database Analysis feature for your account: https://yoursubdomainhere.tidalmg.com/#/settings - See the Database Analysis section, under Preferences.
tidal loginBe sure to have installed and logged in to your Tidal Migrations account via Tidal Tools.
- Install Docker CE, it is compatible with most OSs, select the one you need. Version 17.12 or later will work with Tidal Tools. Why Docker?
- You will also need a few authentication and configuration details for the database:
- id - The id of the database from your Tidal Migrations account. You can find it in the URL bar when looking at a database instance. ex. If you are viewing a database instance in Tidal Migrations, the URL will show https://demo2.tidalmg.com/#/database_instances/111 in this case 111 is the database instance ID.
- engine - The database vendor, either
SQL Server, it is not case sensitive.
- host - The hostname of the server that the database is located on and is accessible via a network connection from your current device and location.
- port - The port that the host has open and the database can accept connections on, the default for Oracle is 1521, and for SQL Server it is 1433.
- db_name - The name of the database that will be analyzed, as it is defined within the database engine itself. ie. the value that is used by applications to connect to the database by name.
- user - A username to authenticate with the database with, see below for more details.
- password - A password for the corresponding user.
- name - A common name for your database could be the same or different from db_name, but this value is arbitrary and only for your reference.
You can either use the default
SYSDBA user or you can create a user with the same set of permissions:
CREATE USER tidal IDENTIFIED BY replace_this_with_secure_password; GRANT CREATE SESSION TO tidal; GRANT SELECT ANY DICTIONARY TO tidal; GRANT SELECT_CATALOG_ROLE TO tidal;
SQL Server User
For SQL Server the access needed is specified in the
GRANT commands below. If you have a user you would like to use you can run these commands and change the
[user_name]. If you want to create a new user, there a few options provided by Microsoft, which you can do and then run the following
GRANT commands for the new user.
GRANT SELECT ON SCHEMA::sys TO [user_name] GRANT SELECT ON SCHEMA::INFORMATION_SCHEMA TO [user_name] GRANT SELECT ON tempdb..sysobjects to [user_name]
With your user and password, you can define all these values in a YAML configuration file:
databases: - id: 111 engine: Oracle host: 'my-db-host.com' port: 1521 db_name: 'orcl' user: 'tidal' password: 'yoursecurepassword1234!' name: 'My-Test-DB'
'my''string'- will become
- You’re all set! You can now analyze the database with:
tidal analyze db config.yml
Try it out!
You need to install Docker in order to complete the database analysis. This is because the analysis uses several system dependent software libraries, so by using Docker the analysis can use those libraries without you requiring to install the correct dependencies with the correct versions.
What about security?
The entire analysis takes place locally on your machine. The only data that is captured and sent from the analysis are the results of the analysis and metadata. No application data, source code, files or the contents of any files on your machine are ever copied or sent anywhere.