The tool reports any discrepancies between schemas such as missing or mismatching tables, table columns, indexes and constraints. The Schema Comparison Tool lets you compare database schema objects in two separate schemas/databases. In the Compare Table Data – Select Tables dialog box, select the tables you want to compare, select the primary key in the Primary Key Columns section, and click Next. In the Compare Table Data – Settings dialog box, select the information about the data that you want to compare and click Next. In the Compare Table Data – Select Schema/Database dialog box, select the source and destination connections that contain the data you want to compare and click Next. You can compare tables in different databases, for example in two instances of Vertica, or you can compare data in two different database platforms, such as Vertica and SQL Server.įrom the Tools menu, select Compare Data. The tables can be in the same or different schemas/databases, and they can have the same or different names and columns. The Table Data Comparison Tool in DB Solo lets you compare data in one or more pairs of tables. When the connection succeeds, DB Solo displays the following message: Persist User Name / Password: Select the appropriate option for saving credentials.
#GIRLFRIEND DB SOLO DRIVER#
In the Add Server Connection dialog box, select the Vertica driver from the drop-down list and specify the following connection information: Note The Download button directs you to the Vertica home page.
#GIRLFRIEND DB SOLO DRIVERS#
Navigate to the Client Drivers page on the Vertica website.Double-click the installer and follow the on-screen instructions.Under Download Free Evaluation Version, read the instructions and the license agreement.The information in this document is based on the testing we have done with the following software versions: Software DB Solo runs on multiple platforms, supports multiple character sets, and allows simultaneous connections. Its graphical user interface lets developers and DBAs easily browse schema objects, create scripts, and perform DDL and DML operations. DB Solo OverviewĭB Solo is a comprehensive, visual tool for developing and managing SQL code in relational databases. Connection guides are based on our testing with specific versions of Vertica and the partner product.
Vertica connection guides provide basic instructions for connecting a third-party partner product to Vertica. Vertica Integration with DB Solo: Connection Guide About Vertica Connection Guides
0 kommentar(er)
