You can import your Excel spreadsheets into Tidal Migrations by visiting:
You should import your data in the following order:
This order is especially important if you are planning to import dependencies for your Databases and Applications. Ie. If your Application has a dependency on a server, you need to have that server imported first for the dependency to be imported correctly. Note that you can always update a dependency after importing too.
You should have one sheet or file per type of record.
There are several default columns included for each record type, however if you have additional information you can add fields for a record and also track those. If this is the case you should do this before you import your data. You can read more about how to do this here.
Importing your data
- Select the data type from the dropdown you wish to import.
- Select the sheet in your file that you want to import data from.
- Map the columns of your sheet to the fields from the drop down. If you have a column that is not present as a field and you want to import it, you can add that field. You can read about doing this here.
- There are several 'fields' that will map to other resources in Tidal. To find more about what fields Tidal Migrations supports checkout Importing Servers, Importing Databases, or Importing Applications.
- The Tags option can be used to generate multiple tags and associate them with the record. You can use this track any type of categorical data. Additionally you can search and filter for records based on tags. Multiple tags can be associated based on one column of data, they are parsed and split on any commas (,).
- Click submit to import the data.
- Tidal Migrations uses the following fields to map a server to other resources: FQDN, IP Addresses, Database Instances, Environment, Cluster. For these fields, you must select the property that the column will correspond to, generally this is 'Name'.
- Tidal Migrations uses the following fields to map a database instance to other resources: Servers and Environment. For these fields, you must select the property that the column will correspond to, generally this is 'Name'.
- Tidal Migrations uses the following fields to map an application to other resources: Servers, Database Instances, Environment, Customers. For these fields, you must select the property that the column will correspond to, generally this is 'Name'.