Command Line "Statistics" or "Advanced Statistics"

Forum for DBF Commander discussing.

Command Line "Statistics" or "Advanced Statistics"

Postby rgusick » Fri Jan 18, 2019 10:42 pm

I've inherited a legacy system with hundreds of DBF files scattered throughout the filesystem with little to no documentation (or source code). I ultimately plan on migrating the data to SQL Server, but first I need to know what/where data I have.

Is there a way to generate the output from "Statistics" or "Advanced Statistics" from the command line so that I can script something to give me some insight into what is out there?

Thanks in advance,
Robert
rgusick
 
Posts: 2
Joined: Fri Jan 18, 2019 10:30 pm

Re: Command Line "Statistics" or "Advanced Statistics"

Postby Admin » Sat Jan 19, 2019 9:10 pm

Hi Robert,
you can use an SQL query in batch mode to extract the data you need. More info is available here.
Best regards,
Oleg Zhechkov
User avatar
Admin
Site Admin
 
Posts: 113
Joined: Wed Apr 21, 2010 7:27 pm

Re: Command Line "Statistics" or "Advanced Statistics"

Postby rgusick » Tue Jan 22, 2019 7:24 pm

I'm confused. If all I have is hundreds of DBF files that I don't know anything about, what query can I run to just get the column names? Even a "SELECT TOP 1 ...." required an "ORDER BY", but I don't know in advance any columns to sort on!
rgusick
 
Posts: 2
Joined: Fri Jan 18, 2019 10:30 pm

Re: Command Line "Statistics" or "Advanced Statistics"

Postby Admin » Tue Jan 22, 2019 10:04 pm

What data you need to get from these files?
The field list is only available through the 'File Structure' dialog in GUI.
Best regards,
Oleg Zhechkov
User avatar
Admin
Site Admin
 
Posts: 113
Joined: Wed Apr 21, 2010 7:27 pm


Return to DBF Commander Professional

Who is online

Users browsing this forum: No registered users and 3 guests

cron