August 16, 2005 at 5:10 am
Hello,
does any one know how to convert the queries from dos based paradox to SQL.
If anyone knows somthing abt it pls do let me
thanks in advance
Pallavi
August 17, 2005 at 8:57 am
Wow paradox, haven't heard that in some time. Moving your data will be moderately easy, you will have some data type issues to resolve however. You should be ODBC into the database (you can in windows paradox, I don't remember if you can in dos based) Which will allow you to to use DTS to move all your data into SQL Server. If you cannot ODBC, you may need to use the Paradox Data Copy Utility to export flat files that you will need to create tables in SQL, then import that flat files into those tables. As far as your queries go, I think you will be out of luck converting them, you will need to re-construct them all together. Here is a good article on migrating paradox to interbase - which would be a very similiar conversion http://bdn.borland.com/article/interbase/paradox.pdf
August 17, 2005 at 12:47 pm
You should be able to print a 'graphical' representation of the query out of the DOS based paradox platform. In the scripting window you can import a defined query so that you can view it's representation that way.
However, if you've got a windows version of paradox, ie paradox 5 (older, closer to the dos version, 7 might work, I'm thinking that 9 will not) you should be able to open the query in that application and show the sql text for that query. The paradox sql syntax will not port directly to sql... it will take a little manual intervention, but not much. If the queries are at all complex paradox will not show you the sql text for that query.
Also worth noting: Paradox queries are not as 'powerful' as sql queries. You will find, for the most part, that if the query is at all complex or if you are converting an application where several queries are run one after the other to attain a specific result that you will be better off documenting the objective and redesigning the whole thing on the sql server. With a more powerful tool you have the opportunity to streamline and take a few bends out of the road.
Good luck and have fun!
b
August 17, 2005 at 12:50 pm
flash! one more thing. It's been a while... but I think that you can open the qbe file in notepad and see something that can be easily interpretted... I might be having some 'wishful' flash-backs... but I believe that that is the case.
b
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply