Approach to take snashots/backup of cratedb schemas, which service we can take for backup of cratedb database schemas

Question

Approach to take snashots/backup of cratedb schemas, which service we can take for backup of cratedb database schemas.
We would liketo understand which ways is best for taking cratedb schemas timeseries data backup and to restore.

Answer 1

If you are using SQL Server (VM or on-premises) please consider using snapshot replication.

For SQL Server and Azure SQL, you can also use Transfer SQL Server Objects Task on SQL Server Integration Services (SSIS packages) to transfer schemas along with data from one database to another.

Answer 2

Hi @Gaurav Singh ,

Welcome to Microsoft Q&A platform and thanks for using Azure services.

As I understand your question, you want to know the approach to backup of created database schemas. Please correct me if I understood differently.

BCP Utility could be used for Export and Import.

Hope this helps. Please let us know your inputs.