I can tell you from years of hard experience: There is NO SUCH THING as a clean transfer. Anyone who tells you that is a blatant liar.

1. It is unreasonable to think that two different softwares from two different companies written by two different development teams will have the exact same features.

2. It is unreasonable to think that two different softwares from two different companies written by two different development teams will have implemented their similar features the same way.

3. It is entirely possible that one vendor uses a very well known as easily useable database, such as SQL Server, while the other vendor uses a less well known and very finicky database such as DBISAM or Postgres. Or both vendors will use less well known databases.

Best bet is to do a test run of any data conversion, work out the bugs, then schedule a REASONABLE go-live date for a final conversion then move to production.

JamesNT


James Summerlin
My personal site: http://www.dataintegrationsolutions.net
james@dataintegrationsolutions.net