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
shuttle from O'Hare Brocton .. Lockport Chicago limo O’HareMS CRM is very close to document workflow automation, including... Read More
If you're online using a dialup Internet connection, you'll probably... Read More
Your computer cost you from hundreds to thousands of dollars,... Read More
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More
Microsoft CRM is new player on the CRM software... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
Some companies that are in need of fleet management may... Read More
It is really interesting that a bug can create problem... Read More
Navision Software was purchased by Microsoft and now it is... Read More
Designing without tables by using CSS layouts is fast becoming... Read More
Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More
Before September of 1995, Microsoft ignored the Internet because their... Read More
Introduction: The creating of a computer program involves a number... Read More
The US House of Representatives has recently passed the "Spy... Read More
If you've been using MySQL database to store your important... Read More
Current Microsoft Business Solutions Great Plains has more that 10... Read More
Simply put, fleet maintenance allows companies to monitor and maintain... Read More
Have you ever noticed that when you look at your... Read More
If you have Microsoft Great Plains and support it for... Read More
Considering whether or not your software company should hire a... Read More
User interfaces and accessibility are some of the most important... Read More
The title of "software engineer" has got to be among... Read More
If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier)... Read More
I provide, here clear explanations and a count of function... Read More
Fundraising software lets you connect with donors in a way... Read More
Chicago charter limousine service Hickory Hills ..With this small article we are continuing Microsoft Business Solutions... Read More
Accounts payable is just one area of office management where... Read More
Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More
How would you like to prevent spyware and adware from... Read More
The java programming language is becoming more and more popular... Read More
One of the main reasons business owners and entrepreneurs use... Read More
Just when you thought you were Web savvy, one more... Read More
Most people understand that the "hardware" part of their computer... Read More
Logistics automation is often considered as barcoding extension to Sales... Read More
It is a well known fact that Java as a... Read More
If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More
ERP Consulting industry is on the way to serve clients... Read More
The various resume software offered, particularly on the internet, can... Read More
Once a business idea is selected, it is highly recommended... Read More
User interfaces and accessibility are some of the most important... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
It's no secret that software companies operate in a very... Read More
Although statistics often is blamed for various deadly sins --... Read More
It is possible that if one avoided all sources of... Read More
Beginning with Domino version R4 it has integration with the... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
We were recently faced with a decision: either to let... Read More
Let's say that you have a software project that's under... Read More
Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More
The most important benefit of XML is its simplicity. Though... Read More
Software |