Paradox (v9) to SQL Server

Question

Paradox (v9) to SQL Server

Arenig (IS/IT--Management)

(OP)

16 Nov 06 07:29

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.

www.arenig.co.uk

Kliot (Programmer) · Answer 1 · 2006-11-22 19:06:06

I have heard that this can be a simple process, although I've yet to see it.

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

Arenig (IS/IT--Management) · Answer 2 · 2006-11-23 04:18:45

Hi Perrin,

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

Kliot (Programmer) · Answer 3 · 2006-11-23 13:55:41

Martin,

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

TonyMcGuire (Programmer) · Answer 4 · 2006-11-23 15:53:44

As to 'dusty' and 'morgue', the Community web forum is going strong, as is the newsgroups.

Web version: http://pnews.thedbcommunity.com/cgi-bin/dnewsweb.exe

Tony McGuire
http://www.wjcitycouncil.com
"It's not about having enough time; we have the rest of our lives. It's about priorities."

Arenig (IS/IT--Management) · Answer 5 · 2006-11-23 16:36:47

Thank you Tony, I wondered where everybody had gone..

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

Come Join Us!

Posting Guidelines

Jobs

Paradox (v9) to SQL Server