migration

Continuous Integration & Delivery for Databases

This talk looks at the common problems faced with making database changes through continuous delivery. It covers the major tools used to address database changes, and the advantages and disadvantages to each. Then it discusses how database migrations can effectively address schema changes over time, for both SQL and NoSQL databases. Finally, it explores solutions …

Continuous Integration & Delivery for Databases Read More »

Changing Database & Datacenter at Lanyrd.com

As is the case for many websites and applications, when the size of its users reach a certain point, critical changes to the architecture must be made. This presentation discusses how Lanyrd addressed this problem, when they decided to move from MySQL to PostgreSQL, and from AWS to Softlayer.

Migrating from MySQL to PostgreSQL

This talk shares hindsights about the why and the how of that migration, what problems couldn’t be solved without moving away and how the solution now looks. The tools used for migrating away the data, the methods and will detail the new architecture. And the new home: in the cloud!

Moving from MySQL to Couchbase Server – Part 1

Moving from a relational database, like MySQL, to a NoSQL database, like Couchbase, requires that you change the perspective on your data. In this article, MC Brown explains the differences between structuring data for a MySQL and a Couchbase database. He also discusses how these differences impact your queries.

Cloud-Ready Data Services

Windows Azure includes a complete set of enterprise-ready data services, including Windows Azure Storage and SQL Databases. In this demo-filled session developers will see how to can effectively use these services to develop and migrate data-centric applications to Windows Azure, while using familiar tools.

Migrating from Oracle to PostgreSQL

This video presents Ora2Pg, a free tool that you can use to migrate an Oracle database to a PostgreSQL compatible schema. Ora2Pg connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into your PostgreSQL database.