Two different solutions with the same Db, tables, fields.

Classic Servoy
1

Hi to all.

Could someone resolve this problem?

We made two different solutions in different times, using the same DB, tables, fields.
We used a unic solution for time.

Now we need to use both solutions toghether at the same time. But we could have conflict between fields.

So we think to transfer one solution in a different DB, with the same names of tables an fields.

Is it possible to be made?
How could we proceed on creating a new DB on Centos and trasferring tables?

Tanks in advance.

Gianni Pinna.

2

Hi Gianni,

You can do this with the following steps:

  1. Create a duplicate database.
    You mentioned before you are using PostgreSQL so this will be easy. If you are using the commandline tool psql then you can simply type:
    create database myNewDB template myOldDB;

If you use PgAdmin then you can create a new database by right-clicking on the Databases node, select New Database…
Put in the new name and owner and select in the Template combo-box the old database. Hit the OK button and your duplicate database is created (including data).

  1. Open Servoy and create a new database connection to the new database and save it. You might want to restart Servoy after this.

  2. Activate the solution you want to make use of the new database and right-click on the solution to open up the contextual menu.
    Select “Replace Server”.
    Now you get a dialog with a source and target field. Select the source (original) database and the new target database.
    Hit the Finish button and after it does it’s thing you are done.

Hope this helps.

3

Hi Robert,
received Your prompt replay. Tank You very much. Postgres is extremely good in itsef an in its men.
God Sunday, Robert.
Gianni Pinna.