SQL Azure Setup

DRAFT

The following outlines the use of MS SQL Azure database service with WireCAD v8.

What You Should Know

1. This is an outline only. Not a full tutorial.
2. You can avoid the setup frustration of SQL Azure by purchasing the service from us.
3. WireCAD v8 on SQL Azure is structured to use a single database. This differs from the standard WireCAD approach where each project and the Global Equipment database is a separate database. In SQL Azure we use the database schema names to separate projects and the global database. This allows you to reduce cost since MS Azure is billed by database count and data i/o and storage requirements.
4. SQL Azure requires you to create Azure firewall rules for each device that will connect to the database server. Don't be alarmed by this as you can install a rule that let's all locations in.