Deploying the Report Web Service to Azure (Web Sites)

1.- Upload the Report Web Service files to your web site’s root, these are in the Report Web Service folder in DBxtra’s installation directory (C:\Program Files\DBxtra .NET by default).

2.- Upload your repository and the schedule history files (DBxtraDB.sdf and DBxtraScheduleHistoryDB.sdf) to your web site’s root, these are in the repository folder (Physical Path in Utilities->DBxtra Repository->DBxtra Repository Path).

3.- Locate the folder where SQL Server Compact private deployment libraries lie (C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\Private by default).

4.- Copy the contents of this folder into the bin folder of your Report Web Service in Azure, you should replace one file.

5.- Modify your web.config file and add the following lines anywhere inside the <configuration></configuration> tags to register SQL Server Compact:

<system.data>

<DbProviderFactories>

<remove invariant=”System.Data.SqlServerCe.4.0″/>

<add name=”Microsoft SQL Server Compact Data Provider 4.0″ invariant=”System.Data.SqlServerCe.4.0″ description=”.NET Framework Data Provider for Microsoft SQL Server Compact” Type=”System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91″/>

</DbProviderFactories>

</system.data>

<runtime>

<assemblyBinding xmlns=”urn:schemas-microsoft-com:asm.v1″>

<dependentAssembly>

<assemblyIdentity name=”System.Data.SqlServerCe” publicKeyToken=”89845dcd8080cc91″ culture=”neutral”/>

<bindingRedirect oldVersion=”0.0.0.0-65535.65535.65535.65535″ newVersion=”4.0.0.1″/>

</dependentAssembly>     

</assemblyBinding>

</runtime>

Now your Report Web Service should be fully working in Azure.