Skip to content

Home

Jump to bottom
misolt edited this page Aug 21, 2025 · 2 revisions

Data Warehouse Migration Tools

License

This project contains a collection of tools related to the BigQuery Migration Service.

Download the latest cross-platform release zip dwh-migration-tools-vX.X.X.zip.

The currently available tools are:

  • Metadata and Log Dumper: Utility for connecting to an existing database and generating an archive of DDL metadata or logs for consumption by Assessment or the Translation Service. For more information, read the tool documentation.

    To run the Dumper Java 8 or higher is required. Third party JDBC drivers might impose additional restrictions on Java versions. Refer to the JDBC driver's manual for details.

  • Batch SQL Translation Client: Command line utility to run a Batch SQL Translation job with support for macro expansion/unexpansion. For more information, read how to submit a translation job using the client and view the installation instructions.

  • Dbsync Tools (work in progress): Command line utility to sync large files into Google Cloud Storage. View the documentation.

Compiling from source

You need to have JDK 8 installed. For multiple jdk versions we recommend to use https://sdkman.io/

Build all the modules

./gradlew build

Build the DWH Dumper

./gradlew :dumper:app:build

Contributing

Contributing instructions are available, per tool, at the following locations:

Copyright 2023-2025 Google LLC

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at https://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Home

Clone this wiki locally