SSRS stored procedure modification on snowflake data source

Vivaan Shresth 101 Reputation points
2022-11-14T10:47:13.91+00:00

Hi,

I am looking for stored procedure migration from MS SQL stored procedures to SNOWFLAKE Data source.
Could you please if we have any tools or any process for it? Just have to modify existing all sps to snowflake Datasource.

Thanks,
Vivaan

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,873 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,599 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaktiSingh-MSFT 14,386 Reputation points Microsoft Employee
    2022-11-16T05:54:37.133+00:00

    Hi @Vivaan Shresth ,

    Thanks for reaching Microsoft Q&A Platform.

    Regarding SSRS stored procedures migration to Snowflake, you may post the question in Snowflake community to be answered by Community Experts at Snowflake forum

    However, as per the question you have mentioned stored procedure migration from MS SQL stored procedures to SNOWFLAKE Data source, I could find few articles which might be helpful:

    how-to-migrate-mysql-data-to-snowflake-without-using-any-thirdparty-tool

    a-guide-to-migrate-ssrs-source-to-snowflake-e51b62165c5a

    mysql-to-snowflake-data-migration-steps

    has-anyone-use-snowflake-as-datasource-for-mssql-ssrs-report-if-you-do-how-to-pass-a-vaiable-to-snowsql-from-ssrs

    0 comments No comments