Install Query Runner
On this page
To use the Test Queries pane, Relational Migrator must have access to the Query Runner. Query Runner is a Docker container with all the dependencies needed to test your converted queries.
About this Task
If the version of Query Runner is different than the version of Relational Migrator, a warning banner displays.
To update Query Runner to the latest version, run the
docker pullcommand from step number one.Query Runner operates using the
httpprotocol. Requests made from a remote machine are not encrypted.Query Runner can run either locally or remotely.
Before you Begin
Install Docker.
Steps
Run the Image as a Container
To run the container locally:
docker run --name relational-migrator-query-runner -p 127.0.0.1:6080:6080 public.ecr.aws/v4d7k6c9/relational-migrator-query-runner To run the container remotely:
Add the server address where the service is running to the
migrator.language-runner.server.addressin theuser.properties.For example:
migrator.language-runner.server.address: http://myserver:6080 Tip
For details on where the
user.propertiesfile is located, see Relational Migrator File Locations.After changing the
user.propertiesfile, restart Relational Migrator.Launch the container from your remote server or container hosting service.
To launch the container on your remote server expose port
6080with the following docker command:docker run --name relational-migrator-query-runner -p 6080:6080 public.ecr.aws/v4d7k6c9/relational-migrator-query-runner
Confirm the Query Runner container is running
In your web browser, navigate to the host and port the Query Runner container is using. For example: http://localhost:6080/status.
Check the status field of the JSON data returned from the
status endpoint. A status of ok means the container is
running:
{ "status":"ok", "server":"App Mod Language Runner", "commitHash":"159119004c2bf8c534e15e5895acb9bc1bfb5b8d", "version":"20240627" }