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
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
Business Continuity and Disaster Recovery - Selecting A Business Continuity Strategy
The risk analysis and business impact analysis have identified risks to key business functions. Also, the potential impacts and probabilities of these risks as well as the costs to prevent or mitigate...
Online Data Backups for Newbies
How long have you been doing business online? Whether you are new or an old timer you need to understand the one important truth of the e-world. That being that the largest threat to business survival...
Business Continuity and Disaster Recovery - Risk Analysis and Control
In the risk evaluation phase, there are a number of key areas that must be covered. One of the most important is to understand probable threats. In an ideal world, which most of us have noticed does not...
Looking At Tape Data Recovery
For those curious about tape data recovery and what it entails and involves: read on! Tape data recovery the recovery of any data that has been lost on a tape, obviously, but what it involves is quite...
DVD Data Recovery Software Programs
There are many software programs out there that will conduct dvd data recovery for you. Many times information is lost on your dvd and it is important to you that this data be retrieved. When it comes...
Laptop Data Recovery On The Move!
In todays world of travelling business people journeying around the country, taking their work with them, laptop data recovery can be as important as ever. Laptops are travelling computers that you can...
Additional Microsoft Navision Database Related Resources...
Syscon To Offer Its Solution Through SaaS (Business Standard India)
Syscon Solutions, a Hyderabad-based software product development company, will expand its sales and implementation ecosystem to cater to the small and medium enterprises (SMEs).
Syscon Solutions, a Hyderabad-based software product development company, will expand its sales and implementation ecosystem to cater to the small and medium enterprises (SMEs).
Tenrox Release 10 Simplifies On-Demand Project Management Software (Centre Daily Times)
Tenrox announces the availability of Release 10 - the latest version of the company's on-demand Project Workforce Management Solution. The new release marks a significant milestone in offering an ideal tool to simplify, facilitate and accelerate project management and resource planning. Tenrox demonstrates its commitment to providing the ultimate SaaS (software as a service) solution for project ...
Tenrox announces the availability of Release 10 - the latest version of the company's on-demand Project Workforce Management Solution. The new release marks a significant milestone in offering an ideal tool to simplify, facilitate and accelerate project management and resource planning. Tenrox demonstrates its commitment to providing the ultimate SaaS (software as a service) solution for project ...
Software Builds Composite Applications On SharePoint. (ThomasNet)
Suited for small and large enterprises, CorasWorks Data Integration Toolset(TM) offers modular development tool for building business applications that integrate data from SharePoint, external data sources, and external applications. Program offers end-to-end set of components, from customizable end user displays and read-write forms, to mashup and business analysis adapters, modular data ...
Suited for small and large enterprises, CorasWorks Data Integration Toolset(TM) offers modular development tool for building business applications that integrate data from SharePoint, external data sources, and external applications. Program offers end-to-end set of components, from customizable end user displays and read-write forms, to mashup and business analysis adapters, modular data ...
Tenrox Release 10 Simplifies On-Demand Project Management Software (Business Wire Via Yahoo! Finance)
GLENDALE, Calif.----Tenrox announces the availability of Release 10 - the latest version of the company's on-demand Project Workforce Management Solution. The new release marks a significant milestone in offering an ideal tool to simplify, facilitate and accelerate project management and resource planning.
GLENDALE, Calif.----Tenrox announces the availability of Release 10 - the latest version of the company's on-demand Project Workforce Management Solution. The new release marks a significant milestone in offering an ideal tool to simplify, facilitate and accelerate project management and resource planning.
CorasWorks(R) Releases Third Version Of The Data Integration Toolset(TM) (PR Newswire Via Yahoo! Finance)
CorasWorks Corporation, a leading provider of modular application development software for Microsoft's SharePoint® platform, has announced the release of the third version of the CorasWorks Data Integration Toolset for Microsoft® SharePoint.
CorasWorks Corporation, a leading provider of modular application development software for Microsoft's SharePoint® platform, has announced the release of the third version of the CorasWorks Data Integration Toolset for Microsoft® SharePoint.
