Creating Connections via code

Creating Connections via code

Postby PKBolland » Wed 11 Jan 2017 20:08

We use a lot of dev databases within the company and I have a script that reads all databases and creates and xml connections file for use by another software package. I want to know if its possible to apply the same principle to dbForge by writing connection entries directly into the windows registry. Is it possible to get information on what registry keys are used to support connections.

Or is there an alternative method available.

Thanks
PKBolland
 
Posts: 5
Joined: Sun 04 Aug 2013 21:32

Re: Creating Connections via code

Postby YuriP » Thu 12 Jan 2017 10:29

Hello,

You could find dbForge Connections in registry branch:
Code: Select all
HKEY_CURRENT_USER\SOFTWARE\Devart\dbForge Common Settings\Connections\PostgreSql

You could also set custom connections in command line directly.
For example:
Code: Select all
set p=C:\Program Files\Devart\dbForge Data Compare for PostgreSQL
set ds=/source connection:"Host=db;Port=5444;Database=dc1;User ID=postgres;Password=postgres;"
set dt=/target connection:"Host=db;Port=5444;Database=dc2;User ID=postgres;Password=postgres;"

"%p%\datacompare.com" /datacompare %ds% %dt%


For getting more detail information about command line use the command:
Code: Select all
set p=C:\Program Files\Devart\dbForge Data Compare for PostgreSQL

"%p%\datacompare.com" /datacompare /?


Best regards,
Yuri.
YuriP
 
Posts: 7
Joined: Fri 27 May 2016 12:49
Location: Devart

Re: Creating Connections via code

Postby PKBolland » Wed 18 Jan 2017 22:00

Thanks YuriP.
PKBolland
 
Posts: 5
Joined: Sun 04 Aug 2013 21:32


Return to dbForge for PostgreSQL