bcp data for changing sort order

[Luvsql]

I have followed the TK "How to BCP Data Out and Back into a New Database (875179)" a few times and it seems to work great. However, when bcp'ng the data back in, I do notice some errors as it flashes by in the dos screen, however, NONE of the .err files show any size other than 0k. After logging into Great Plains, I do notice that some information is missing. I check the tables and they are empty. I checked the in and out bat files and those tables are exported, then imported, and its corresponding .err file is blank.

If the .err files do not show any errors, how can we ensure that ALL our data was successfully imported? If there are errors, such as primary key errors, how did the data get into the table to begin with, and wouldn't GP give users errors within the application if the data is corrupt? We run weekly db maintenance.

 

[Luvsql]

I used the script supplied by previous upgrade manuals to see the difference
in the number of records in each table:

Select name, rows from sysindexes
where indid in (0,1)
order by name

And the numbers are completely different! As well, on my new install of 7.5
on the new server, for some reason, some tables do not appear in the
sysindexes table (GL20000 for example).

Has anyone else actually had positive results with this procedure that MBS
is endorsing? Why would the GL20000 table not appear in the sysindexes on a
brand new installation?

 

[Luvsql]

I just bcp'd the GL30000 out again, the bcp'd in again (ie exported data from old, dropped table on new, bcp'd data in on new) and there is a difference. There is nothing in the GL30000.err file.

Before 1166397
After 1166548
That's a big difference if these 151 entries were large amounts. I have found many, many differences. Why does this not work?

Before After

RM30501 766446 RM30501 27907
RM40102 633558 RM40102 1
SOP10107 379345 SOP10107 11
SOP10104 257801 SOP10104 0
SOP40200 230403 SOP40200 44
RM00700 188551 RM00700 83
RM30401 123493 RM30401 0
POP10600 68098 POP10600 10231
RM30202 180702 RM30202 125587
POP40400 54610 POP40400 0
SOP10103 45814 SOP10103 0
RM00106 45504 RM00106 8
SOP40702 40779 SOP40702 0
POP40100 40639 POP40100 1
RM40101 31464 RM40101 1
RM10901 27474 RM10901 0
POP30360 67516 POP30360 41432
SOP10109 26083 SOP10109 1
POP30330 25992 POP30330 848
POP10306 20832 POP10306 0