Re: Export import all after a crash

2017-10-23 Thread Arnaud de Montard via 4D_Tech
> Le 23 oct. 2017 à 14:34, Jeremy French via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Hi Arnaud, > > You can pause indexes during the SQL import with: Thanks Jeremy. I should have read more… -- Arnaud ** 4D

Re: Export import all after a crash

2017-10-23 Thread Jeremy French via 4D_Tech
Hi Arnaud, You can pause indexes during the SQL import with: Begin SQL ALTER DATABASE DISABLE INDEXES; ALTER DATABASE DISABLE CONSTRAINTS; End SQL and then after the import completes, restore indexes with: Begin SQL ALTER DATABASE ENABLE INDEXES; ALTER DATABASE

Re: Export import all after a crash

2017-10-23 Thread Arnaud de Montard via 4D_Tech
> Le 22 oct. 2017 à 23:17, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Or you could use in error call and simply skip the bad records. I would also > try opening I. C/S and use sql to fill a me empty data file you can use same > on error stuff. Finally I did like this:

Re: Export import all after a crash

2017-10-22 Thread Chuck Miller via 4D_Tech
Or you could use in error call and simply skip the bad records. I would also try opening I. C/S and use sql to fill a me empty data file you can use same on error stuff. Regards Chuck Sent from my iPhone > On Oct 22, 2017, at 1:20 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote:

Re: Export import all after a crash

2017-10-22 Thread Tim Nevels via 4D_Tech
On Oct 22, 2017, at 2:00 PM, Arnaud de Montard wrote: > Unbelievable but a customer of mine has always thought that any backup > solution was really too expensive. Predictable has occurred, crash, no > backup, only a damaged data. I think I'll never understand how people can > have such a

Re: Export import all after a crash

2017-10-22 Thread Pat Bensky via 4D_Tech
SQL EXPORT SELECTION will certainly be faster ... and simpler to write ... Pat On 22 October 2017 at 11:10, Arnaud de Montard via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Unbelievable but a customer of mine has always thought that any backup > solution was really too expensive. Predictable has

Export import all after a crash

2017-10-22 Thread Arnaud de Montard via 4D_Tech
Unbelievable but a customer of mine has always thought that any backup solution was really too expensive. Predictable has occurred, crash, no backup, only a damaged data. I think I'll never understand how people can have such a disregard for their own work (10 years of input, 4 users C/S).