nuBuilder Forum

Overview of the nuBuilder Cloner Feature

The Cloner in nuBuilder is a powerful tool that allows you to replicate forms (and optionally their related objects) from one nuBuilder database to another. It generates SQL statements that can be run in your destination database (or even within the same database) to create or update forms and objects. This is especially useful when moving forms between development and production environments, or when you want to reuse a form design without having to rebuild it from scratch.

Here's the process to replicate a nuBuilder form in another database.

Replicating a Form Using the Cloner

1. Open the Cloner in the Source nuBuilder

1. Open the Database Dropdown menu in your source database.
2. Select Cloner.

2. Configure the Cloner

1. Click Add and select Source Form.
2. In the options:
   - Untick “Generate new PKs” – This ensures that the replicated form and objects retain the same database IDs (primary keys) as the source form and objects.
   - Tick “REPLACE INTO” – This will update any already existing forms or objects with the updated version from the source database.

3. Generate and Copy the SQL

1. Click Run to generate the SQL output.
2. Copy the generated SQL to your clipboard.

(You can save the cloner configuration at this point as well)

4. Execute the SQL in the Destination Database

1. Open the Destination nuBuilder.
2. Click the Database button to open phpMyAdmin.
3. Paste the copied SQL into the query editor.
4. Click Run to execute the SQL.

Video:



Workflow:
Result: The form is now replicated in the destination database.


Wiki documentation

Here's a more in-depth description of the Cloner, outlining various use cases in greater detail.: