The Replication Wizard is an easy way to replicate database objects (like tables, views, etc.) from a source database to one or more remote databases using a replication engine.
Select an existing data connection.
Enter an existing database name. You can use the Select a Database tool next to the list to search for an existing database. This action assumes that no data connection to your replication process exists at that time. By doing so, you automatically create the missing data connection.
Enter a new database name. This action assumes that both the database and the data connection to your replication process do not exist at that time. By doing so, you automatically create the missing database and data connection.
Make your selection, and then click Next.
Make your selection, and then click Next.
Select an existing replication process if the source database is linked to one or more replication process or click the Browse button to select a replication process that is not linked to the source database. The Type list is automatically filled with the type of the selected replication process. If the replication process is "Undefined", select a type (MobiLink or Replication Server) to proceed with the wizard. If you select a replication process that is not already linked to the source database, you automatically create the data connection between both objects in the diagram.
Create a replication process, and select a type (MobiLink or Replication Server). By doing so, you automatically create the corresponding replication process linked to the source database via a data connection in the diagram.
Make your selection, and then click Next.
Create or select an existing publication to gather all the replicated tables, and simplify the replication when several remote databases must duplicate the same set of tables.
Create a publication for each replicated table, and thus manage each table replication individually.
[only available for a replication process with a Replication Server type] Select a publication type (Undefined, Publication, Replication Definitions) that will influence the generation code for the Replication Server (see Working with Replication Server).
Make your selection, and then click Next.
Make your selection, and then click Next.
Enter an existing database name. You can use the Select a Database tool next to the field to search for an existing database. By doing so, you automatically create the missing data connection.
Enter a new database name. By doing so, you automatically create the missing data connection and database. Note that the database name must respect the following syntax: <server name>.<database name> (server name is optional).
Select one or more existing data connections in the lower part of the page.
Make your selection, and then click Next.
When you click Finish, the wizard creates:
A source database linked to a replication process, which is in turn linked to a remote database via data connections in the information liquidity diagram.
One or more publications in the replication process describing which objects (tables, views, and procedures) are replicated.
[Optionally] One or more subscriptions for each selected remote database connections.