Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Sage 100 2020 Upgrade with SQL Database from 2018 Provide X Database

Posted By May Baqai over 3 years ago

Curious if anyone knows when we are moving our data from Sage 2018 ProvideX Database to Sage 2020 SQL Database for some reason unknown 3 customers didn't carry over. We use Mapadoc and one of them customers is using that. Any ideas on what would cause this or on how to resolve this. IF anyone has experienced similar.

Top Replies

mhainesalt over 3 years ago +1

I have noticed on some occasions that Mapadoc would sometimes write field values to data in Providex that was bigger than the field size and perhaps SQL will not allow those records to import?

Kevin M over 3 years ago

Look at the conversion logs for errors. Did you run Rebuild Key Files before the migration?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
May Baqai over 3 years ago in reply to Kevin M

Tried that as well.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
mhainesalt over 3 years ago

I have noticed on some occasions that Mapadoc would sometimes write field values to data in Providex that was bigger than the field size and perhaps SQL will not allow those records to import?
Cancel
Vote Up +1 Vote Down

Sign in to reply

Cancel

Sage 100

Sage 100 2020 Upgrade with SQL Database from 2018 Provide X Database

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING