Cisco Support Community
Showing results for 
Search instead for 
Did you mean: 

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

CAD 8.5 Convert Flat File to SQL

Has anyone been through the process of converting an existing system from Flat Files to SQL in a duplex environment?  What are the issues/concerns?  What about the credential used to install SQL?


Everyone's tags (3)

Probably not what you're

Probably not what you're looking for, but I did a CAD 7.x upgrade to 9. I didnt even bother with the flat file and just completely started over. I did a stare and compare for workflows and the desktop administrator web interface. It wasn't that bad, but that depends on how crazy your workflows are.

According to the CAD Install Guide on page 40, it advises you to install SQL and to go through CAD setup with a local user (not domain) that has local administrative privileges. This user must exist on both PGs and must exist on the Distributor that can also read the AW database. Make it a habit that anytime you're going to do something with CAD on this server that you log in as the aforementioned local user. 

If you follow the install guide to a tee, you shouldn't run into any issues.