Re: Creating a copy of a database -- best practice?

2019-03-06 Thread mbsoftwaresolutions

On 2019-03-04 17:52, Fletcher Johnson wrote:

Mike,

I am assuming that the backup has to happen while the tables are in use 
(or

you would just copy over the data folder via windows.)
\
Creating the DBC programmatically should be easy (I seem to remember 
there
is an option in VFP that generates the code to do so - which includes 
all

the rules, RI, structures, etc. )  Just no data.  You could use this to
create a destination with no data and then append the source data to 
the

empty backup tables.

This would create a very clean, packed, set of data.

Of course, it's not that simple if anyone is using it at the time.

You probably want to lock the source tables (and related) before 
appending.
Or if you have a last modified record in the tables, use that to check 
for
any changes since the data was copied.  Or you might use cursors/views 
so
that changes made by others don't affect you while copying.  In fact, 
if you
use a view or have buffering on, once the append is complete, you can 
check

for changes.

Anyway, I am sure you will find something that works best for you,



Yeah, needs to happen while folks are still in it.  I think GENDBC was 
the utility you were thinking of.  This is all a moot point though; I'm 
gonna recommend Frank Perez and Rick Schummer's CleverFox Backup.  It's 
the bomb.  ;-)


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/c0c28941de25379e6f996ed2a0974...@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: A FoxPro job in NJ!

2019-03-06 Thread Kurt at VR-FX

I believe it was on Indeed.com website.

On 3/6/2019 6:53 AM, Eric Selje wrote:

Where's that posted? I know a guy looking for a job. (Not in NJ however)

On Sat, Mar 2, 2019 at 3:21 PM Kurt at VR-FX  wrote:


Its posted via - I think its a Recruiter firm - United SW Group. Pretty
damn stupid generic name. But, co. is in NJ. Its supposed support/maint
of a legacy FP Ins. app.!! Was curious if this rings a bell w/anyone
here. It claims no work from home option - but, I figured, why not see
if I can get them to change their minds on that one...

-K-



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/fbcdb649-7130-45db-db6c-0fa3feb80...@optonline.net
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: A FoxPro job in NJ!

2019-03-06 Thread Eric Selje
Where's that posted? I know a guy looking for a job. (Not in NJ however)

On Sat, Mar 2, 2019 at 3:21 PM Kurt at VR-FX  wrote:

> Its posted via - I think its a Recruiter firm - United SW Group. Pretty
> damn stupid generic name. But, co. is in NJ. Its supposed support/maint
> of a legacy FP Ins. app.!! Was curious if this rings a bell w/anyone
> here. It claims no work from home option - but, I figured, why not see
> if I can get them to change their minds on that one...
>
> -K-
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAAwxvU=oPnb+=ncBFfO3zHxOKRjPJJY2RwhwD5u=9chpgti...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.