Solved

How to populate a CDF DB from CSV file

Posted on 2011-03-11
3
457 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
  • 2
3 Comments
 
LVL 39

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 39

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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now