We are doing a conversion with our old data from paradox and DBF to Advantage Database using Delphi. SIMPLY (ha) add a adsconnection, then add an adstable object names for the existing table + an underscore set the new table properties to match the old table properties delete old table rename new table. Advantage comes with a utility called Arc. This as a function to create adt tables from Pradox or DBF. They all so have utilities on there web site to aid with this job.
A free local server with all this stuff is available on there web site. Bob Pointon "Peter Laman" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/08/2007 08:44 Please respond to Delphi-Talk Discussion List <delphi-talk@elists.org> To "Delphi talk" <delphi-talk@elists.org> cc 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
*********************************************************************** NOTICE: This e-mail transmission, and any documents, files or previous e-mail messages attached to it, may contain confidential or privileged information. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of any of the information contained in or attached to this message is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify the sender and delete the e-mail and attached documents. Thank you. ***********************************************************************
__________________________________________________ Delphi-Talk mailing list -> Delphi-Talk@elists.org http://www.elists.org/mailman/listinfo/delphi-talk
