Migrating Applications Topic is solved

[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

[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

[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.

[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});
	}

}