Delphi to SQL Server

[ihatemash]

I currently have a Delphi 5 app that uses twwTable components to connect to paradox tables. I need to convert to SQL Server on Windows 2000 PRO using query components. What issues am I going to encounter in doing so? Are there any special server setting necessary? Any suggestions would be very appreciated.

Regards,
-scott

 

[petertickler]

It's a fairly broad question, but there should not be much trouble in doing this. I suppose the main issue is how you are going to connect to the SQL Server Database - using BDE or ADO. I would strongly suggest using ADO connections and ADOQuery components, as this is the way things are going (and ADO is definitely better in you are developing web apps). Other important issues are making sure you index your SQL Server tables sensibly. In any case, performance should be much better with SQL Server than Paradox!

 

[CScorup]

Yes, ADO is the way to go. If you are using Enterprise, it's included. If you are using Professional, there is an extra cost to get dbGo (formerly ADO Express). Also, although I don't have it yet, I understand that dbExpress in Delphi 7 has a native SQL driver. As usual, be prepared for some learning . . .

 

[delphiman]

There are many reasons why you should (like me) use
Interbase 6. Starting with the fact that it is used by Ericson, The Dept of "Defense" (USA obviousely - they can't spell "defence" LOL), numerous stock exchanges and home-banking environments.

Added to which it does NOT have "pessimistic locking" (so that more than one user CAN access the same record) - and it's free!

 

[svanels]

The following link talks about upscaling from access to SQL-server, but I think the discussions about table design and queries are relevant since access and paradox are in the same category of desktop databases.

http://databases.about.com/gi/dynam...tp://www.blueclaw-db.com/microsoft_access.htm

Regards Steven van Els
SAvanEls@cq-link.sr

 

[petertickler]

With all due respect to Delphiman, I would argue that there is no need to move to Interbase in order to avoid locking problems. SQL Server is very adequate for a multi-user environment, and it is also very easy to use. We use it for all our core databases, all of which are shared by a number of users. You can also be sure that SQL Server will be around for a long time to come.

Peter Tickler

 

[LucieLastic]

I used SQL Server 7 for our aviation database, which had about 30 users on it simultaneously(not a huge number but it coped v. well). I like SQL Server and found it pretty fast. SQL Enterprise was also easy to use (seeing that I hadn't had any training).

I also thought the diagramming extremely useful, I just wish Sybase had incorporated the same in Sybase Central (unless I just haven't found it yet).

If you need any help setting anything up or querying etc, the SQL server forum on Tek-Tips is excellent.

lou

 

[edwinj]

if u r going for BDE (I wanted to Go for ADO but Delphi 6 doesnt have it for SQL Server .. Wat a Shame)

Make Sure you Change your TTable Components to TQuery
(or else is acts strange and your program will hang)

I Guess you have to almost rewrite da whole application like i did.

Best of Luck