Hi Peter, > A customer who is using an application of ours, written in D6 using > BDE/Paradox wants me to investigate the posibility and cost to migrate to MS > SQL Server, with minimal effort.
With minimal effort? Then you should probably look at the dbGo for ADO components, which work very similar (i.e. connected) compared to the BDE. If you want to migrate to the "latest and greatest" data access technology from CodeGear, you should look at dbExpress - or DBX4 as it's called in Delphi 2007 - and use that to work with SQL Server. However, dbExpress uses a disconnected model to work with your data, which requires quite some work to migrate your data modules and forms to... See http://www.drbob42.com/examines/examin91.htm for my latest article on DBX4. See http://gethelp.devx.com/techtips/delphi_pro/10min/10min0701/10min0701-1.asp for an article about how to update and maintain dbExpress's Unidirectional Read-ONly Datasets. Also, see my BorCon Conference papers about dbExpress and ClientDataSets at http://bdn1.borland.com/article/borcon/files/2106/paper/2106.html for example. > Peter Laman Groetjes, Bob Swart PS: I'm currently finishing the courseware for my Delphi 2007 Database Development training, covering migration from the BDE to DBX4 as well. See http://www.eBob42.com/training for more details ;-) -- Bob Swart Training & Consultancy (eBob42.com) Forever Loyal to Delphi Blog: http://www.drbob42.com/blog - RSS: http://drbob42.com/weblog.xml Delphi 2006 Courseware PDF manuals at http://www.eBob42.com/courseware __________________________________________________ Delphi-Talk mailing list -> Delphi-Talk@elists.org http://www.elists.org/mailman/listinfo/delphi-talk
