Frank Henninger

Recent Blog Comments By Frank Henninger

• Performing Online ALTER TABLE SQL Migrations Without Any Downtime

  Posted on Jul 16, 2015 at 6:07 PM

  @Ben, You should be able to do the equivalent in Oracle and SQL Server using the MERGE syntax. This isn't a completely foolproof online solution though. You do that the small moments in time when your swapping the tables to contend with. Also, don't forget about any key relationships that need mov... read more »

• Ask Ben: Converting A Parent-Child Data Table Into A Nested XML Document

  Posted on Oct 28, 2010 at 4:02 PM

  This is actually something I try and do on the database side if the DB supports it. I could probably do this as a single select statement in oracle. Of course, having many different methods to get the same response is always useful!... read more »