|
|
|
To compare two databases you need to specify connection string for each database.
There are several parameters that usually should be defined: 1. Driver - one of OLEDB drivers that already installed on loval computer; 2. Server - name of database server; 3. User Name and Password - user credentials. ![]() Also you can use a standard connection string builder dialog: ![]() Normally a connection string has a format like that: Provider=SQLOLEDB.1; Persist Security Info=False; User ID=user; Data Source=TEST_1 |