Migration of reports SQL server to AWS database (Redshift/Snowflake/etc)

[Marico]

I have 20+ whose data source I want to change from SQL Server 2008 to AWS databases like Redshift/Snowflake/etc. Could you please tell me the steps involved and the things to keep in mind while doing this migration?

[v-shex-msft · Accepted solution]

Hi @Marico,

According to your description, I think your requirement is more related to database migration.

For this scenario, I'd like to suggest you post on the SQL Server forum or contact the AWS support team to get further support about migration operations.

Msdn forums - SQL Server 

AWS Support and Customer Service Contact Info | Amazon Web Services
Regards,

Xiaoxin Sheng

[Anonymous]

Hi Xiaoxin, Marico's request is not about the migration of the SQL Server database to Redshift etc but about to go about migrating the existing PBI reports, which were querying the SQL Server database, to query its new implementation in Redshift etc. The idea is to automate the process as much as possible.

[Marico]

Hi - Can anyone help with the above query?