You must Sign In to post a response.
  • Category: SQL Server

    How to create a global report for global client

    Hello,

    I develop SSRS report for a Client, who have office in nearly all regions.
    Lets talk about two regions, EMEA and US/APAC.
    As of now, we have different database server for different regions. Databases are nearly identical.
    Now we are going to develop a global reports for a global client.
    The first thing which comes into my mind is that, there should be a single database.

    Please advice what are the others ideas ...
  • #767871
    Hi,

    You can maintain a single database but you can differentiate with region you can maintain different tables for the same.

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/


Sign In to post your comments