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
Cadillac Deville rentals Bingham .. Lockport Chicago limo O’HareMicrosoft Business Solutions Great Plains is marketed for mid-size companies... Read More
What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More
Microsoft Business Solutions Small Business Manager is scaled down Great... Read More
When you double-click a layer in the Layer Palette, you... Read More
IntroductionPHP can be used for a lot of different things,... Read More
We are in a transition phase in the Managerial Administration... Read More
The US House of Representatives has recently passed the "Spy... Read More
Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More
All of us know that Microsoft bought former Great Plains... Read More
Spyware and Adware infest over 90 percent of computers in... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
One of the main reasons business owners and entrepreneurs use... Read More
One of the things we can be as certain of... Read More
1. With mapping software you can create a report that... Read More
Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has... Read More
New post-recession era has new features, which didn't exist in... Read More
Microsoft CRM is new player on the CRM software... Read More
ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More
Microsoft PowerPoint has dramatically changed the way in which academic... Read More
Accounts payable is just one area of office management where... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
The stakes are high when considering security, privacy, and savings,... Read More
Software Engineering is the Systematic Approach for analysis design implementation... Read More
eStore Advantage allows front-office applications to communicate with back-office business... Read More
Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More
limo rental Des Plaines ..It's not very often I get excited about a software... Read More
Microsoft Business Solutions Great Plains was designed back in the... Read More
I provide, here clear explanations and a count of function... Read More
Whether you have used Microsoft Word for years, have just... Read More
As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More
Three highly respected names in Human Resources have joined forces... Read More
Trying to figure out a stream in banning one email... Read More
It is really interesting that a bug can create problem... Read More
Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More
One of the main reasons business owners and entrepreneurs use... Read More
Here is some free software tools to help you build... Read More
DBxtra is a powerful query and reporting tool that hides... Read More
Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More
Buying accounting software is a major investment. It's an important... Read More
Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More
Viruses and spyware usually show up on your computer one... Read More
The US House of Representatives has recently passed the "Spy... Read More
Task Manager is a Windows system utility that displays thetasks... Read More
For those who are unclear on the differences between the... Read More
Microsoft Business Solutions Great Plains serves multiple industries in the... Read More
When it comes to screenplay software each screenwriter needs to... Read More
While paper labeling CDs and DVDs may appear to be... Read More
GroupwareThe internet is full of 1.5 million to 7 million... Read More
Just imagine: you are walking, say, towards your car, and... Read More
Software |