Duplication nubuilder solution Topic is solved

[yvesf]

Hello,


I have a nubuilder solution that is in production with data.
I have another customer which is interested by the same solution.
How can I duplicate the current solution without data ?
Going forward, I will add new features/fixes. Is there a way to update the 2 solutions without doing the job twice ?
Many thx,

Yves

[kev1n]

Define "without data"

[yvesf]

Kev1n,

Can you please clarify your answer ?
Where should I check define without data ?
Many thanks,

Yves

[kev1n]

When you say "without data," do you mean that the new solution should be created without any of the data from the current solution? Or do you mean that some specific data should be excluded when duplicating the solution? It's important to clarify what data should be excluded to ensure that the new solution is created correctly.

[yvesf]

To clarify, without data, I would like to remove all the data that is created with the forms. I would like to keep objects, reports, functions, dropdown liste values.
I would like to exclude the created users, and all the data created by the end users in the nubuilder solution keeping only the core system.
I hope it's clear enough difficult to explain.

[kev1n]

To create a duplicate database for your customer, you can follow these steps:

1. Export your existing database: Access phpMyAdmin, select the database you wish to duplicate, and export it. This will generate an SQL dump of your database.

2. Create a new database for your customer (On your server): In phpMyAdmin, click the 'New' option in the left sidebar to create a new database. Enter a name for the database and click the 'Create' button.

3. Import the database dump: Select the new database, navigate to the 'Import' tab, and upload the SQL dump file that you exported in step 1. This will recreate the database structure.

4. Remove unwanted records: To remove unwanted records in specific tables such as users, access levels, or custom tables, you can delete them using SQL queries. For example, to remove certain users or access levels, you can run the following queries on the new database:

Code: Select all

DELETE FROM zzzzsys_user;
DELETE FROM zzzzsys_access;
DELETE FROM zzzzsys_access_form;
DELETE FROM zzzzsys_access_php;
DELETE FROM zzzzsys_access_report;

Of course, you will need to run the queries on the newly created database. Please make sure to delete the records of the tables you created as well.

5. Export the new database again.

6. On your customer's server, create a new database.

7. Import the SQL dump file into the new database.

To maintain and update the two solutions without duplicating the work, you can use the cloner to clone or update specific forms. If you have any specific questions, feel free to ask for further directions.

Note that synchronizing data between two databases on different servers can be more complex and time-consuming than synchronizing data between two databases on the same server.