migratie_van_cloud_naar_azure
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
migratie_van_cloud_naar_azure [2017/12/04 15:58] clubadmin |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | [[http:// | ||
| - | |||
| - | **Microsoft® Data Migration Assistant** | ||
| - | <WRAP center round download 100%> | ||
| - | https:// | ||
| - | |||
| - | ====== Migratie van de Cloud naar Azure ====== | ||
| - | ===== STAP 1: Aanmaak blanco database | ||
| - | |||
| - | - Aanmelden op [[https:// | ||
| - | - SQL-databases selecteren en op " + Toevoegen" | ||
| - | - Naam Database ingeven | ||
| - | - Abonnement = Betalen naar gebruik | ||
| - | - Resouregroep = Group | ||
| - | - Elastische SQL Pool = Niet nu | ||
| - | - Prijscategorie = Basic 2GB | ||
| - | - {{: | ||
| - | |||
| - | ===== STAP 2: Login aanmaken Azure ===== | ||
| - | |||
| - | * Maak connectie met clubcloud01.database.windows.net\ via SQL Server Management Studio | ||
| - | * Volgende Query uitvoeren op ' | ||
| - | * '' | ||
| - | CREATE LOGIN [**USR**] WITH PASSWORD=' | ||
| - | |||
| - | * **Voorbeeld: | ||
| - | |||
| - | * Daarna de login koppelen aan de juiste database met de volgende query op de database. | ||
| - | * '' | ||
| - | |||
| - | * **Voorbeeld: | ||
| - | |||
| - | |||
| - | ===== STAP 3: Migratie Database ===== | ||
| - | |||
| - | <WRAP center round tip 100%> | ||
| - | Om tijd te besparen is het aan te raden om het volgende uit te voeren op de database die je wilt migreren: | ||
| - | |||
| - | '' | ||
| - | |||
| - | '' | ||
| - | </ | ||
| - | |||
| - | ==== New Project ==== | ||
| - | |||
| - | * Start Microsoft Data Migration Assistant op | ||
| - | * Selecteer ' | ||
| - | * Project type = Migration | ||
| - | * Project name = Naam club | ||
| - | * Source server type = SQL Server | ||
| - | * Target server type = Azure SQL Database | ||
| - | * Migration scope = schema and data | ||
| - | * {{:: | ||
| - | |||
| - | ==== Select source ==== | ||
| - | |||
| - | * Server name = Cloud01, cloud02 of cloud03 | ||
| - | * Authentication type = SQL SERVER | ||
| - | * Encrypt connection = JA | ||
| - | * Trust server certificate = JA | ||
| - | * Klik op " | ||
| - | * Selecteer de db naar keuze | ||
| - | * {{:: | ||
| - | |||
| - | ==== Select target ==== | ||
| - | |||
| - | * Server name = clubcloud01.database.windows.net\ | ||
| - | * Authentication type = SQL SERVER | ||
| - | * Encrypt connection = JA | ||
| - | * Trust server certificate = JA | ||
| - | * Klik op " | ||
| - | * Selecteer de blanco db die je hebt aangemaakt | ||
| - | * {{:: | ||
| - | |||
| - | ==== Script & deploy schema ==== | ||
| - | ==== Select tables ==== | ||
| - | ==== Migrate data ==== | ||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | | ||
migratie_van_cloud_naar_azure.1512399512.txt.gz · Last modified: 2017/12/04 16:58 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
