Two different database for Head office

lovelyk · 2009-07-03

Dear all,

I have a client, who want to keep saperate database for reporting & for documenting.

If I elaborete, he want to made the documents in one server & after posting the data should flows to other one for reporting purpose so that he can reduce the dynamic growth of his database.

can anybody suggest me to this architecture.

Regards

ara3n · 2009-07-03

I have no idea what "the dynamic growth" means.
Maybe you need to explain to him how databases work and how navision works.
You can have a separate db for reporting purpose, it can be created through sql scripts and run at night.

Alex_Chow · 2009-07-03

lovelyk wrote:

Dear all,

I have a client, who want to keep saperate database for reporting & for documenting.

If I elaborete, he want to made the documents in one server & after posting the data should flows to other one for reporting purpose so that he can reduce the dynamic growth of his database.

can anybody suggest me to this architecture.

Regards

Check out database snapshot feature in SQL Server.

David_Cox · 2009-07-03

Also remember if you are using a second Dynamics Database that your Customer may need to pay for another licence from Microsoft.

David

David_Singleton · 2009-07-03

Alex Chow wrote:

Check out database snapshot feature in SQL Server.

Not a good idea, the performance would be terrible.

Two different database for Head office

Comments

Categories