Usando AWS re:Post, accetti AWS re:Post Termini di utilizzo
AWS re:Postre:Post

How to migrate a Microsoft SQL server with custom deployed stored procedure to RDS for Microsoft SQL SERVER

0

Hi, We are evaluating to migrate our dot net framework based application using the SQL server as data base to AWS cloud.We are evaluation the RDS for SQL server as possible option for database , however the current application has a of dependency on custom build stored procedure ( keeping a lot of business logic) . Can we use RDS option for SQL server has option to use custom stored procedures and function . Also is there option to migrate the data as well as SP and function to RDS for SQL server.

Unfortunately , I do not have much exp with SQL server and Window based application , hence i am bit clueless . Any help would be appreciated

Argomenti
Migrazione e modernizzazioneDatabaseAnalisi.NET su AWS
Tag
Servizio di migrazione dei database AWSMicrosoft SQL ServerAmazon Relational Database ServiceDatabase.NET su AWS
Lingua
English
Iknownothing
posta 2 anni fa1361 visualizzazioni
1 Risposta
1

Hi There

There are a few ways to do the migration from SQL Server to RDS SQL. The easiest way would probably be a backup/restore which would include your database objects like stored procedures, as well as the data. See https://docs.aws.amazon.com/dms/latest/sbs/chap-manageddatabases.sql-server-rds-sql-server-full-load-backup-restore.html

profile pictureAWS
ESPERTO
Matt-B
con risposta 2 anni fa
profile picture
ESPERTO
Giovanni Lauria
verificato 7 mesi fa
  • Iknownothing
    2 anni fa

    Hey Matt , Thanks for the pointing out to the documentation. Since , it's took some time for me to comment as i wanted to test the solution.Yes the backup and restore keeps the original objects so in theory it works but we had some libraries and utilities that were not natively supported by the RDS versions , hence we need to refactor some stuffs .

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande

Contenuto pertinente