I did that about 10 years ago. I kept the bde components, and changed the Database component properties to use an odbc connection. I can't recall much about it now, but it was fairly painless. It has been working well for 10 years...
If your requirements are not too step, that is the way to go. It's not pretty or elegant, but it works. The way auto numbering works is different, and I think some field types are different. Also obdc has some weird issues if you open two queries at the same time, in some circumstances. Basically the bde doesn't always fetch all the records at once, but obdc can only handle one open statement at a time so you get a weird error message. I resolved that with judicious use of query.FetchAll, (or Close) and with multiple Database components. I am now in the process of transitioning to Corelabs Sdac which operated very similar to the BDE in terms of properties so it is a fairly simple proposition. I previously tried using dbGo/AdoExpress, and that also works but sdac is better and an easier change. Don't go to DB Express unless you have a lot of spare time. Regards Sean Cross IT Systems Development Manager Catalyst Risk Management PO Box 230 50 Dalton St Napier 4140 DDI: 06-8340362 mobile: 021 270 3466 Visit us at http://www.catalystrisk.co.nz/ Offices in Auckland, Napier, Wellington & Christchurch Disclaimer: "The information contained in this document is confidential to the addressee(s) and may be legally privileged. Any view or opinions expressed are those of the author and may not be those of Catalyst Risk Management. No guarantee or representation is made that this communication is free of errors, viruses or interference. If you have received this e-mail message in error please delete it and notify me. Thank you." > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:delphi-talk- > [EMAIL PROTECTED] On Behalf Of Peter Laman > Sent: Monday, 6 August 2007 7:44 p.m. > To: Delphi talk > Subject: //Porting Paradox to MS SQL Server > > Hello, > > 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. I am new to MS SQL Server - I just > downloaded the 180 day trial edition of the 2005 version. My first idea > is > to simply port the database and then change the BDE alias to using SQL > Server through ODBC and then see how far I get. Of course I don't > expect it > to be that easy - I've been in programming long enough not to be that > naive, > so my question is to those who have done something similar: what > misfortune > can I expect; do you have any hints; what are the pitfalls, and so on. > > Any experience shared is appreciated. > > Thankx, > > Peter Laman > ---------------------------------- > The Lance Group, > software to promote plant safety in the Process Industry > drs. Peter laman > Web: <http://www.lance-safety.com> http://www.lance-safety.com > ---------------------------------- > Computers don't do what you want; they do what you tell them to do! > __________________________________________________ > Delphi-Talk mailing list -> Delphi-Talk@elists.org > http://www.elists.org/mailman/listinfo/delphi-talk __________________________________________________ Delphi-Talk mailing list -> Delphi-Talk@elists.org http://www.elists.org/mailman/listinfo/delphi-talk
