Hello,
I'm looking for a sanity check on the amount of time it takes to import data from SQL staging tables to CRM.
We are creating staging tables to help move data from a legacy system to CRM. Our implementation vendor is taking the staging tables and then using scribe to import data into CRM.
We ran a test and imported 2.8 million record with 6 columns into Contacts and it took 75 hours. At that rate it will take us 3 weeks to import the data.
Our legacy system is old and we are creating keys in the staging tables to keep records connected. Therefore we're trying to import all the records at once, vs batches.
Any suggestions on the best way to import data?
Thanks,
Andrew
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Calibri; color: #1f497d} span.s1 {font-kerning: none} </style>