You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
dbcopy/CLI/GUI can hook into itCLI syntax
could possibly look like this:
So it should be trivial to copy from an MS SQL into an sqlite, and then repopulate anywhere else.