Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
platinumvalley
Starting Member
2 Posts |
 Posted - 2008-11-08 : 15:35:06
|
| hello everyone,since I am very new to sql i thought that the best thing to do is to ask the best ;-)I ve got approx 1000 contact/company records in my business contact manager for ms outlook 2007. The database hasn't got sufficient functionality. So i decided to go for Goldmine 8.0.2 (FrontRange). I have both applications installed on my computer now.Both databases have SQL Server 2005 engine. The structure of both databases is different even though they hold similar business data (contact and company names with contact numbers etc.).How do i selectively migrate the data from bcm to goldmine? (i would like to transfer ALL of the bcm data into RELEVANT corresponding fields in goldmine).Can i do it myself?Alternatively does anyone offer this type of service? Thank you. DK. |
|
|
brianjensen
Starting Member
22 Posts |
Posted - 2008-11-09 : 04:25:48
|
| Aren't there any 'export to file' and 'import from file' functionality in the two programs?Doing it manually sounds a bit error prone to me.But if you want to do it manually, you will have to make sure that the data types for the common rows are the same. Else you will have to do some data conversion as you copy tables from one database to the other. |
 |
|
|
platinumvalley
Starting Member
2 Posts |
Posted - 2008-11-10 : 16:10:05
|
| There is an 'Import from Outlook' facility but very inaccurate. Data gets misplaced and omitted.Furthermore, every account is linked to related contacts. Contacts are linked to logs and opportunities.The standard facility does not copy data at every level of relationship.Rather then manually, i would like to do it automatically by mapping fields from the old system onto the fields in the new system. Something like a program that would do the whole thing at a press of a button.Thank you. |
|
|
|
|
|
|
Data Migration from Outlook BCM to Goldmine