Search code examples
sql-serverdelphidelphi-2010dbexpress

dbGo or dbExpress for Delphi 2010 with Microsoft SQL Server

I am migrating to Delphi 2010 and I am using Microsoft SQL 2000 (Planning on upgrading to SQL2008). I have been using BDE all along and wondering if I should use dbGo (ADO) or dbExpress with my future application. Can someone explain to me the pros and cons for using either one?

Thanks a lot.

Solution

  • For performance reason and future development I will go with dbExpress.

    dbExpress has been pushed up since latest version, but dbGo didn't changed since Delphi 5 or 6, and it's include just few fixing with each version, while dbExpress has been getting more improvment with each versions specially in last few releases.

    another options is to use SDAC from DevArt, it's has the best performance and has more advanced features for Sql server compared to other technologies.