Skip to content

dbcopy: CLI tool to bare-copy a database into another one #260

@christianparpart

Description

@christianparpart
  • Create an API to construct SQL migration plan (create table instructions) from an existing schema (reuse existing API to fetch the schema)
  • Use this series of SQL migration objections to recreate the table schema in the destination
  • bulk-read each table from the source, and bulk-write them into the destination - this may need some convenience API to generically & efficiently (select/)insert (aka. "copy") the table
  • ensure some progress-report interface is being passed, such that the dbcopy/CLI/GUI can hook into it

CLI syntax

could possibly look like this:

dbcopy [--quiet] --from "DSN=SourceDSN;Uid=User;Pwd=Secret" --to "DSN=TargetDSN;Uid=User;Pwd=Secret"

So it should be trivial to copy from an MS SQL into an sqlite, and then repopulate anywhere else.

Metadata

Metadata

Labels

CLIcommand line interface tools

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions