Replication from SQL to NATIVE ?

Shortcuts

Navision Articles

Latest Navision / Dynamics NAV Developer FAQ Updates

View all FAQ pages

Most Viewed Navision Forum Posts

Latest Navision / Dynamics NAV Documentation

View more Dynamics NAV / Navision Documentation

Latest Navision / Dynamics NAV Downloads

View more Dynamics NAV / Navision Downloads

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Solution (Verified) This post has 7 verified solutions | 7 Replies | 2 Followers

Suggest a Solution
Not Ranked
12 Posts
745 Points
Joined: Mar 3, 2009
Last Online:
Jul 20, 2009 11:38
Location: Germany
Florian posted on May 11, 2009 13:51
How helpful was this post/question? Please rate here:

Hi!

I have one short (I hope :-) ) question. We are going up from a native to a SQL Server with our database this summer. Actually we are working with replicator 4.22 in the native database. 

=> When we start working with SQL Server it`s not possible to go back to native (if there where some errors, etc.). Because of this we have one, perhaps crazy idea to be on a safer side the first weeks: When we work with sql we still keep the replicator running and replicate the values to our native database (backup server). This means in simple words: Make replication from sql database dynamics nav to native database dynamics nav. Is it possible? :-)

Thanks for your help!

Best Regards from Germany, bavaria!

Florian

Solution (Verified) Verified Solution

Top 10 Contributor
Male
6,078 Posts
55,943 Points
Joined: Apr 12, 2001
Last Online:
Mar 15, 2010 23:40
Location: Prague, Czech Republic
DynamicsNAVMVP
Moderator
SystemAdministrator
Reply
Solution (Verified) David Singleton replied on May 11, 2009 14:25
How helpful was this comment/solution? Please rate here:
Verified by Florian

Why?

David Singleton - MVP Dynamics NAV Dynamics NAV Consultant since 1991 Available for Navision Go-Live assistance
Dynamics Book

Not Ranked
12 Posts
745 Points
Joined: Mar 3, 2009
Last Online:
Jul 20, 2009 11:38
Location: Germany
Reply
Solution (Verified) Florian replied on May 11, 2009 14:27
How helpful was this comment/solution? Please rate here:
Verified by Florian

Hi David, Thanks for your reply!

The Problem is that our database is over 300GB and to make a restore this takes too long. So for example we have the worstcase on tuesday afternoon for me it`s not possible to make the restore till the next day :-(

You know what i mean?

Thanks, David!
Regards,
Florian

Top 25 Contributor
Male
1,020 Posts
21,649 Points
Joined: Dec 6, 2005
Last Online:
Mar 8, 2010 17:24
Location: Riga, Latvia, EU
Moderator
Reply
Solution (Verified) Modris Ivans replied on May 11, 2009 15:31
How helpful was this comment/solution? Please rate here:
Verified by Florian

Florian:
So for example we have the worstcase on tuesday afternoon

What do you mean by "worsst case" ? If you only move to SQL, not doing any mods/changes at the same time, there should not be any problems arising simply from the change of database. Since you get the SQL DB up & running (user logins created & tested etc), there is no reason for trouble afterwards.

Modris Ivans
MCP-Dynamics NAV Application

Please specify in your posts
1.product and DB version;
2.locale, or use International Forums

"Verify Solution" to post that helped you solve your problem

Not Ranked
12 Posts
745 Points
Joined: Mar 3, 2009
Last Online:
Jul 20, 2009 11:38
Location: Germany
Reply
Solution (Verified) Florian replied on May 11, 2009 15:48
How helpful was this comment/solution? Please rate here:
Verified by Florian

With worstcase i mean that perhaps something in our big system is not working correctly, statistics and we need a very fast solution. We have made many many changes in the code. And the code can be interpret in different ways between native and sql.

Thanks :-)

Top 25 Contributor
Male
1,020 Posts
21,649 Points
Joined: Dec 6, 2005
Last Online:
Mar 8, 2010 17:24
Location: Riga, Latvia, EU
Moderator
Reply
Solution (Verified) Modris Ivans replied on May 11, 2009 16:31
How helpful was this comment/solution? Please rate here:
Verified by Florian

Florian:
And the code can be interpret in different ways between native and sql

NEVER...

You don't need to worry about this part - once more, simple change of DB would not cause problems in program logics.

Differences in productivity may arise, you may need to optimize SQL indexes etc etc. but NAV business logics doesn't depend from DB used...

Modris Ivans
MCP-Dynamics NAV Application

Please specify in your posts
1.product and DB version;
2.locale, or use International Forums

"Verify Solution" to post that helped you solve your problem

Not Ranked
12 Posts
745 Points
Joined: Mar 3, 2009
Last Online:
Jul 20, 2009 11:38
Location: Germany
Reply
Solution (Verified) Florian replied on May 12, 2009 8:43
How helpful was this comment/solution? Please rate here:
Verified by Florian

Hi guys,

followed the information about the problem from the solution center:

"Yes you can replicate SQL based Navision with Native. If you are using update-add-delete specs running sequential read=source+dest.you may however run into some errors because sql and native returns records in different order. We have tried to minimize this issue by using a new lookup function implemented in repnt.exe v 4.22.15. (Included in the 4.22.20 version available in the download section."

Regards,
Florian

Not Ranked
12 Posts
745 Points
Joined: Mar 3, 2009
Last Online:
Jul 20, 2009 11:38
Location: Germany
Reply
Solution (Verified) Florian replied on May 12, 2009 10:32
How helpful was this comment/solution? Please rate here:
Verified by Florian

Hi guys,

followed the information about the problem from the solution center:

"Yes you can replicate SQL based Navision with Native. If you are using update-add-delete specs running sequential read=source+dest.you may however run into some errors because sql and native returns records in different order. We have tried to minimize this issue by using a new lookup function implemented in repnt.exe v 4.22.15. (Included in the 4.22.20 version available in the download section."

Regards,
Florian

 

Page 1 of 1 (8 items) | Get this RSS feed | Bookmark and Share