Use sync. with DB

Classic Servoy
1

Hi,

I work with 2 servers (one for development and one for production)

When I want to backup all my data from production database and load it in my development database, I see that next value of primary key is not update. So I always have to sync. the next value with database on all my tables (85 tables) or I get error “Duplicate primary key”.

So I tried to backup database from postgres and solution from servoy but the problem is always the same.

Anyone have a idea to recover the next value automatically?

I develop under Servoy 3.1.3, Mac OS/X and Postgresql 8.1

Regards

2

If you are using Servoy sequences, these sequences are stored in the repository database, typically not your “data” database. So if you only copy the “data” database, Servoy doesn’t notice the change and cannot do anything for you.

3

Oh ok thanks patrick

4

Hi,

if you use servoy sequences there is a button somewhere on the server admin to synch all sequences in one go.