Using a Database Dump to set up Replication for a Replicate In-Memory Database

You can set up replication if you use a dump from another database to initialize the in-memory or relaxed-durability as a replicate database. The replicate in-memory or relaxed-durability database inherits the configuration of the database from which you obtained the dump.

1. Create the in-memory or relaxed-durability database:

   create inmemory database tokyo_db
   on imdb_cache_dev2 = '50' log on imdb_cache_dev_log2='50'
   with DURABILITY=NO_RECOVERY
   go

2. Create the objects such as, tables and stored procedures, users, and permissions required to receive replicate data, or you can load a database dump.
3. Use rs_init to create the Replication Server connection to the in-memory or relaxed-durability database.
4. Perform a dump to save the current state of the in-memory or relaxed-durability database:
   1. Suspend the connection to the in-memory or relaxed-durability database:

      suspend connection to RDS.imdb1
      go

   2. Obtain a database dump of the in-memory or relaxed-durability database:

      dump database imdb1 to '/databases/dump/tokyo_db.dump'
      go
      

   3. Resume the connection to the in-memory or relaxed-durability database:

      resume connection to RDS.imdb1
      go