This page describes how to use the database collection scripts to discover,collect, and upload your database data to Migration Center.Migration Center usesopen-source collection scripts available on GitHub to collect data. To understand the type of data that Migration Centercollects, you can review the code of the collection scripts.

Before you begin

• The database collection scripts support the following databases anddatabase versions:
  • Microsoft SQL Server for Windows Versions 2008R2 (SP2) to SQLServer 2022
  • MySQL version 8
  • PostgreSQL versions 14 and 15.

Download and run the scripts

To discover and collect data from your databases, follow these steps:

1. Download the latest version of the collection scripts for the databasetype that you want to discover:

   • Download scripts for Microsoft SQL Server.
   • Download scripts for PostgreSQL.
   • Download scripts for MySQL.

2. Extract the files, then in thescripts/collector folder, open thefolder for your database.

3. Follow the instructions in the README file to run the script. When itfinishes running, the script creates a ZIP file with the collected datain the output folder that you select.

Upload the collected data to Migration Center

The ZIP files created by the collection scripts contain all the specificationsand performance data collected from your database.

To upload the ZIP files to Migration Center, follow these steps:

1. In the Google Cloud console, go to theData import page.

   Go to Data import

2. ClickAdd data> Upload files.

3. In theSet up file upload section, enter the name of the file upload.

4. From theFile format list, selectDatabase import file.

5. ClickSelect files to upload, then select all the files that youwant to upload.

6. To upload the files, clickUpload files.

7. If the files are validated correctly, to create the assets from thefiles, clickImport data, then clickConfirm.

Review the upload

After you upload your files, Migration Center validates themto check if they are formally correct. If the validation is successful,Migration Center then processes the data to create new assets,or update existing ones. You can check the status of your upload jobsfrom the Google Cloud console.

To review the status of your upload job, follow these steps:

1. In the Google Cloud console, go to theData import page.

   Go to Data import

2. In theFile uploads tab, from the list of file imports, click the importjob that you want to review.

3. Review theStatus for your uploaded files.

   You can see your files in one of the following statuses:

   • Completed. The import of your file was successful.
   • Ready. Your file passed validation, and is ready to be imported.
   • Pending. Your file is waiting for another file to finish processing.
   • Running. Your file is processing.
   • Validating. Your file is in the validation stage.
   • Failed validation. Your file contains some errors. Fix the errors and thentry to upload your file again.
   • Failed. Your file couldn't be imported.

Review error details

If you encounter errors after importing your files, you can reviewthe error message directly in the Google Cloud console.

To review the errors of your upload job, follow these steps:

1. In the Google Cloud console, go to theData import page.

   Go to Data import

2. In theFile uploads tab, from the list of file imports, click the importfile that shows a warning or error.

   The import file details page shows the complete list of errors.

On the import file details page, you can review the assets and data fieldsthat cause the errors, and view a description of the error.Errors in the file import job might prevent Migration Center fromcreating new assets or update existing ones with the new changes.To fix the error, edit your files and create a new file import job to uploadthem again.

For more information about the possible error messages, seeTroubleshoot file import errors.

What's next

• Learn more aboutMigration Center collection methods.
• Learn how tomanage your file uploads.