معلومات مفيدة لمن يريد عمل replication one way

[download2m]

ربما يكون لدى شركتك أكثر من فرع فهناك مكان يتم عن طريقة أدخال الحركات و هناك مكان أخر سوف يقوم المديرين فقط منة بالأطلاع على التقارير أو الأدخالات و ذلك دون القيام بعمل أية أدخالات او تعديلات ولذلك سوف تجد فى هذه ال knowledge base وصف لبعض الخطوات التى يجب أن تراعيها:
https://mbs.microsoft.com/knowledgeb...b;en-us;926490

--------------------------------------------------------------------------------

On This Page
INTRODUCTION
MORE INFORMATION
Replication
Clustering
Log shipping and database mirroring
APPLIES TO
HOTFIX DOWNLOAD

INTRODUCTION
This article describes the requirements to run replication, clustering, log shipping, and database mirroring together with the following products:• Microsoft Dynamics GP 10.0
• Microsoft Dynamics GP 9.0
• Microsoft Business Solutions - Great Plains 8.0
• Microsoft Business Solutions - Great Plains 7.5

Back to the top

MORE INFORMATION
Replication
• The snapshot and the transactional replication are the only two types of replication that can be implemented together with Microsoft Dynamics GP.
• Microsoft Dynamics GP requires one-way replication. Two-way replication cannot be implemented together with Microsoft Dynamics GP because the Setup tables retain the next Document Number value when you create accounting transactions.
• Replication can be configured together with Microsoft Dynamics GP databases if you follow the following rules: • When you select a table for replication, disable the option to add a unique identifier to the table. Otherwise, the table structure is modified. The modification of the table structure causes problems in Microsoft Dynamics GP.

Note Most Microsoft Dynamics GP tables have a DEX_ROW_ID column for the unique identifier. This column provides a unique identifier that can be used together with replication.
• Before you upgrade Microsoft Dynamics GP, remove replication from the instance of Microsoft SQL Server. Otherwise, problems will occur during the upgrade process.

• For more information about the configuration of replication, contact Microsoft Product Support Services at 800-936-5800.
• For more information about which tables should be replicated if you use replication for reporting in Microsoft Dynamics GP, send an e-mail message to the following address:
- نأسف لإخفاء البريد الإلكتروني ..تم إخفائه تلقائياً لأسباب تحمي الأعضاء من الرسائل الإعلانية(Spam) _الادارة -
Note Include the following information in the e-mail message: • The reason to use replication in the business
• The reports that you want to process together with the replicated databases


Back to the top

Clustering
• You can run Microsoft Dynamics GP in a single-instance clustering environment and in a multiple-instance clustering environment if there is a one-to-one relationship in an instance of SQL Server.
• For more information about the configuration for a clustering environment, contact Microsoft Product Support Services at 800-936-5800.

Back to the top

Log shipping and database mirroring
• You can run Microsoft Dynamics GP in an environment in which log shipping and database mirroring are enabled.
• For more information about the configuration for log shipping or for database mirroring, contact Microsoft Product Support Services at 800-936-5800.
• Before you upgrade Microsoft Dynamics GP, remove database mirroring from the Microsoft Dynamics GP databases. Otherwise, problems will occur during the upgrade process.
Note If you are using Replication, Log Shipping, or Database Mirroring and users have to access Microsoft Dynamics GP on the secondary server, the passwords for the users will no longer be valid. To reset the password, follow these steps:1. Log on to Microsoft Dynamics GP as the sa user.
2. Follow the appropriate step:• In Microsoft Dynamics GP 10.0, point to Tools on the Microsoft Dynamics GP menu, point to Setup, point to System, and then click User.
• In Microsoft Dynamics GP 9.0 and in earlier versions, point to Setup on the Tools menu, point to System, and then click User.

3. Click the lookup button next to User ID, and then select the appropriate user.
4. In the Password box, enter a new password, and then click Save.

Back to the top


--------------------------------------------------------------------------------

APPLIES TO
• System Manager, when used with:
Microsoft Dynamics GP 10.0
Microsoft Dynamics GP 9.0
Microsoft Business Solutions–Great Plains 8.0
Microsoft Business Solutions–Great Plains 7.5


Back to the top

Keywords: kbhowto kbexpertiseinter kbexpertiseadvanced kbmbspartner kbinfo kbmbsmigrate KB926490

Back to the top