Paradox - SQL server

[CleoMan]

In the near future my company is going to have to convert our program (developed in Paradox 9) into a exact copy in SQL server, for reasons I cannot get into right now..

I was just wondering if anyone has done this before and know of any shortcuts (ie: dont have to do the whole program from scratch in SQL server).

-Richard-

 

[CleoMan]

Oh, and another thing is , how is good is Paradox when using ASP, ie: Can a Paradox app be run over the internet using a central server with the application on the server?

 

[Langley]

I have not done this, but Dennis Santoro and Tony McGuire have have written good primers about Paradox Web Server and OCX. Here is a link to these and a number of other excellent Paradox pdf documents:

http://www.rdaworldwide.com/pdoxres.htm#Documents

Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[footpad]

Richard,

As far as converting your Paradox data to SQL Server data, you have several choices; for example, you might:

1) Export your Paradox data to comma-delimited text files and then use SQL Server's tools to import that data.

2) Use checkPlus queries to convert your Paradox .DB tables to dBASE .DBF tables and import those into SQL Server using its tools.

3) Create a BDE alias pointing to your SQL Server database and then use Tools | Utilities | Copy to copy your Paradox tables to SQL Server variants.

There are considerations with each approach. None is appropriate for all situations. When you get to that point, you might explore each and determine the most appropriate approach for your needs.

Hope this helps...

-- Lance

 

[CleoMan]

Thanks, for the advice Lance, al this will be happening in the near future so I thought I might as well find out as much as I can as soon as possible.