If you are adding a table to your already existing replication environment, Enterprise Replication provides an initial synchronization feature that allows you to easily bring a new table up-to-date with replication. You can synchronize the new table with data on the source server you specify when you start the new replicate, or when you add a new participant to an existing replicate. You do not need to suspend any servers that are replicating data while you add the new replicate and synchronize it. See Initially Synchronizing Data Among Database Servers for more information.
Otherwise, if you have not yet set up your replication environment, for loading data, you can use the following tools:
When you unload and load data, you must use the same type of utility for both the unload and load operations. For example, you cannot unload data with the onunload utility and then load the data with a LOAD statement.
If you are using HDR with Enterprise Replication, follow the instructions in the section Loading and Unloading Data.
If the table that you are preparing for replication is in a database that already uses replication, you might need to block replication while you prepare the table. For information on how to do this, see Blocking Replication.
If a table that you plan to replicate includes the shadow columns, cdrserver and cdrtime, the statements that you use for unloading the data must explicitly name the shadow columns. If you use the SELECT statement with * FROM table_name to the data to unload, the data from the shadow columns will not be unloaded. To include the shadow columns in the unloaded data, use a statement like the following:
SELECT cdrserver, cdrtime, * FROM table_name
For more information, see Shadow Columns.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]