sexta-feira, julho 10, 2020

SQL Server 2008 R2 to Azure SQL Database

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: