The end of Extended Support for the SQL Server 2008 and Windows Server 2008 R2 ended on July 9, 2019.
I will write a few steps to migrate a simple database to Azure SQL Database.
https://support.microsoft.com/en-us/help/4456242/end-of-support-for-sql-server-2008-and-sql-server-2008-r2
First my goal is migrate the database mydatabase:
1. Download and install data migrator assistent:
https://www.microsoft.com/en-us/download/details.aspx?id=53595
2. Run an Assessment to check any compatibility issues (Create a Project):
3. Migrate the Data and Schema
Connect to localhost and select the database:
Select the target ( An Azure SQL Server ) and database target (The database must be create before start the migration process ):
Your public IP must be allowed to access the server.
Next and Deploy:
Deploy Data and Start data migration:
4. Check the databases\table on Azure portal
Nenhum comentário:
Postar um comentário