Paradox (v9) to SQL Server
Paradox (v9) to SQL Server
(OP)
We're attempting to switch the back end of our large financial application over to SQL Server (2005).
I'm just at the experiment stage.
I have created a SQL table identical in structure to my paradox one. Yet when I attempt to attach a TCursor, I get either a GPF or Paradox closes instantly and disappears completely without warning. Wow! If it can't even do this much without exploding, then I'm in trouble
Any clues?
According to everything I've read, this should be a perfectly feasible project.
I'm just at the experiment stage.
I have created a SQL table identical in structure to my paradox one. Yet when I attempt to attach a TCursor, I get either a GPF or Paradox closes instantly and disappears completely without warning. Wow! If it can't even do this much without exploding, then I'm in trouble
Any clues?
According to everything I've read, this should be a perfectly feasible project.
RE: Paradox (v9) to SQL Server
I have a Paradox app that I am in the process of converting to Vb.net and Sql Server 2005 and I found what worked best for me was to do a 2 stage import into sql. I first imported the Paradox tables into Access, then imported the Access tables into Sql Server. Sql used to be able to import Paradox tables directly but Sql 2005 doesn't. I does however imports Access tables nicely. I found that Sql is very strict with field structures and RI where as Paradox and to some extend Access is fairly flexible, for example Paradox allows nulls in secondary key fields where as Sql doesn't. I found it also helped to remove the keys and RI from the tables before importing them and setting that up again under Sql Server.
Good Luck
Perrin
RE: Paradox (v9) to SQL Server
Thanks for your reply. It's like a morgue in this forum nowadays.
Anyway, have come a little further now.
1. Have written a paradox utility to create tables and then copy the data - bearing in mind all that you said above re no null keys etc. (I never use inbuilt RI)
2. I was just finishing that utility off when I discovered "fullConvert" and realised I'd been wasting my time. A great tool, does the job in a jiffy with little fuss. Here's the url. Download a trial.
http://www.spectralcore.com/index.php
And if you're in the UK the exchage rate is great at the moment - cheap as chips!
Cheers
Martin.
www.arenig.co.uk
RE: Paradox (v9) to SQL Server
It has gotten a little dusty around here, it's a shame because Paradox was a great program.
Thanks for the tip on fullConvert, I had been looking for a conversion program and I hadn't come across fullConvert. I just tried it and it looks great. Much easier than what I had been doing.
Perrin
RE: Paradox (v9) to SQL Server
As to 'dusty' and 'morgue', the Community web forum is going strong, as is the newsgroups.
Web version: ht
Tony McGuire
http://www.wjcitycouncil.com
"It's not about having enough time; we have the rest of our lives. It's about priorities."
RE: Paradox (v9) to SQL Server
Just so you know, switching over to SQL back-end will extend the life of my paradox system in the city of london by years. I love Paradox.
www.arenig.co.uk