Varying Takes on Database Naff

by Kofi Sarfo 1. June 2010 18:41

Migrating from a database we quite like to one we do not provides as much fun as surgery.

After the DBA has promoted the database into QA we find our application is spouting Primary Key violations because the sequence.nextval values are below those used within their respective tables. Identity columns. Yet another reason to prefer SQL Server. There's a clear pattern here.

Sure, there are some advantages but we'd take portability over the possibility of having more than one auto-generated sequence any day.

It's interesting catching the impressions of an Oracle expert going the other way. Oracle to SQL Server: Crossing the Great Divide, Part 2. The comments in Part 1 make for a fun read. Especially those that bemoan the developer tools.

Kiva Loans

  • Blueberry Group

    Blueberry Group

    Home Energy

    Requested loan: $425

    Amount raised: $0

    Ha Khoabane, Thaba Bosiu, Maseru, Lesotho

    to purchase the ACE 1 energy system in order to have access to solar power for lighting, charging, and cooking in a way that is safer, cleaner, and saves money.

    Loan Now »

  • Carmelo Antonio

    Carmelo Antonio

    Agriculture

    Requested loan: $300

    Amount raised: $0

    San Andrés de Sotavento, Colombia

    to buy caña flecha, and fertilizers for yuca, corn and yam crops.

    Loan Now »

  • Umugisha B Tcb Group

    Umugisha B Tcb Group

    General Store

    Requested loan: $4075

    Amount raised: $0

    , Rwanda

    to buy more tomatoes, beans and rice to sell to meet customer demand.

    Loan Now »

To see more entrepreneurs »

Make a loan to an entrepreneur across the globe for as little as $25. Kiva is the world's first online lending platform connecting online lenders to entrepreneurs across the globe.