Modernize-your-code-solution-accelerator
Designed to help customers transition their SQL queries to new environments quickly and efficiently. This accelerator is particularly useful for organizations modernizing their data estates, as it simplifies the process of translating SQL queries from various dialects.
File Explorer
Download Latest Version (.zip)- azure-dev.yml
- devcontainer.json
- Dockerfile
- bug_report.md
- feature_request.md
- ISSUE_TEMPLATE.md
- subtask.md
- azd-template-validation.yml
- azure-dev.yml
- broken-links-checker.yml
- build-docker-images.yml
- build-docker.yml
- deploy-orchestrator.yml
- deploy-v2.yml
- deploy.yml
- job-cleanup-deployment.yml
- job-deploy-linux.yml
- job-deploy-windows.yml
- job-deploy.yml
- job-docker-build.yml
- job-send-notification.yml
- pr-title-checker.yml
- pylint.yml
- scheduled-Dependabot-PRs-Auto-Merge.yml
- stale-bot.yml
- telemetry-template-check.yml
- test-automation-v2.yml
- test-automation.yml
- test.yml
- validate-bicep-params.yml
- CODEOWNERS
- dependabot.yml
- PULL_REQUEST_TEMPLATE.md
- f1.sql
- f10.sql
- f2.sql
- f3.sql
- f4.sql
- f5.sql
- f6.sql
- f7.sql
- f8.sql
- f9.sql
- q1_informix.sql
- q1_tsql.sql
- q2_informix.sql
- q2_tsql.sql
- q3_informix.sql
- q3_tsql.sql
- q4_informix.sql
- q4_tsql.sql
- q5_informix.sql
- q5_tsql.sql
- q6_informix.sql
- q6_tsql.sql
- q7_informix.sql
- q7_tsql.sql
- Backend.Dockerfile
- docker-compose.yml
- Frontend.Dockerfile
- app_auth.png
- app_reg_1.png
- app_reg_2.png
- app_reg_3.png
- client_id.png
- front_end.png
- platform_config.png
- redirect_url.png
- single_page.png
- single_page_2.png
- DeleteRG.png
- deleteservices.png
- resource-groups.png
- resourcegroup.png
- logAnalytics.png
- logAnalyticsJson.png
- logAnalyticsList.png
- agentArchitecture.png
- business-scenario.png
- customerTruth.png
- git_bash.png
- keyFeatures.png
- keyFeaturesDark.png
- keyFeaturesLight.png
- quick-deploy.png
- quickDeploy.png
- quota-check-output.png
- solArchitecture.png
- solArchitectureWAF.png
- solution-overview.png
- supporting-documentation.png
- supportingDocuments.png
- userStory.png
- webappHero.png
- AppServiceContainer.png
- azure_ai_foundry_list.png
- AzureHomePage.png
- backend_env_variables.png
- ContainerApp.png
- frontend_env_variables.png
- macae_waf_prompt.png
- navigate_to_projects.png
- project_resource_id.png
- resourcegroup1.png
- samplecodmod1.png
- ACRBuildPushGuide.md
- AddAuthentication.md
- ArchitectureWAF.md
- AVMPostDeploymentGuide.md
- AzureAccountSetUp.md
- AzureGPTQuotaSettings.md
- CmsaArchitectureSource.pptx
- CustomizingAzdParameters.md
- CustomizingScenario.md
- DeleteResourceGroup.md
- DeploymentGuide.md
- EXAMPLE-CustomizingAzdParameters.md
- LocalDevelopmentSetup.md
- LocalSetupGuide.md
- LogAnalyticsReplicationDisable.md
- modernize_report.pdf
- quota_check.md
- re-use-foundry-project.md
- re-use-log-analytics.md
- SampleWorkflow.md
- TroubleShootingSteps.md
- ai-services.bicep
- aifoundry.bicep
- dependencies.bicep
- project.bicep
- containerRegistry.bicep
- cosmosDb.bicep
- customTypes.bicep
- storageAccount.bicep
- virtualNetwork.bicep
- bastionHost.bicep
- jumpbox.bicep
- network-resources.bicep
- virtualNetwork.bicep
- network-subnet-design.bicep
- network_subnet_design.md
- .env
- .gitignore
- codeSample.py
- endpoint-requirements.txt
- endpointCodeSample.py
- index.json
- install.sh
- LICENSE
- README-noazd.md
- README.md
- requirements.txt
- abbreviations.json
- main.bicep
- main.json
- main.parameters.json
- main.waf.parameters.json
- build_and_push_images.ps1
- build_and_push_images.sh
- checkquota.sh
- quota_check_params.sh
- validate_bicep_params.py
- validate_model_deployment_quota.ps1
- validate_model_deployment_quota.sh
- validate_model_quota.ps1
- validate_model_quota.sh
- __init__.py
- auth_utils.py
- sample_user.py
- __init__.py
- api_routes.py
- event_utils.py
- status_updates.py
- config.py
- __init__.py
- cosmosdb.py
- database_base.py
- database_factory.py
- __init__.py
- app_logger.py
- __init__.py
- api.py
- __init__.py
- batch_service.py
- __init__.py
- blob_azure.py
- blob_base.py
- blob_factory.py
- __init__.py
- patch_instrumentor.py
- __init__.py
- azure_credential_utils.py
- __init__.py
- agent.py
- prompt.txt
- response.py
- setup.py
- __init__.py
- agent.py
- prompt.txt
- response.py
- setup.py
- __init__.py
- agent.py
- prompt.txt
- response.py
- setup.py
- __init__.py
- agent.py
- prompt.txt
- response.py
- setup.py
- __init__.py
- agent.py
- plug_ins.py
- prompt.txt
- response.py
- setup.py
- agent_base.py
- agent_config.py
- agent_factory.py
- __init__.py
- agents_manager.py
- comms_manager.py
- models.py
- utils.py
- tsqlParser
- Program.cs
- tsqlParser.csproj
- tsqlParser.sln
- tsqlParser.exe
- __init__.py
- agent_manager.py
- convert_script.py
- process_batch.py
- .env.sample
- __init__.py
- app.py
- Dockerfile
- flake8.txt
- mypy.ini
- pyproject.toml
- requirements.txt
- Arrow-Upload.png
- Checkmark.png
- Contoso.png
- Docicon.png
- progress.png
- config.js
- uploadService.ts
- utils.tsx
- WebSocketService.tsx
- confirmationDialogue.tsx
- Content.tsx
- ContentToolbar.tsx
- Header.tsx
- HeaderTools.tsx
- PanelRightToggles.tsx
- UserProfile.tsx
- PanelLeft.tsx
- PanelLeftToolbar.tsx
- PanelRight.tsx
- PanelRightToolbar.tsx
- batchHistoryPanel.css
- batchHistoryPanel.tsx
- bottomBar.tsx
- bundleIcons.tsx
- eventbus.tsx
- fileItem.tsx
- MsftColor.tsx
- steps.tsx
- uploadButton.tsx
- uploadStyles.css
- AuthProvider.tsx
- AuthWrapper.tsx
- msaConfig.ts
- msalInstance.tsx
- useAuth.ts
- batchView.tsx
- landingPage.css
- landingPage.tsx
- modernizationPage.tsx
- ApiService.tsx
- batchSlice.ts
- historyPanelSlice.ts
- store.ts
- types.ts
- App.css
- App.jsx
- authUtils.ts
- index.css
- main.jsx
- .dockerignore
- .env.sample
- .gitignore
- declarations.d.ts
- Dockerfile
- eslint.config.js
- frontend_server.py
- index.html
- package-lock.json
- package.json
- postcss.config.js
- README.md
- requirements.txt
- tailwind.config.js
- vite.config.js
- __init__.py
- auth_utils_test.py
- __init__.py
- api_routes_test.py
- event_utils_test.py
- status_updates_test.py
- config_test.py
- __init__.py
- cosmosdb_test.py
- database_base_test.py
- database_factory_test.py
- app_logger_test.py
- api_test.py
- __init__.py
- batch_service_test.py
- __init__.py
- blob_azure_test.py
- blob_base_test.py
- blob_factory_test.py
- sample_batch.json
- azure_credential_utils_test.py
- __init__.py
- agent_base_test.py
- agent_config_test.py
- agent_factory_test.py
- plug_ins_test.py
- __init__.py
- agents_manager_test.py
- comms_manager_test.py
- utils_test.py
- __init__.py
- agent_manager_test.py
- convert_script_test.py
- process_batch_test.py
- __init__.py
- app_test.py
- __init__.py
- conftest.py
- __init__.py
- base.py
- constants.py
- __init__.py
- HomePage.py
- loginPage.py
- harmful_content_2 2.sql
- invalid.py
- test_audio.wav
- test_doc.docx
- test_json.json
- test_pdf.pdf
- test_text.txt
- f1.sql
- f10.sql
- f2.sql
- f3.sql
- f4.sql
- f5.sql
- f6.sql
- f7.sql
- f8.sql
- f9.sql
- q1_informix.sql
- q1_tsql.sql
- q2_informix.sql
- q2_tsql.sql
- q3_informix.sql
- q3_tsql.sql
- q4_informix.sql
- q4_tsql.sql
- q5_informix.sql
- q5_tsql.sql
- q6_informix.sql
- q6_tsql.sql
- q7_informix.sql
- q7_tsql.sql
- invalid.py
- __init__.py
- conftest.py
- test_codegen_gp_tc.py
- .gitignore
- pytest.ini
- readme.MD
- requirements.txt
- .dockerignore
- .flake8
- .gitignore
- .pre-commit-config.yaml
- azure.yaml
- CODE_OF_CONDUCT.md
- CONTRIBUTING.md
- LICENSE
- README.md
- SECURITY.md
- SUPPORT.md
- TRANSPARENCY_FAQS.md
# Installation Guide
git clone https://github.com/microsoft/Modernize-your-code-solution-accelerator
Downloads the entire project code from GitHub to your computer.
cd Modernize-your-code-solution-accelerator
Moves into the project folder you just downloaded.
2. Docker
Easy Recommended- Git Needed to download the project code from GitHub.
- Docker Desktop Needed to build and run containers. Install it and keep it running in the background.
docker compose -f docker/docker-compose.yml up -d --build
Runs the command against the services defined in the compose file.
3. .NET
Mediumcd src/backend/sql_agents/tools/src
This project's files live in a subfolder, so move into it first.
dotnet restore
Downloads the packages the project depends on.
dotnet run
Builds the project and runs it immediately.
4. Node.js
Easycd src/frontend
This project's files live in a subfolder, so move into it first.
npm install
Downloads and installs the libraries listed in package.json.
npm start
Starts the development/run server.
5. Python
Easypip install -r infra/vscode_web/requirements.txt
Installs the Python libraries listed in requirements.txt (or similar).
python <μ€νν νμΌλͺ
>.py # READMEμμ μ νν μ€ν νμΌλͺ
μ νμΈνμΈμ
Runs the Python script (or module).
