Can Backup skip some tables?
-
- Posts: 77
- Joined: Wed 08 Oct 2008 04:55
Can Backup skip some tables?
I note that the new GBAK program now has the SKIP_DATA ie something like
gbak -skip_d '(sales|customer)' employee e1.fbk
Does the IBCBackupService now have this capability? Or is there some way I can implement this behaviour? There are some transaction tables that we have that are huge and we simply do not need to back them up sometimes.
gbak -skip_d '(sales|customer)' employee e1.fbk
Does the IBCBackupService now have this capability? Or is there some way I can implement this behaviour? There are some transaction tables that we have that are huge and we simply do not need to back them up sometimes.
Re: Can Backup skip some tables?
Currently, IBDAC does not support the use of the SKIP_DATA parameter when executing backup/restore procedures. We will add this support to the next release of IBDAC.
-
- Posts: 77
- Joined: Wed 08 Oct 2008 04:55
Re: Can Backup skip some tables?
thank you - will be looking for it eagerly!
Re: Can Backup skip some tables?
We have added support for SKIP_DATA parameter when executing backup/restore procedures. This fix will be included in next IBDAC build.
Currently, IBDAC does not support the use of the SKIP_DATA parameter when executing backup/restore procedures. We will add this support to the next release of IBDAC.
We can send you a IBDAC night build including the support. Please provide your license number and IDE version to us using the contact form https://devart.com/company/contactform.html and we will send you a night build.
Currently, IBDAC does not support the use of the SKIP_DATA parameter when executing backup/restore procedures. We will add this support to the next release of IBDAC.
We can send you a IBDAC night build including the support. Please provide your license number and IDE version to us using the contact form https://devart.com/company/contactform.html and we will send you a night build.
-
- Posts: 77
- Joined: Wed 08 Oct 2008 04:55
Re: Can Backup skip some tables?
Thank you for including this new function. I have seen the new option "SkipDataTables" but you don't seem to have updated the online documentation.
I have attempted to set this option to the name of a table (ie SkipDataTables='nameoftable'). This does not seem to work. Is there something else I need to do? What if I need to omit a number of tables?
Edit : I see that you also have to set the Option (boSkipData), so it seems that you can omit the data from a single table ok. How can I skip multiple tables? I have tried separating the names in various ways...ie
table1 table2
table1,table2
table1|table2
table1;table2
none of these seem to work...
I have attempted to set this option to the name of a table (ie SkipDataTables='nameoftable'). This does not seem to work. Is there something else I need to do? What if I need to omit a number of tables?
Edit : I see that you also have to set the Option (boSkipData), so it seems that you can omit the data from a single table ok. How can I skip multiple tables? I have tried separating the names in various ways...ie
table1 table2
table1,table2
table1|table2
table1;table2
none of these seem to work...
Re: Can Backup skip some tables?
To solve your task, you can use the following code:
If this does not help in solving the issue, please compose a small sample demonstrating the issue including the script for creating and filling in the database objects and send it to us via form e-support: https://devart.com/company/contactform.html Also, specify the exact version of Firebird.
Code: Select all
IBCRestoreService.Options := IBCRestoreService.Options + [roSkipData]; //enable the ability to use skip_data
IBCRestoreService.SkipDataTables := 'dept|emp|name'; // list tables using |. For one table, just specify its name.
-
- Posts: 77
- Joined: Wed 08 Oct 2008 04:55
Re: Can Backup skip some tables?
thanks for that. I had tried the | as a separator and it was not working. But it worked ok today, so dunno what that is all about.
Thanks for this new feature.
Thanks for this new feature.
Re: Can Backup skip some tables?
It is good to see that the problem has been solved.
Feel free to contact us if you have any further questions about our products.
Feel free to contact us if you have any further questions about our products.