cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Cisco Community Designated VIP Class of 2020

264
Views
0
Helpful
1
Replies
Highlighted
Enthusiast

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?

Thanks!

Everyone's tags (3)
1 REPLY 1
Rising star

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.

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here