There are certain pluses and minuses in both cases and you should make your decision, based on your company needs. We'll give you some hints in this subject and you should know then where to look further.
Legendary Strength of C/SIDE database - the history of Navision design reveals the primary goals to have its own proprietary database with the built-in features of database transaction integrity. As far as database is proprietary - Navision can manipulate its and tune it to serve its application. You can have users use the system heavily and suddenly shut down the power - when power is back on - Navision will be in the same good shap. The second goal was to provide robust graphical interface.
What is the volume of your data? - Navision was originally targeting mid-size and large corporations. Now, however, Microsoft is trying to target it to large corporations with sophisticated manufacturing. In this case you could expect huge volume of data - Microsoft SQL Server is better positioned to deal with that.
Do you have MS SQL Server Administrator? - Microsoft announces that MS SQL Server is moving to "zero-maintenance needed", but we would like to warn you - if you use Navision - you are more likely mid-size or large company. In this case you should have somebody to secure your database - in the case if you would like to deploy MSSQL Server
Do you plan on Crystal Reports? - you can always deploy C/ODBC to enable your C/SIDE database for Crystal Report, but MS SQL Server has such nice features, as SQL Views and Stored Procedures, which make SQL Server preferable platform
Do you need OLAP/Datawarehousing? - then SQL Server is the way to go. It has built in Analytical Server with OLAP cube creation and Excel data pivoting
Do you plan to expose Navision data to other applications? - Navision has tools to expose the data from C/SIDE database (C/ODBC, C/FRONT), but in the case of SQL Server you certainly have standard Microsoft technologies in your disposition
Good luck in database selection and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com
Robert Horowitz is Certified Navision Specialist in Microsoft Business Solutions Partner: Alba Spectrum Technologies ? USA nationwide Navision, Great Plains, Microsoft CRM customization company, based in Chicago, California, Arizona, Texas, Florida, New York, Georgia, Washington, Colorado, Canada, UK, Australia and having locations in multiple states and internationally (help@albaspectrum.com). You can contact Robert: help@albaspectrum.com
Trevor chicago limos ..Siebel is traditional CRM market leader, however and mostly due... Read More
One of the main reasons business owners and entrepreneurs use... Read More
Professional services firm cuts costs and improves productivity with integrated... Read More
Now there are Three Steps To Heaven Just listen and... Read More
Adobe Photoshop is one of the world's leading graphics editing... Read More
It would be easy to think, like most people apparently... Read More
Anyone who has ever used Microsoft Word knows that it... Read More
When you think... Read More
Adware is a type of Spyware program that displays some... Read More
Shareware is software that you can try before you buy;... Read More
Should one use Windows Update?This topic has good and valid... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
Spyware, what it is and what it does. Basically, spyware... Read More
Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More
I love new technology. I am still ready to wait... Read More
C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More
Although we don't know whether Microsoft ever envisioned such a... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
The intentions of this short tutorial are not to teach... Read More
Microsoft Business Solutions Small Business Manager is scaled down Great... Read More
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More
Find out why Spyware Removal from computers is important and... Read More
When Great Plains Software was designing and developing Great Plains... Read More
Baylis taxi from Midway ..Beginning with Domino version R4 it has integration with the... Read More
Although statistics often is blamed for various deadly sins --... Read More
Microsoft CRM is CRM answer from Microsoft and attempt to... Read More
If you copy something from a Web site or elsewhere...... Read More
Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More
Former Great Plains Software Dynamics/eEnterprise, and currently Microsoft Business Solutions... Read More
With thousands of web pages added to the Net every... Read More
Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
It is possible that if one avoided all sources of... Read More
Usually workflow & messaging is realized in CRM and then... Read More
Microsoft Great Plains, designed back in 1990th as database transferable... Read More
Whether you need to close a sale, gather end-user feedback,... Read More
Microsoft Great Plains as ERP and Microsoft CRM as... Read More
While I was preparing some personal background information for a... Read More
Not every software testing project can or should be automated.... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
If you look back to the history, you will see... Read More
How would you like to prevent spyware and adware from... Read More
If you have Microsoft Great Plains and support it for... Read More
Task Manager is a Windows system utility that displays thetasks... Read More
Case study: A secretary using Corel WordPerfect 7 is often... Read More
We'll give you non formal view, based on our consulting... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
Software |