Migrating your sql server DB to Azure
We will move an existing on-premise database from SQL Server on premise to the cloud. We will do this by using scripts. In order to assist in completing the exercise in a timely fashion and to avoid a dependency on SQL Server and SQL Server management studio on our local machine these scripts have been pre generated.
Generating the SQL script:-
-
- image002
-
- image003
Run the SQL Server scripts exported from local database to the SQL Azure database.
To execute the sql scripts remove the following part from the query.
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
ON [PRIMARY]
SET ANSI_NULLS ON
GO
