Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DanT
Starting Member
3 Posts |
 Posted - 2007-02-10 : 18:58:15
|
| Hello All, I know nothing. I am helping a friend, current database Paradox 7.x, custom app as I am sure they all are. I wanted to convert this DB to SQL or Access(MS)I do not have Access, but I have SQL 2000. I used the import/ convert tools within SQL, looked good to me, no errors etc. I thought life was good. Now try to view, look at the data the wayusers could. In the SQL manager, I can see tables, and stored procs, and lotsa cool stuff. I try and install SQL client on a PC to view. It basically extends the Admin tools to the deskop PC. How do I use an SQL conversion to realize the needs of the user interface. I think I need what is called a front end. You can stop laughing now..... Anyway what direction should I taketo update this antique, no support Paradox DB. Thanks, Dan T |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-02-10 : 19:52:45
|
| SQL Server is a database engine and that is all. It does not directly address the development of the user interface, so you will have to use some other tool for that.There are many tools available that can access data in a SQL Server database, including Access, the languages in the Visual Studio suite, and many, many others.CODO ERGO SUM |
 |
|
|
DanT
Starting Member
3 Posts |
Posted - 2007-02-10 : 20:54:22
|
| Thank you Michael, I kinda figured that. What about the Paradox views, Front end etcthat exist ? Can this be ported? Are these some of what stored procs are that I see listed, or is all lost. Thanks, Dan T |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-11 : 03:22:48
|
| "stored procs"I would be surprised if any of the Paradox "logic" was converted to Stored Procedures - so I guess you are only seeing the "system" Sprocs."Paradox .. Front end ... Can this be ported?"Start again (or find a more modern version of Paradox that supports having the data in a SQL database - I'm pretty sure that was possibly as much as 6 or 7 years ago)You can obviously use the existing source code to re-factor, and there may be converters out there that will migrate it to something else - I would look for some ObjectPAL forums and ask there.Kristen |
|
|
|
DanT
Starting Member
3 Posts |
Posted - 2007-02-19 : 20:04:56
|
| Kristen and Michael, Thank you so much. I want to learn more of SQL I only did some admin and Sybase to MS convert repair, but am a good student (at times).I will look into and try what you said, Thanks for all the help! Dan T |
|
|
|
|
|
|
|
|
Paradox Conversion - Front End View