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
Alexis limo rentals ..Microsoft Great Plains may be recommended for international freight forwarding... Read More
I provide, here clear explanations and a count of function... Read More
With any good luck and a good amount of hard... Read More
Microsoft Great Plains is main accounting / ERP application... Read More
The objective for Zandi Digital is to make available clever... Read More
The Internet is reshaping every form of communications medium, and... Read More
We are in a transition phase in the Managerial Administration... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
I've been active in the Cisco Certification track for four... Read More
Microsoft bought Navision, Denmark based software development company, along with... 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
Whether you are a small consultancy firm, a medium sized... Read More
Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More
Microsoft Great Plains is becoming more and more popular and... Read More
Need software to record your voice, streaming audio or musical... Read More
Preventive Maintenance (PM) is defined as scheduled work done on... Read More
NOTE: Please take time to read on - it may... Read More
Best Software Act! is very popular CRM for small and... Read More
The most important things you can do for your computer... Read More
Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More
Microsoft Business Solutions ? Great Plains is designed to meet... Read More
Corporate ERP/MRP selection might be tough one, especially considering very... Read More
One of the main reasons business owners and entrepreneurs use... Read More
Trying to figure out a stream in banning one email... Read More
car service from Midway Alsip ..Microsoft bought Navision, Denmark based software development company, along with... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
There are two approaches for application integration:? Programmer's approach ?... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Retail Management System serves retail single store as well... Read More
To all web designers out there, this article is for... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
Did you ever want to erase everything on your computer?... Read More
There are so many different programs that clutter up your... Read More
If you have Microsoft Great Plains as main accounting and... Read More
Preventive Maintenance (PM) is defined as scheduled work done on... Read More
The intentions of this short tutorial are not to teach... Read More
A UNIX Shell is in simplest terms, a command line... Read More
Scrapbooks are very popular these days. I think that almost... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
The first topic we are going to discuss... Read More
I have recently created my first Php program. I wanted... Read More
How many steps does it take you to locate and... Read More
Traditionally we were considering functionally rich systems, such as SAP,... Read More
Logistics automation is often considered as barcoding extension to Sales... Read More
This is a short article, written in question/answer/FAQ style to... Read More
XML parser is a software module to read documents and... Read More
The stakes are high when considering security, privacy, and savings,... Read More
Internet worms. Is your PC infected?If your computer has become... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
Software |