Step 1:
Download and install the Enterprise library Azure integration packages from the below link
http://www.microsoft.com/en-us/download/details.aspx?id=28189
Step 2:
During the installation of EnterpriseLibraryIntegrationPack-WindowsAzure-sqlscripts, Installer will ask you to provide the location to extract the sql scripts.
Step 3:
There are certain script files will be created in the installation location.
CreateCachingDatabase.sql
CreateCachingDatabaseObjects.sql
CreateLoggingDatabase.sql
CreateLoggingDatabaseObjects.sql
savemessages.vbs
savemessages1.vbs
savemsg.bat
savemsg1.bat
Step 4:
Open MS-SSMS 2012 and connect your Azure SQL DB and Run SQL scripts. First run the create database scripts and then run the relevant Object sql script by right click and selecting the new query in the relevant Database.
Step 5:
After the successful run, you can see the below tables created in your Azure SQL database instance.
DB: Logging
DB:Caching
Regards,
-Gopal
Download and install the Enterprise library Azure integration packages from the below link
http://www.microsoft.com/en-us/download/details.aspx?id=28189
Step 2:
During the installation of EnterpriseLibraryIntegrationPack-WindowsAzure-sqlscripts, Installer will ask you to provide the location to extract the sql scripts.
Step 3:
There are certain script files will be created in the installation location.
CreateCachingDatabase.sql
CreateCachingDatabaseObjects.sql
CreateLoggingDatabase.sql
CreateLoggingDatabaseObjects.sql
savemessages.vbs
savemessages1.vbs
savemsg.bat
savemsg1.bat
Step 4:
Open MS-SSMS 2012 and connect your Azure SQL DB and Run SQL scripts. First run the create database scripts and then run the relevant Object sql script by right click and selecting the new query in the relevant Database.
Step 5:
After the successful run, you can see the below tables created in your Azure SQL database instance.
DB: Logging
- Category
- CategoryLog
- Log
DB:Caching
- CacheData
Regards,
-Gopal