{"repo":"Accenture/DBTestCompare","free":true,"listed":false,"github":"https://github.com/Accenture/DBTestCompare","clone":"git clone https://github.com/Accenture/DBTestCompare.git","description":"Application to compare results of two SQL queries","language":"Java","stars":30,"topics":["jdbc-drivers","sql-queries","teamcity","testng","database","tests","compare-data","sqlserver","mariadb","postgresql"],"license":"MIT","category":"databases-storage","readme_excerpt":"Application to compare results of two SQL queries It reads tests definitions in XML format form specified directory and than runs them (as TestNG test). You can generate automated tests for your database using DBTestCompareGenerator AI generated documentation If two SQL returns different results - test fails. Application supports TeamCity Service Messages (##teamcity messages) so if teamcityLogsEnabled is set to \"true\" (config file or command line parameter), you will see nice test tree in TeamCity logs. To execute tests run program (Java 8 must be installed first (JDK or JRE)): If you set JAVA HOME variable: or to add automatically all drivers from the directory to the classspath (jdbc drivers/ ) Windows Linux or e.g. The application provides the following features: - Platform independence - possibility to run on Windows and Linux as well (Java Runtime Environment 8 needed) - Supports all databases with JDBC drivers provided (tested with Microsoft SQL Server, Teradata, Snowflake, PostgreSQL and MySQL\\MariaDB) - Supports all Continuous Integration tools thanks to TestNG Java unit test framework - Possibility to compare data between two different database engines even for huge data sets without \"Out of memory problem\" thanks to an incremental solution, more details here - Possibility to compare query to expected data defined in csv file and generate Excel test report , more details here - Possibility to compare data in one database engine in the fastest way using MINUS/EXCEPT ","default_branch":null,"files":null,"tree":[],"storefront":"/r/Accenture","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Accenture/DBTestCompare/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}