Deploying a project

[dgoadby]

I'm getting used to nuBuilder and it's a very productive tool. So far I have created forms and reports and tables in the original development environment.

I now want to deploy the application to the target system which has an existing database. I can copy the new tables across ok but what do I do with the actual application? I can copy the nuBuilder folder to the Apache htdocs folder and the database tables to the traget MySQL database but, do I just change the database settings in the config file to match the new database?

Are there any traps/pitfalls in this strategy?

Also, what if I need to access data from more than one database? Can this be done easily?

And, finally, how can I clone a form or report from one development environment to another?

[kev1n]

I now want to deploy the application to the target system which has an existing database. I can copy the new tables across ok but what do I do with the actual application? I can copy the nuBuilder folder to the Apache htdocs folder and the database tables to the traget MySQL database but, do I just change the database settings in the config file to match the new database?

Are there any traps/pitfalls in this strategy?

1. Export the whole DB to an SQL file and import the db dump to the destination database.
2. Copy the nuBuilder files to the target location.
3. Update the nuConfig.php file

Also, what if I need to access data from more than one database? Can this be done easily?

nuBuilder doesn't support multiple databases. But you can use the PHP BE (Before Edit) to load data from another db.

And, finally, how can I clone a form or report from one development environment to another?

There is no direct way but you can copy the corresponding rows from source to destination.

Data is mainly stored in these tables:

zzzzsys_object
zzzzsys_form
zzzzsys_php
zzzzsys_tab
zzzzsys_event
zzzzsys_report

[dgoadby]

Thank you very much for a very comprehensive reply.

That's just what I wanted to know.

[admin]

.

[miasoft]

nuBuilder doesn't support multiple databases. But you can use the PHP BE (Before Edit) to load data from another db.

I don't understand, all my databases in new projects must have name "nubuilder4" ?
(I am new, sorry)

[Janusz]

Hi,
You can assign any name you want to your database - and you can create as many DB as you want.
But in one browser you can open only one at the same time if they are on the same domain (if on different domains no problem)
If you want to open another one (in the same browser) - first you need to close the first DB switch OFF and ON the browser (like Chrome for example) - or if you do not want to restart browser you need to clean cookies for that domain.
At the same time you can open as well different databases on different browser for example one in Chrome the other in Firefox if needed.

Przechwytywanie.JPG

and in nuconfig.php
you need to indicate the name of DB

Code: Select all

$nuConfigDBName                 = "TestDB";

as well you can assign different globeadmin names do different DB. In my case I keep for example as following - but you can do here as you want.

Przechwytywanie1.JPG

[miasoft]

Thank you, Janusz!

[apmuthu]

A multi tenanted nuBuilder can be made by the config file having an array of arrays, one element array for each database.