Page 1 of 1

Migrating Applications

Posted: Wed Feb 19, 2025 7:41 pm
by jtoonen
Hello, as an old timer of application development, I am used to a develop, test and production environment.
With the provided Backup function it is easy to clone a develop database from a production database. As is a test database.
What I currently have to do manually is to delete all tables in the develop database but the zzzz tables, backup these and delete manually all zzzzz tables from the test database in order to import the backup containing the zzzzz tables only. And by doing this copy the develoment version of the application into the test environment for acceptance testing. In a similar action I can go back to a prvious application version.
My question: Wouldn't it be a good idea to add two functions: One to backup the application data (zzzz tables) and one to wipe the current application data and load a different appliction set/version? It would also allow during development to save a "checkpoint" while making changes.
Or is there a (good) reason, I do not see, for NOT executing the steps as I do

Re: Migrating Applications

Posted: Thu Feb 20, 2025 12:32 am
by steven
Hi jtoonen,

If you have a way that you would like your backup to work.
You can create your own Procedure that will remove all the zzzz files.
Or conversely a Procedure that removes all but the zzzz files.


To answer your question...
Is there a (good) reason, I do not see, for NOT executing the steps as I do?

homer.png

Homer Simpson once said "I could do a lot of things if I had some money."
Sadly, nuBuilder is run by volunteers.


Steven

Re: Migrating Applications

Posted: Thu Feb 20, 2025 6:49 am
by kev1n
One to backup the application data (zzzz tables) and one to wipe the current application data and load a different appliction set/version?
Hi,

The backup procedure already supports including and excluding specific tables, but it is not yet ready for use. Further exploration is needed to integrate this functionality into the UI.

Re: Migrating Applications

Posted: Tue Mar 11, 2025 7:41 am
by kev1n
In nuBuilder 4.6, you can specify dump settings. For example, to export only zzzzsys-tables:

Code: Select all

function nuRunBackup() {

	if (!nuGlobalAccess()) return;

	var dumpSettings = {
		'nuTableFilter': 'nu', // nu: only zzzzsys_ tables, user: not zzzzsys_ tables, empty: all tables		
	};

	if (confirm(nuTranslate("Perform the Backup now?"))) {
		nuMessage(`${nuTranslate('Information')}`, `${nuTranslate('Backup is running')}` + "...");
			nuRunPHPHiddenWithParams('NUBACKUP', 'NUBACKUP_params',{settings: dumpSettings});
	}

}