Re: [htdig3-dev] how to import htdig files to MSSQL7.0


Subject: Re: [htdig3-dev] how to import htdig files to MSSQL7.0
From: James Tillman (jtillman@bigfoot.com)
Date: Tue Feb 15 2000 - 03:56:52 PST


> >I am trying to import into MSSQL7.0 (using the import wizard) the five
> >htdig files I generated from a run of htdig (downloaded a month or so
> >ago) on a web site. The 'wizard' doesn't seem to recognize the hgdig
> >file formats as acceptable for an import. Any ideas?
>
> That's because they're not SQL files. They're Berkeley DB files, and
> I doubt the "wizard" has a clue what that would be.
>

What Geoff says is true. Perl does have support built in to its DBI for both
database types, however, so if you know a little about perl and DBI, you could
easily create a pipeline script that does selects on the data in the BDB files
and runs "insert" sql statements to insert the data into SQL Server. I've not
used DBI to get BDB files before, and someone told me that the format for the
htdig files uses a newer verison of BDB than perl has built-in support for, but
I'd still give it a shot if you know Perl at all.

Jamie

------------------------------------
To unsubscribe from the htdig3-dev mailing list, send a message to
htdig3-dev-unsubscribe@htdig.org
You will receive a message to confirm this.



This archive was generated by hypermail 2b28 : Tue Feb 15 2000 - 09:15:46 PST