Category Archives: Databases and SQL

Data migration in SQL Server

Posted on January 4, 2019 by hedleyproctor

Recently I’ve had to write a data migration for SQL Server to split a large table (28 million rows) into separate tables. Some notes here on my thoughts… Firstly, SQL Server has INSERT…SELECT syntax which allows you to copy from … Continue reading →

Posted in Databases and SQL, SQL Server | Tagged , | Leave a comment

Using database transactions with Apache Camel

Posted on May 6, 2013 by hedleyproctor

Just put an example of using database transactions with Apache Camel on github: https://github.com/hedleyproctor/camel-transaction-example It is based on the example given at the start of Chapter 12 of “Camel In Action”, but using database transactions, rather than a JMS transaction. … Continue reading →

Posted in Camel, Databases and SQL | Tagged , | Leave a comment

Comparing two MySQL databases

Posted on October 26, 2011 by hedleyproctor

When doing development, you’ll often have multiple versions of a database on different environments and sometimes it would be useful to be able to check the differences between the data. Did you know you can use the Toad database tool … Continue reading →

Posted in Databases and SQL, MySQL | Tagged | 2 Comments

NoSQL databases, scaling and Project Voldemort

Posted on April 28, 2011 by hedleyproctor

At the moment there is a lot of discussion of NoSQL databases. Rather than referring to a single thing, this term is more of a catch-all that refers to a number of different non-relational database designs. In fact, it is … Continue reading →

Posted in Databases and SQL | Tagged | Leave a comment