Schema conversion from DB2 to CockroachDB covers:
- schema, database
- create table
- create unique index
- create indexes
Require transformations or redesign in the business logic:
- alter table (might require redesign when working with PRIMARY/FOREIGN KEY references)
- changefeeds (example command for each table)
Not migrated:
- create sequence
- alter sequence
- create trigger
- create procedure
- Setup and activate your local Python 3.x environment
venv
$ python -m venv venv
$ source venv/bin/activate
- Install dependencies
$ pip install -r requirements.txt
- Optionally, install dependencies individually
$ pip install streamlit urllib3==1.24.3
- Deploy the Streamlit service locally with
$ streamlit run Home.py
- Upload your DDL schema
- From the dropdown, multi-select, choose the type of statements to convert
- Click download button to get your new sql DDL