In my application I use multi tenant design in my SQL Server database. My question is: what if one of my customer comes and say, I want my own data as a backup file, how can I create backup file for just that tenant? Is there is any way to do that? Do I need any 3rd party tool? Can
Tag: database-backups
Postgres Dump Selected Rows
I have a database that has a central object that most of the data depends on; many reference table, one to many joins and many to many joins. I need to back up all rows based on a property in the central table and be able to restore these rows. For backup purposes. I have added ON DELETE CASCADE to