In Progress

Extracting MS CRM data to local SQL database

We have an old hosted MS CRM database that we want to extract and put on a local database. The work consists of extracting the data from MS CRM, set up a simple SQL database of sort and put the data into it.

Note that it's a hosted solution and we can only access the data from a web interface to the hosting partner. Would be interested to hear how you suggest to access/download the data.

According to this information it doesn't seem to be possible to download the whole database, whats your suggestion? By the way its ms crm 2011 online version. http://blogs.technet.com/b/lystavlen/archive/2012/11/16/comparing-crm-on-premises-to-crm-online.aspx

Skills: CRM, Database Administration, Dynamics, SQL

See more: Sql Database administration, crm 2013, simple hosted sql database, extract database data sql, simple sql extract, simple sql, crm sql, sql database extract, sort database sql, administration crm, sort sql, store serial port receive data ms sql database, sort data sql, extracting data, extract database ms sql, sql administration, simple sql database, data extracting, set data google map sql database, excwl sql database enter data, crm simple, extracting data xml file sql database, sql crm, database crm, crm database

About the Employer:
( 3 reviews ) Stockholm, Sweden

Project ID: #5009569

Awarded to:

kevinross100

Hi, It is possible to get the data from an online CRM instance but you are right that you can't go straight to the database and get it. I can rip the data out into normal SQL tables by making the SQL tables by hand More

$27 USD / hour
(2 Reviews)
0.8

33 freelancers are bidding on average $21/hour for this job

technosystem

This extraction can be done through data scraping. Kindly accept my bid for your Database project and be assured of a high quality work with our highly experienced and dedicated developers. Thanks

$41 USD / hour
(2 Reviews)
6.5
qitsol

We are top dynamics crm team here. We have done alot dynamics crm projects, see few of them here. see our Microsoft business portfolio here. [url removed, login to view] Here Projects completed f More

$25 USD / hour
(30 Reviews)
5.7
H3Solutions

Hi, I am quality provider and I always ahead to solve the customer's problems with serious attitude and always tried to come up with easy,affordable and reliable solution. I am ready to work with you. This is my More

$21 USD / hour
(7 Reviews)
5.6
truongngocthanh

Dir Sir/Madam, I'm a Application developer and database developer too. I have build the ETL process to process ta in my company and used many transfer data like : SSIS, Kettle Pentaho Data Integration. So i'm sure c More

$16 USD / hour
(16 Reviews)
4.5
hcy0212

Hi Vozie, Since it is a hosted version of CRM 2011. You should be able to export it as Excel. Then import them into your SQL server. Depending how much data you have, it might take a while. Please also note there migh More

$22 USD / hour
(10 Reviews)
4.5
elboukharimu

Hi, I'm very interested helping you extracting your MS CRM data to the SQL server database, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my More

$20 USD / hour
(11 Reviews)
4.3
pnjadhav

I am a expert Database Architect. I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, AJAX, CSS, XML,DNS, IIS(A More

$30 USD / hour
(4 Reviews)
4.1
Prateekagra

Hi i have a good knowledge of sql and i can do the same tell me when we can discuss further and also i hve 7 years of experience

$22 USD / hour
(2 Reviews)
3.5
iteraresearch

Hello there, It's hard to tell you exact estimate at the moment. It may require some investigation there to understand what kind of data you need to extract. Also there are some ways to get your data http://so More

$22 USD / hour
(1 Review)
3.2
fm102

hi Vozie, I got an invitational for your project, i'm a CRM expert working for MS CRM for 7 years now, I had a question, did you speak with Microsoft about exporting the Database, i believe it is possible to tak More

$22 USD / hour
(5 Reviews)
3.1
ahetel

Hello, Microsoft CRM is already storing the data and metadata in 2 SQL Server databases (I'm talking about Microsoft Dynamics CRM 4.0). I did a migration in 2010 from Microsoft Dynamics (very old Microsoft CRM - tha More

$20 USD / hour
(7 Reviews)
2.9
qualifiedcoders

Hi, We have read your Requirements and would like to discuss further as we have done complex database design, processing as well as administration in over 150 projects in last 5 years. We have 5 database experts with More

$20 USD / hour
(0 Reviews)
0.0
webdonejob

Hello, I got lots of experiences in PHP , java, J2EE++,C#, Visual Basic knowledge and java, .Net,Python,Django, ASP.NET,ASP,SQL ,Crystal Reports,Microsoft Report ,MS SQL ,MY SQL ,Oracle. My EDUCATION is B.Sc. math ap More

$18 USD / hour
(0 Reviews)
0.0
sdredmond

I'll read data using CRM organization service and save it on local database. This way i can read upto 5000 record at a time for an entity and dump it on database. This approch is as good as user account access, hig More

$16 USD / hour
(0 Reviews)
0.0
dans28

Hello Sir, I would like to discuss your project. I have a few questions about it. Without knowing more information, if you can display the data via a browser then it can be "scraped" using Python. If the calls to the More

$22 USD / hour
(0 Reviews)
0.0
chandansqlexpert

Hi , I am a SQL Developer/DBA with qualification of MCA , Microsoft certified professional. I have 5 years of experience as Developer/ DBA in SQL server 2000/2005/2008/2012. In this role, I Develop SQL queries, table, More

$16 USD / hour
(0 Reviews)
0.0
prasanjeetd

I can help you sir.I am a professional developer of this CRM 2011. Customization of MS CRM 2011 26 Months expereince in Microsoft Technologies like ASP.Net, MVC, Linq, SSRS, Crystal Report , C# ,Ajax, WCF, SQL

$15 USD / hour
(0 Reviews)
0.0
dlogix

Hi, We are Microsoft Certified Professionals (MCP's) and Microsoft Certified Trainers (MCT) and having great experience in MS Dynamics CRM customization & development. Kinldy contact with I am very much intereste More

$27 USD / hour
(0 Reviews)
0.0
swarnavoroy

Dear Advertiser, I am having 7+ years work experience with data integration and data transferring. Along with that I am an expert with SQL DB. Based on the available MS CRM database, which the hosting provider More

$15 USD / hour
(0 Reviews)
0.0
egbgroup

We will use the CRM 2011 SDK and the web service API's to fetch the data from your hosting provider and create a SQL Server database. We'll take the backup of the database and deliver you this backup. We have signi More

$27 USD / hour
(0 Reviews)
0.0