db-to-sqlite icon indicating copy to clipboard operation
db-to-sqlite copied to clipboard

Added --no_data argument

Open dahvid opened this issue 1 year ago • 1 comments
trafficstars

The --no_data [table name] argument will copy only the schema, but not any data for the named table. It works similar to the --skip argument in that it can be issued multiple times in a single command line.

Use case for this is transferring an MSSQL database with tables with many rows that you don't need in the sqlite version, but you do need the empty schema.

dahvid avatar Oct 28 '24 08:10 dahvid

There was a bug in the previous --no_data addition. Primary keys were not being copied into the new schemas.

dahvid avatar Nov 03 '24 13:11 dahvid