Solved

How to populate a CDF DB from CSV file

Posted on 2011-03-11
3
459 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

948 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

23 Experts available now in Live!

Get 1:1 Help Now