SQL Azure and Migration Wizard

May 14 at 1:04 PM
Running SQL Database Migration Wizard tool I got the following errors

1.'db_name(' is supported only for the local database. You should test to verify the results are what you want.
2.sp_delete_job is not supported in current version of SQL Azure;
3.sysjobs is not supported in current version of SQL Azure;
4.SYSTEM_USER is not supported in current version of SQL Azure;
5.sp_add_job is not supported in current version of SQL Azure;
6.sp_add_jobserver is not supported in current version of SQL Azure;
7.sp_add_jobstep is not supported in current version of SQL Azure;
8.sp_add_jobschedule is not supported in current version of SQL Azure;
9.sp_update_job is not supported in current version of SQL Azure;
10.sp_update_job is not supported in current version of SQL Azure;
11.sp_update_schedule is not supported in current version of SQL Azure;
12.sp_xml_preparedocument is not supported in current version of SQL Azure;
13.sp_xml_removedocument is not supported in current version of SQL Azure;
14.openxml is not supported in current version of SQL Azure;
15.BULK INSERT is not supported in current version of SQL Azure;
16.SELECT INTO statement is not supported in this version of SQL Azure;
17.OPENQUERY is not supported in current version of SQL Azure;
18.Global temp objects are not supported in this version of SQL Server;
19.sp_bindsession is not supported in current version of SQL Azure;
20.sys.data_SPACEs is not supported in current version of SQL Azure;
21.WITH XMLNAMESPACES is not supported in current version of SQL Azure;

All listed errors regard stored procedures in the database.

Do you know if there are workarounds for these?

Luca
Coordinator
May 14 at 4:32 PM
Hi Luca,

There is no work around for the errors reported above. Microsoft Azure SQL Database (SQL Azure) currently does not support SQL Server Agent. You will have to move this functionality to Web Sites, Worker Role, IaaS SQL Server, … someplace that you can setup and run jobs.

If you need anything, just catch me offline and I will be happy to work with you.

Ciao,
George