Hi there,
Another question about repository. I have rev 1 of a solution live in production. I’ve made major changes on a test environment (rev2). Now I want to import and activate rev2. I know there’s a few choices during import and I guess i just want to confirm i’m doing the right thing since this is a production environment.
After rev2 is in the repository, and then when i’m ready to make rev2 active, do I need to go to each table’s PK field and “sync with DB” I’m using servoy Seq.
or does rev2 automatically sync up the primary key?
Hi Sammy,
Servoy sequences are stored on the named connection, not the solution and are not exported/imported with the solution.
So no need to sync the Servoy sequences.
And when you need to sync them with the DB you can go to the Database Servers page in the Servoy server admin pages and hit 1 button to update all Servoy sequences in that connection.
Hope this helps.
ROCLASI:
Hi Sammy,
Servoy sequences are stored on the named connection, not the solution and are not exported/imported with the solution.
So no need to sync the Servoy sequences.
And when you need to sync them with the DB you can go to the Database Servers page in the Servoy server admin pages and hit 1 button to update all Servoy sequences in that connection.
Hope this helps.
Basically, i can just activate rev 2 without any other procedures. Good.
So when do you ever need to “sync” with the database?
sammyzheng:
So when do you ever need to “sync” with the database?
Like when you connect your Servoy Developer to the datasource of the server and add new records. This will use your local sequences and not the server sequences. So then you need to resync.
So basically when you don’t use your Servoy server on that server to create records you need to sync with the database.
ROCLASI:
sammyzheng:
So when do you ever need to “sync” with the database?
Like when you connect your Servoy Developer to the datasource of the server and add new records. This will use your local sequences and not the server sequences. So then you need to resync.
So basically when you don’t use your Servoy server on that server to create records you need to sync with the database.
and in that case, it’s generally pretty safe to just hit the ‘update all table sequence’ button?
Well Servoy server explicitly warns not to do this with clients connected. So I suggest you message the clients that use that connection to close the client (or force close) and when they are closed you can sync the sequences.
ROCLASI:
Well Servoy server explicitly warns not to do this with clients connected. So I suggest you message the clients that use that connection to close the client (or force close) and when they are closed you can sync the sequences.
thanks for that tip!
just to confirm again, If I use the same data source (since I have the server which hosts the servoy solution) and my own laptop which I do development on. As long as I do the import using the SERVER, i don’t have to sync the pk?
Correct.
And it’s very much recommended to always use the admin pages to import a solution into Servoy server.
So it knows what was imported and also what (possible) changes where made to the back-end database, etc.