Data Migration from SQL Server to CRM Dynamics Best practics

(0) Share

Report

Posted on by Community Member

Hi Friends,

I am doing the data migration project,I am pulling the data from SQL Server for periodically based. what is the best practices for Migration from SQL Server.

Do I need to write Stored Procedure,Views or Directly pull the data.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

hellosuresh 539 on at

Like (0)

Report

If your company is ready to go with third party tool like Scribe etc or you can use SSIS.

So that you can implement your own business rules, data sanity etc.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Suresh,

Yes we do have scribe in our company need to pull records continously

Was this reply helpful? Yes No
hellosuresh 539 on at

Like (0)

Report

Hi AyeshaKhan,

Use the following guide to use Scribe to push the data in CRM.

Ref: www.scribesoft.com/.../ScribeInsightTutorial.pdf

Was this reply helpful? Yes No
Inogic 682 on at

Like (0)

Report

Hi Ayesha,

You can use the third party tools like Scribe or KingswaySoft SSIS Toolkits to migrate data from SQL database to Dynamics CRM.

Hope this helps.

Thanks!
Sam

Was this reply helpful? Yes No
Schlitzer G. on at

Like (0)

Report

Hello guys, Can we discuss better the best solution in order to managing the syncronization from the CRM 2016 Online and the local data management system?

At the momenth waht do you think about the process? What kind of data must be syncronized and what is the best way in order to approach the problems?

Was this reply helpful? Yes No
Suggested answer

JohnAnonymous 5,241 on at

Like (0)

Report

I don't think there's a clear preference in to choose between a Stored Procedure, View or a query. It's probably best to do what your company is used to.

One choice might be to use a view or stored proc over a direct query, is where you want to mange your query, on SQL server or in the consuming tool, and what options the consuming tools has. E.g. stored procs with a select statement aren't always fully supported as far as I know.

Security to the data might be a reason as well.

It all depends on why you are asking your question.

Was this reply helpful? Yes No
Schlitzer G. on at

Like (0)

Report

My question rise beacuse we are a software house and Microsoft patner and our customers required to fully integrate the CRM to the local ERP or other applications.

For this reason I'm searching a best way to approach the problem both for the process point of view or for the solution tool.

Could be an interesting idea to discuss the different approaches used.

Was this reply helpful? Yes No