Changing name of DB Server connection?

Classic Servoy
1

Hi all

I would like to change the name of the DB Server connection. As this name is set in each form of the solution and the name changing doesn’t seem to update the name in the forms, I wonder if there is way to accomplish that consistently. If I have to do it by hand, what is the prefered order of changing the names (DB Server connection, then each form, …?)

Thanks and regards, Robert

Servoy Developer
Version 3.5.1-build 514
Java version 1.5.0_07-87 (Mac OS X)

2

As far as I know you have to do it by hand.

Calculations are pretty easy, you are notified at the beginning.

Forms would be the second project I guess.

BTW you can find out where your dbconnection is used pretty easily with the Analyzer :)
Never thought about a dbconnection renaming thing but that sure is doable…

3

Hi Robert,

This is quick and easy.

Open the repository from Servoy Developer, there you can change any reference to a DB Server connection to any other DB Server connection. You can also change the name of tables.

Hope this helps,

4

oops, forgot about that (I work with 2.2.7 for my samples, should ceise that)…

5

Hi Christian

Very handy, thanks!

Regards, Robert

swingman:
Hi Robert,

This is quick and easy.

Open the repository from Servoy Developer, there you can change any reference to a DB Server connection to any other DB Server connection. You can also change the name of tables.

Hope this helps,

6

oops, forgot about that (I work with 2.2.7 for my samples, should ceise that)…

This also works in 2.2.7… It’s called “Replace table”, I think.

7

but watch out!
you will use loose ALL your Auto ENTER data!!
(custom value, related lookup value, etc…)

8

nice tip !

9

:lol:

that’s why I never have used this function! :wink:

10

Well, if your solution is really big and u don’t want to go trough all the forms, etc you can consider to use databaseManager.switchServer(sourceName, destinationName) in your startup method.
One line of code and you’re done ;)

11

Hi Harjo

Thanks for the hint! The Servoy Sequence setting doesn’t seem to be affected, i. e. doesn’t seem to loose the setting when changing the DB Server connection!?
I am wondering what exactly gets lost (in Version 3.5.1)?
Did you already report this bug in the Support System?

Best regards, Robert

HJK:
but watch out!
you will use loose ALL your Auto ENTER data!!
(custom value, related lookup value, etc…)

12

Another easy way of changing server name in the whole solution:
Go in the repository,
Export your solution
go to prferences db servers rename your server or create a new one and disable the old one.
Exit servoy and reopen
ReImport the solution, Servoy will ask you what is the new server for the solution (because it can’t find the previous one)
Chose the new one
Everything ok …