Modifica di Ambiente di Sviluppo - Configurazione (sezione)

== Script Tunnel AWS ==
Creare '''4 script batch''' per generare i tunnel da localhost verso le istanze private database server.<br/>
Sostituire <code>profilename-dev</code> con il profilo creato tramite la [[IAM_Identity_Center|AWS CLI]]

=== MS SQL Server Produzione ===
* <code>Porta 1433 => 1433</code>
* <code>Istanza MSSQL i-09b370f16714cad78</code>
''AWS-MSSQL-Forward.bat''
<syntaxhighlight lang="bash">
aws ssm start-session --target i-09b370f16714cad78 --document-name AWS-StartPortForwardingSession --parameters "portNumber"=["1433"],"localPortNumber"=["1433"] --region us-east-1 --profile profilename-dev
</syntaxhighlight>

=== MS SQL Server Staging === 
* <code>Porta 14330 => 1433</code>
* <code>Istanza MSSQL Staging i-0d96d04878227f879</code>
''AWS-MSSQL-Staging-Forward.bat''
<syntaxhighlight lang="bash">
aws ssm start-session --target i-0d96d04878227f879 --document-name AWS-StartPortForwardingSession --parameters "portNumber"=["1433"],"localPortNumber"=["14330"] --region us-east-1 --profile profilename-dev
</syntaxhighlight>

=== MySQL Produzione ===
* <code>Porta 3306 => 3306</code>
* <code>Istanza MYSQL i-0a01bbdebbaeb8cca</code>
''AWS-MYSQL-Forward.bat''
<syntaxhighlight lang="bash">
aws ssm start-session --target i-0a01bbdebbaeb8cca --document-name AWS-StartPortForwardingSession --parameters "portNumber"=["3306"],"localPortNumber"=["3306"] --region us-east-1 --profile profilename-dev
</syntaxhighlight>

=== MySQL Staging ===
* <code>Porta 33060 => 3306</code>
* <code>Istanza MYSQL Staging i-0e5bf4f77c31b8b78</code>
''AWS-MYSQL-Staging-Forward.bat''
<syntaxhighlight lang="batch">
aws ssm start-session --target i-0e5bf4f77c31b8b78 --document-name AWS-StartPortForwardingSession --parameters "portNumber"=["3306"],"localPortNumber"=["33060"] --region us-east-1 --profile profilename-dev
</syntaxhighlight>