Data blog RSS



How to install MySQL Connection Provider

SelectCompare can connect to without any problems. You only need to install the data provider, and when it has been installed, you can use SelectCompare to connect to the respective database and compare its data with any other data set you wish. OLEDB Data provider installation There is a number of different OLEDB providers for MySQL. In this example I will use one older, but still popular provider implemented by Cherry City Software. You can download the MySQL data provider from the download page. After you download the archive, extract its contents to a folder and run the setup. This is a pretty standard installation wizard. Follow the installation wizard until the installation is complete. You will have to have...

Continue reading



Write Select Statements for Excel Spreadsheets

SelectCompare allows for data comparison of Excel spreadsheets, as well as other data sources with simple, unified interface. You may be initially anxious about writing an SQL statement to pull data from your Excel, but it is actually pretty easy! This post will show you a few examples of writing queries against your spreadsheet that you will be able to use right away for your Excel data comparison. If you want to find out how to connect to an Excel workbook, please read another post on this blog - Compare Excel Spreadsheets You will see below how to query Excel spreadsheets, specify ranges of columns and rows, and write simple filters that make SQL so powerful. In a general sense,...

Continue reading



How to compare database schema with baseline

It is easy to create a comparison project to compare the schema of tables in a database and a saved baseline stored in Excel. After all, the database schema is stored in system views, and contains full information about your columns, data types, stored procedures and other elements of a typical database. For this post, I limited the schema information to the list of columns returned by the query  select * from information_schema.columns Note: This post uses SQL Server databases AdventureWorks2014 and AdventureWorks2008 databases as example environment, but you can connect any other database technology - MySQL, Oracle, MariaDB, PostgreSQL, and more! Create your data baseline I selected the columns information from AdventureWorks2008 and exported it to an Excel workbook using SelectCompare....

Continue reading



Create Excel baseline for your data

When you work with data, it is very useful to create a baseline to which you compare your data set. For example you can create the baseline from production data, and compare the results of a process you are implementing after the changes were introduced. This is a huge benefit for controlled environments: SelectCompare will highlight the changes in the output, and you don't have to query the production system anymore! Create Excel baseline from source data It is very easy to create a baseline in SelectCompare. When you create a project, write a query that will return the data you will want to use as the baseline. Use the required logic to extract the data that you need. Run the...

Continue reading