I hope someonecan help me with this.
We have a production server with a VLDB on it (~ 7 Billion rows, ~ 4 TB).
We are now setting up a (new) Test environment and for specific reasons we want some of the LIVE OLTP data to be replicated via transactional replication.
I only want to replicate new data coming in, not the data that is already there.
So I don't want to generate a Snapshot (also because it would be way too large). I just want the records from one table coming in after I switch on the replication to be replicated to the (initially empty) test server (schema and everything of course already set up).
Will this work if use this to create my publication:
@publication = N'Test'
, @description = N'Publication of database ''Test'', Table testTab.'
, @sync_method = N'concurrent'
, @retention = 0
, @allow_push = N'true'
, @allow_pull = N'true'
, @allow_anonymous = N'false'
, @allow_subscription_copy = N'false'
, @add_to_active_directory = N'false'
, @repl_freq = N'continuous'
, @status = N'active'
, @independent_agent = N'true'
, @immediate_sync = N'false'
, @allow_sync_tran = N'false'
, @autogen_sync_procs = N'false'
, @allow_queued_tran = N'false'
, @allow_dts = N'false'
, @replicate_ddl = 1
, @allow_initialize_from_backup = N'false'
, @enabled_for_p2p = N'false'
, @enabled_for_het_sub = N'false'
Will this create a publication without the need of a snapshot and will the replication work as I need it?
I'd be very thankful if someone could confirm this for me.
And of course I'll try it on a smaller database in my dev-lab before hand. Just want to know if I am on the right track.