Go Up to Migrating Databases to Dialect 3
In either method, you begin by extracting the metadata from your database, examining it for problem areas, and fixing the problems.
- If you are performing an in-place migration, you copy corrected SQL statements from the metadata file into a new script file, modify them, and run the script against the original database. Then you set the database to dialect 3. There are some final steps to take in the dialect 3 database to store old data as
- If you have a utility for moving data from the old database to a newly created empty database, you use the modified metadata file to create a new dialect 3 database and use the utility to transfer data from the old database to the new.
In both cases, you must make changes to the new database to accommodate migrated columns that must be stored as
INT64 and column constraints and defaults that originally contained double quotes.
The two methods are described below.