Configure 100 database on Azure PAAS Service and SSRS need to be configured on it

Sarvesh Pandey 141 Reputation points
2021-03-05T12:05:14.913+00:00

We have two on-premise SQL Server (Azure SQL VM) and each server has 70+database. We are already in Azure and we need to move to Azure PAAS, but the issue is we want SSRS as well. Now, Azure SQL MI has limitation of 100 database only and Azure SQL DB cannot be used for this. Does Microsoft have some service in PAAS for this scenario or SQL VM is the only option?

SQL Server on Azure Virtual Machines
Azure SQL Database
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,799 questions
Accepted answer
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-03-08T07:17:32.973+00:00

    Hi @Sarvesh Pandey ,
    According to your description, Power BI looks more suitable for your needs.

    • Power BI is a data analysis and reporting software produced by Microsoft, which is a leading business intelligence tool. Power BI has expanded its management in the areas of information networking, data conversion, data preparation, information presentation, announcements, and dashboards.
    • Power BI is easy to understand and easy to use for report creation and data analysis. It has rich graphics processing capabilities.
    • Power BI can get information from the cloud. SSRS can only use local information.
    • Power BI Report Server (PBIRS) is the successor to SSRS and has more highlights than SSRS. First, it can utilize and present intuitive PBIX and scientific XLSX reports that SSRS cannot achieve.
    • Power BI has a graphical interface with simplified report making functions. Unstructured information can be used to coordinate and group development using today's presentation methods.

    Next, compare PBI and SSRS:

    1. Innovation
      Power BI: Microsoft Power BI is a new era of business insight innovation for managing information and producing reports. Easy-to-use programming and easy-to-use highlighting functions can be used to produce, distribute and share reports.
      SSRS: SSRS is SQL Server Reporting Service, which is also a product of Microsoft. It is a server-based routine report generation and information check program.
    2. History
      Power BI: Compared with SSRS, it is a new innovation, because Power BI Report Server, Power BI's report server, was launched in 2017.
      SSRS: SQL Server Detailing Administration was launched in 2004.
    3. Advantages
      Power BI: Easy to understand and easy to use for report creation and data analysis. It has rich graphics processing capabilities.
      SSRS: In the scope of the visual chart, SSRS does not provide much, but SSRS has a good drill-down function.
    4. Usage
      Power BI: Power BI Report Server (PBIRS) can be used to generate, distribute, and share cloud-based reports and dashboards, just like server-based.
      SSRS: SSRS only generates and only provides server-based reports.
    5. Usability
      Power BI: Power BI programming can be done through three different types of stages. Internet, mobile phone (application) and desktop.
      SSRS: Only use SSRS on the web and desktop.
    6. Licensing
      Power BI: Power BI Desktop is free. Purchase Power BI Pro according to user license requirements, or purchase SQL Server Enterprise Edition to get Power BI Report Server.
      SSRS: To use SSRS, you need to purchase a SQL Server license.
    7. Use
      Power BI: With its rich graphical user interface and intuitive features, it is easy to use.
      SSRS: Not easy to use, because it requires a separate programming interface.
    8. Data dependence
      Power BI: Unstructured and organized information can be used.
      SSRS: With SSRS, unstructured information cannot be processed.

    Hope this helps.
    Best Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 32,886 Reputation points MVP
    2021-03-05T15:58:08.787+00:00

    Azure SQL VM (IaaS) is you best option if SSRS is involved.

    Maybe is time you consider Power BI as replacement for SSRS. This will allow you to move towards PaaS, and a lot of other benefits. Click here to know how to migrate reports to Power BI. Check out here the biggest differences between SSRS and Power BI, you may find reasons on that article to migrate to Power BI.

    Take a look here about how Power BI stack on the Analytics and BI markets.

    0 comments