How to migrate clipper database to sql 2000

Question

How to migrate clipper database to sql 2000

visitor010

SSC Enthusiast

Points: 193
More actions
October 1, 2007 at 10:02 pm

#198684

Hi,help needed in migrating clipper to sql.what are the steps,things to know..thanks!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323504 More actions · Answer 1

from what i remember Clipper was just a Visual Foxpro, right? so it's simply a .DBF file you connect to using dts and import the whole thing:

Enterprise Manager, Select database...Right Click...All Tasks...Import Data.

select a foxpro driver,maybe maybe have to create a file dsn to point it at the dbf and click next 5 times.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Joe Clifford SSCrazy Eights Points: 8739 More actions · Answer 2

Clipper!, what version? Most likely you'll need a driver that supports old dBaseIII/IV files or Foxpro 2.6/2.8 files. Newer versions of Foxpro will read the old files natively but I don't know if the current ODBC drivers will go that far back.

Steve Jones - SSC Editor SSC Guru Points: 734444 More actions · Answer 3

Clipped should be Fox 2.x or dBase IV if I remember. I'd think that any DBase driver would read it.

Use the Import Wizard in SQL Enterprise Manager and try some of the Fox or dBase driver selections.

steve block SSCertifiable Points: 7698 More actions · Answer 4

If I remember correctly, Clipper was originally straight dBase III files (dbf) with their own souped up indexes (idx? instead of ndx). There may have been a version of Clipper that was dBase IV compatible. I have linked to old dBase III dbf files using MS-Access and been able to put the data out that way.

Steve

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 5

Man - it really throws me back to read the "old style" Clipper ads (believe it or not - Clipper is STILL BEING SOLD. CA sold it off to an outfit called GrafXsoftware).

Here's the ad with what sounds like the original feature list. Gotta love features like:

- has a Full graphical mode

- is fully mouse-compatible

- Protected mode

- Integration with Microsoft C (not Visual C, not C++, not C#....C)

let's just say...wow! 😛

Here's the link: http://www.grafxsoft.com/clipper.htm

Clipper was a DBase 3+ format dialect, so I don't think you need to worry too much. One thing you MIGHT acre to pay attention to is whether the date fields convert to the same values: some DBASE clones assumed 0 was a different date than 1/1/1900, just like Access used to, so you might need to run a "increment all of the converted date fields by some amount".

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?