Import/Export NoSQL Data
This feature is only available in NCache Enterprise Edition.
With NCache NoSQL database, you can backup in-memory data using any of the NoSQL database providers supported by NCache. Keeping in view the need to migrate data between different NoSQL databases, NCache allows you to import and export persisted data.
Export-NCacheNoSQLData: exports persisted data to a JSON or CSV file.
Import-NCacheNoSQLData: imports data to a NoSQL database from a JSON or CSV file.
Export-NCacheNoSQLData tools enable data migration for NoSQL databases. Meanwhile, data migration between local and clustered cache is not supported.
Using export and import together, you can easily migrate between different NoSQL databases or populate your NoSQL database before use. Here is how you can use the PowerShell tools provided by NCache to export data of a NoSQL store to a JSON/CSV file and then import it to your NoSQL database.
Import/Export is not allowed on Local Cache.
Export NoSQL Data Using PowerShell
The default file format for export is JSON.
Export-NCacheNoSQLData cmdlet enables you to export data persisted in NoSQL database to a JSON or CSV file. You can export data while cache is either running or stopped. The exported file has timestamp appended to the file name as cache_name-yyyyMMdd-HHmm and is created with .tmp extension. It is renamed to .json or .csv extension only when export is successfully completed.
Your store should not be empty while exporting data. If your store is empty, you will get an error that "There is no data in cache to export".
The following example exports all persisted data of cache named demoCache on server 126.96.36.199 to a new JSON file named demoCache-20220214-1127.json on the UNC path \\Fileserver\EXIM\.
Export-NCacheNoSQLData -CacheName demoCache -Server "188.8.131.52" -Format JSON -UNCPath "\\Fileserver\EXIM\"
Import NoSQL Data Using PowerShell
Import-NCacheNoSQLData cmdlet enables you to import data to your persistence store from a JSON or CSV file that is already created using NCache
Import-NoSQLData tool, cache should be stopped.
The following example imports all data from a JSON file demoCache-20220214-1127.json existing on the UNC path \\Fileserver\EXIM\ to the persistence store of a cache named demoCache on server 184.108.40.206.
Name of the file you want to import should be provided along with directory in
Import-NCacheNoSQLData -CacheName demoCache -Server "220.127.116.11" -UNCPath "\\Fileserver\EXIM\demoCache-20220214-1127.json"