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

You can use the same disk-resident database as a template to initialize multiple in-memory or relaxed-durability databases.

Note: After a shutdown or termination and a subsequent restart of Adaptive Server, Adaptive Server recreates the in-memory or relaxed-durability database automatically from the template. When Replication Server resumes the connection to the replicate in-memory or relaxed-durability database that you created, Replication Server may reapply commands, as the information used by Replication Server to detect the latest command that was applied is lost when you restart Adaptive Server.

Create the template database. The template database uses the name of the database with the outbound connection to Replication Server which is usually the replicate database name.
```
create database tokyo_db on publicdev=10 log on publicdevlog=10
go
```
Use rs_init to add the replicate database to the replication system.
Suspend the DSI thread to the template database by stopping RepAgent on the template database. For example:
```
suspend connection to TOKYO_DS.tokyo_db
```

Rename the template database to template1:

use master
go
sp_dboption tokyo_db, single, true
go
sp_renamedb tokyo_db, template1
go
sp_dboption template1, single, false
go

Create the in-memory or relaxed durability database with durability set to no_recovery using the template created in step 1:

create inmemory database tokyo_db
use template1 as template
on imdb_cache_dev = '50' log on imdb_cache_dev_log='50'
with DURABILITY=NO_RECOVERY
go

Connect to Replication Server and resume the connection to the replicate database:
```
resume connection to TOKYO_DS.tokyo_db
```