Subscription without materialization

To create a database subscription when the primary and replicate databases have been synchronized prior to subscription, or activities at the primary database can be suspended, use create subscription with the without materialization clause. See the example in “Replicating the database”.

When you use the no materialization method, you can materialize the replicate databases using bcp, dump and load, mount and unmount, or other methods. Because Replication Server does not coordinate the initial database synchronization process, you will likely need to suspend database applications. Use this method if you are materializing the replicate database with a cross platform dump and load (XPDL).