Solved

How to populate a CDF DB from CSV file

Posted on 2011-03-11
3
478 Views
Last Modified: 2012-06-27
I have to migrate from Salesforce to CRM 3.0.
I have exports all the data from Saleforce and can modify to do Bulk import. But many people talk about first exporting to a CDF db then importing to CRM 3.0
I have downloaded the CRM migration pack and have CDF DB but how can i import the CSV files into the CDF?

Many thanks
0
Comment
Question by:Rbauckham69
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 35109400
One way would be to use SQL Server SSIS or from SQL SSMS start for instance a "Import Data" task that will pop up a pretty easy to use wizzard where you select your connections/tables for source and target.
0
 

Author Comment

by:Rbauckham69
ID: 35110823
CAn you explain the SSMS Import data task a bit more can't see in SSMS?

Many Thanks
0
 
LVL 40

Expert Comment

by:lcohan
ID: 36918448
"In SQL Server Management Studio, connect to the Database Engine server type, expand Databases, right-click a database, point to Tasks, and then click Import Data or Export data."

http://msdn.microsoft.com/en-us/library/ms140052(v=SQL.90).aspx

And here are more details and screenshots:

http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm

http://msdn.microsoft.com/en-us/library/ms141209(v=SQL.90).aspx
http://msdn.microsoft.com/en-us/library/ms140052.aspx
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Desired Skill Set for Microsoft Dynamics CRM Technical Resources ā€“ Part II
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE sā€¦

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question