Difference between revisions of "SQL Azure Setup"

Revision as of 18:43, 20 November 2015

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.

The Steps

1. Establish an Azure account for your organization. If you check around the interwebs you can probably find a free or next to free subscription for your small biz or nonprofit or government or big monster organization.
2. Create the SQL Azure database with a name you will remember say WireCADAzureDB. That's what I will use in this discussion.
3. WireCAD will need the server host name and the database name. See the graphic a screen shot.
4. Download and install MS Sql Server Management Studio. You will need it.
6. Open WireCAD and run the Application Start Wizard. When prompted, select the Azure option.