Backup (Restore) 1 table.
Posted: Wed 15 Apr 2020 01:04
The new Backup/Restore function where you can exclude tables to backup/restore is very useful and I am using it just fine.
During normal operation (like when I want to process a daily run or something), I really only want to backup only the tables affected by my processing. ie perhaps 2 or 3 tables.
I suppose I can get a list of tables from the DB, then make up a list of tables to exclude everything except the tables I want to backup, but this seems very cumbersome. My DBs have hundreds of tables, so I suspect this list will hit some sort of commandline or string length limit somewhere.
I am currently using the DADump function in UniDac to dump the tables involved to an INSERT script, and this seems to be ok. I am not sure how the Restore side of this will work with autoinc identity fields. Probably other issues as well for our support guys (more complex, etc).
I can also do a full backup using IBC and this works fine. Takes ages, of course as our DBs are quite large (up around 10 gigs or more).
Is there a 'trick' to backing up one or two tables? Is it possible?
During normal operation (like when I want to process a daily run or something), I really only want to backup only the tables affected by my processing. ie perhaps 2 or 3 tables.
I suppose I can get a list of tables from the DB, then make up a list of tables to exclude everything except the tables I want to backup, but this seems very cumbersome. My DBs have hundreds of tables, so I suspect this list will hit some sort of commandline or string length limit somewhere.
I am currently using the DADump function in UniDac to dump the tables involved to an INSERT script, and this seems to be ok. I am not sure how the Restore side of this will work with autoinc identity fields. Probably other issues as well for our support guys (more complex, etc).
I can also do a full backup using IBC and this works fine. Takes ages, of course as our DBs are quite large (up around 10 gigs or more).
Is there a 'trick' to backing up one or two tables? Is it possible?