When I designed my database, it was the first I had ever built and my knowledge was practically none. I designed it for use by around 20 people and to hold approximately 20,000 records. Be it a blessing or a curse, the demand for the usage of this database has grown inconceivably quickly. I now have 100 users (around 50 at a time) and hold over .5 million records. This number grows by approximately 20,000 ever day.
In light of this, I have redesigned everything. I started with my tables and have completed this. I am now trying to append the information in the original tables to the new ones. Everything operates well, except that nearly 400,000 records don't append due to validation rule violations. How can I find what exactly is not validating correctly?
Please help!