SQL Server Performance Forum – Threads Archive

Con verting Paradox Queries to SQL

Hi
I am looking for some information abt how to convert dosbased paradox queries into SQL.
I have already tried, converting this scripts or dos based queries into query files for paradox9.0, It shows the SQL script for simple queries, but for the queries with joins the SQL script is not shown
Does any one have any idea where i can get more information abt it
thanks in advance
Pallavi

May try this<a target="_blank" href=http://www.ozgrid.com/Services/paradox-converter.htm>http://www.ozgrid.com/Services/paradox-converter.htm</a> link for further information. Otherwise google is your best friend [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]. <hr noshade size="1">Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center>

Hi satya Thanks for that link, but what i want is not there on the site. It is for some converting software. Actually the prolem is that, the old database is in Paradox, and now i have to convert it into SQL. Their all scripts are written in paradox, which i have to transform into SQL stored procedures. Many of those queries, i have converted, but some of them i wa not able to understand Thats why i wanted some inofrmation abt how to write queries in dos based paradox,
I tried to search on Google, but there I got the infomation abt ‘Writing queries in paradox 9’ which i dont want If u have any idea abt this, pls do let me know Thanks
Pallavi

I don’t know about Paradox so I cannot comment on them, by using google I was able to findout links about Paradox forums below:
http://forum.paradoxplaza.com/forum/
http://www.tek-tips.com/threadminder.cfm?pid=177
http://www.answers.com/topic/paradox-interactive May try your luck over there.
HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks Just now I got mail from client explaining all those scripts.
So now I dont have to worry abt the conversion stuff. any ways thanks for those links Pallavi

]]>