Migration guide
How to migrate from pgAdmin to VeloxDB
This guide helps you move your PostgreSQL workflows from pgAdmin to VeloxDB without interrupting your current environments.
Prerequisites
- - Access to your current pgAdmin connection settings.
- - VeloxDB latest release installed on your machine.
- - Network access to your PostgreSQL instances.
Step-by-step
- 1.Document each pgAdmin connection profile (host, port, db name, SSL mode, and SSH details).
- 2.Create matching environments in VeloxDB for development, staging, and production.
- 3.Run validation queries in each environment to confirm role permissions and search paths.
- 4.Recreate daily query snippets and verify output parity between old and new workflows.
- 5.Adopt VeloxDB model designer for schema updates and migration planning.