The outcome of your environment assessment will influence which migration strategy you eventually choose. Therefore, make sure that your migration team has a detailed understanding of the current setup very early in the process. This also helps in identifying possible challenges at an early stage.
We recommend that you also document objects that you do not need to migrate because you will no longer use them in Exasol, since this information can be useful as a reference to be used in later stages or for troubleshooting purposes.
The following section lists the major things you should consider documenting.
Document all the data objects that you want to migrate. For example:
Which schemas must be migrated?
Check for data types where you cannot do a one-to-one mapping with Exasol, such as BLOB types.
To get an overview of all the data types used and the possible challenges, run the query in Appendix A: Data type .
To get an overview of external tables and directories, run the query in Appendix D: External tables and directories
Functions and stored procedures
- PL/SQL code can be either translated to Exasol’s PL/SQL style functions, or rewritten in Exasol UDFs or into Exasol LUA Scripts.
- To get an overview of functions, procedures, and packages, run the query in Appendix E: Functions, procedures, and packages.
Triggers are not supported in Exasol.
You do not have to migrate any indexes, as Exasol creates indexes automatically on the fly.
Document all the ETL Processes in your
- Data integration / ETL / scheduling tools
- Handwritten procedures for ETL / ELT processing
- Data sources
- For each data source document:
- Security (for example, required users/roles)
- Loading frequency and loading window
- Network bandwidth
- Loading SLAs
BI Tools and Other Applications
Document all applications used by your current
- BI tools
- SQL editors
- Data science applications (for example, integration with R and Python)
- Other applications that access data from the data warehouse
Check the connectivity for all of your existing tools to Exasol (see Ecosystem Overview). If none of the tools are supported, look for alternatives. For example, you can use DBVisualizer or DBeaver as an alternative to
Document all the security requirements currently implemented in
Encryption of data at rest and in motion
Users/roles and their privileges
To get an overview of the users and roles, run the queries in the following appendixes:
Are users authenticated via LDAP or Active Directory?
Do you have row or column level security implemented?
Document all your existing environments and consider them for your migration plan. For example:
- Production environment
- Pre-production / QA environment
- Development environment
For your general migration planning, consider the following operational aspects and include them in your migration plan:
- General SLA requirements
- Document the current backup strategy
- Document the current disaster recovery strategy
- Document your enterprise monitoring tools