On Fri, Jan 27, 2017 at 1:54 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
Can't you just do a FLOCK() and then SELECT * from Source into table c:\backup\Target ?
Well, sure. What happens if FLOCK fails because someone left their machine on all night?
And how do you grab all the indexes, including that new one you added last week?
And the free tables as well as the ones in the DBC.
And don't forget the captions and stored procedures in the DBC.
I mean, how hard can it be?
Selling utilities to programmers is hard, because they all COULD do it. And after a dozen revisions or so, including some teed-off customers, they will have ironed out most of the bugs.
Until the next one.
Or you could pay someone else to do it for you, mark it up and charge it to the customer.