Easy Data Recovery
Data Recovery Software, Tools, Methods, Reviews, Advice & More!
Microsoft Navision Database Selection: C/SIDE or MS SQL Server - Overview For IT Specialist
Article By: Robert Horowitz
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
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
Choose A Customized Data Recovery Solution From DiskDoctors:
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 (www.albaspectrum.com). You can contact Robert: welcome@albaspectrum.com
Microsoft Navision Database Resources
Data Recovery The Easy Way
If you aren't prepared in advance, you will most likely have to use a data recovery service or data recovery software solution to help get back as much as you can of what was lost. This can be a very good...
5 Ways To Backup Your Data
The data on your hard drive is the most critical item inside your computer, and the only item which can not be replaced. It may be an unwanted hassle and expense to replace a defective memory module, monitor,...
Do You Have The One Key Ingredient Necessary For Disaster Recovery?
It is not rocket science, we all know that we should have a disaster recovery plan in place for our business regardless of its size. When disaster strikes, it seldom discriminates on the size of the company....
Your Macintosh Data Recovery Choices
You can own a macintosh computer for either business or pleasure, but either way you have valuable data that should be protected from harm that is caused during a hard drive crash. Data can be harmed when...
Offsite Backups Provide Digital Peace of Mind
In today's fast paced data-centric world of personal computers and consumer/business electronics (such as PDAs and digital media players) we have, as a society, developed a reliance on digital data. We...
The Cost of Data Loss
There are many unfortunate circumstances that can befall your company's information technology systems. From hardware failures to property theft, there are many pitfalls that await your technology investment,...
