Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to populate a CDF DB from CSV file

Posted on 2011-03-11
3
Medium Priority
?
489 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 40

Accepted Solution

by:
lcohan earned 2000 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
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.

926 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