Infrastructure at your Service

Migration Archives - Blog dbi services

David Hueber

ODA migration challenges: Non-OMF to OMF + 11.2.0.3 to 11.2.0.4

By | Database Administration & Monitoring | One Comment

To do some application and performances tests, I had to copy a database from a third party Linux server to an ODA X7-2M. Looks pretty simple on the paper, but 2 small challenges came into the game. The first was that of course the source database was in Non-OMF while ODA works fully in OMF. The second was that the source database is running 11.2.0.3 which is not supported and cannot be installed on the…

 
Read More
Jérôme Dubar

One command database upgrade on ODA

By | Database Administration & Monitoring | No Comments

The 12.2 finally arrived on ODA and is now available on all generations. Modern ODAs are now supporting 11.2.0.4, 12.1.0.2 and 12.2.0.1 database engines, and these 3 versions can work together without any problem. You probably plan to upgrade some old databases to the latest engine, at least those still running on 11.2. As you may know, 11.2  is no more supported with premier support since January 2015: it’s time to think about an upgrade….

 
Read More
Stéphane Haby

Migration to SQL Server 2016 with deprecated data types and Full-Text

By | Database Administration & Monitoring, Database management | No Comments

A few weeks ago, I prepared a migration from SQL Server 2008 to SQL server 2016, I came across a case with deprecated data types and a Full-Text activated on these columns. To simulate this scenario, I downloaded and installed the Data Migration Assistant(DMA). Make sure that the .Net Framework 4.5 is installed on your machine before starting the installation of the DMA. After the installation, you start the application which is very simple to…

 
Read More
David Barbarin

SQL Server 2017 on Linux and some log shipping scenarios

By | Database Administration & Monitoring | No Comments

In this blog let’s talk a little bit about the log-shipping feature from the SQL Server CTP 2.0. First of all, let’s say that as a Windows version, it is possible to create our own solution based on Linux (and cron jobs for example). You may find out different pointers on the internet that deal with this topic. But getting the built-in log-shipping feature from SQL Server presents some advantages. Indeed, this is basically the…

 
Read More
David Barbarin

Migrating your existing availability group infrastructure to 2016

By | Database Administration & Monitoring | No Comments

Have you already a plan to migrate your old SQL Server 2012 availability group infrastructure to windows 2016 and SQL Server 2016? In a previous post, I talked about distributed availability groups and cross-cluster migration scenarios but this time the game is not the same because we want to achieve an in-place upgrade of the existing AG infrastructure. This question will probably be a concern the next year and if we take a closer look…

 
Read More
David Barbarin

SQL Server 2016: Distributed availability groups and Cross Cluster migration

By | Database Administration & Monitoring | No Comments

How to migrate an environment that includes availability groups from one Windows Failover Cluster to another one? This scenario is definitely uncommon and requires a good preparation. How to achieve this task depends mainly of your context. Indeed, we may use a plenty of scenarios according to the architecture in-place as well as the customer constraints in terms of maximum downtime allowed for example. Among all possible scenarios, there is a process called “cross-cluster migration…

 
Read More
Stéphane Haby

SQL Server 2005 decommissioning failed!

By | Database management | No Comments

The support for SQL Server 2005 is no more available, so we are migrating all the latest databases running under SQL Server 2005 to SQL server 2012 or higher! Last time, I had to uninstall an old SQL Server 2005 clustered instance in a 64 bits architecture on Windows Server 2008R2. In fact, this clustered environment contains many other instances (either SQL Server 2005 or 2008 R2). But during the uninstallation, an error happened…. First,…

 
Read More
Daniel Westermann

pg_dump: [archiver (db)] query failed: ERROR: schema “sys” does not exist

By | Database Administration & Monitoring, Database management | No Comments

As I could not find any information about this error when I faced it this is just a short hint: If you try to use pg_dump or pg_dumpall out of a PPAS installation to dump or dumpall a community version of PostgreSQL you probably get this: pg_dump: [archiver (db)] query failed: ERROR: schema “sys” does not exist pg_dump: [archiver (db)] query was: SET search_path = pg_catalog, sys, dbo The solution is quite easy but you…

 
Read More
Daniel Westermann

Migrating the Oracle 12cR1 sample schemas to PostgreSQL Plus Advanced Server 9.4

By | Database Administration & Monitoring | No Comments

This post takes a look on how to migrate the Oracle 12cR1 sample schemas to PPAS 9.4 (PostgreSQL Plus Advanced Server 9.4). I’ll not dig into how to install PPAS as this was described in detail some time ago. Just follow this post if you need a setup guide. If you wonder why I am doing this there are two reasons: to see if it works, to have fun and to learn PostgreSQL and PPAS…

 
Read More
Stéphane Savorgnano

SQL Server 2016: Transaction Performance Analysis Overview & In-Memory OLTP Migration Checklists

By | Database Administration & Monitoring | No Comments

To be able to define which Tables or Stored Procedures will us the best performance gain after migration to In-Memory OLTP, SQL Server 2014 provided a tool called AMR (Analysis Migration and Reporting). This tool was really interesting but we should have, before to use it, to create a Management Data Warehouse and so on… (I wrote a blog here for this configuration and an article on SQL Magazine here) With SQL Server 2016, actually…

 
Read More