Home
>
Software
>
Microsoft Navision Database Selection: C/SIDE or MS SQL Server - Overview For IT Specialist

Microsoft Navision Database Selection: C/SIDE or MS SQL Server - Overview For IT Specialist

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

Benton shuttle to Midway .. Lockport Chicago limo O’Hare

In The News:

Just two months into 2025 there have been numerous Mac malware threats targeting Apple laptops, ranging from infostealers to malicious software.

A self-driving electric bus powered by artificial intelligence has an electric powertrain for zero-emission operation and an automated drive system.

SpaceX is slated to launch its Starship for the eighth time from Boca Chica, Texas, Friday, though plans could be thwarted if the FAA fails to give the green light.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

Kurt the CyberGuy offers tips on how you can protect your devices against infostealer malware, which was used to infect 4.3 million machines last year.

Motional is developing autonomous vehicles capable of handling a wide range of real-world scenarios. Its high-speed robotaxi testing reached speeds of 75 mph.

Kurt "CyberGuy" Knutsson explores whether there is artificial intelligence bias involved with the iPhone's voice-to-text conversion in the message app.

Apple's iPhone voice-to-text periodically flashes "Trump" when a user speaks the word "racist." Fox News Digital reached out to Apple about the flaw but did not hear back.

Tech expert Kurt “CyberGuy" Knutsson presents five secret shortcuts: Adjust sound/vibration, share YouTube moments, fix tabs and tweak brightness.

VR transforms senior care: Kurt “CyberGuy" Knutsson says immersive tech helps older adults explore and connect via virtual experiences.

Tech expert Kurt “CyberGuy" Knutsson says DNA tests pose privacy risks like shared genetic information, inaccuracies and hard data deletion.

Tech expert Kurt “CyberGuy" Knutsson says this enormous airship revolutionizes cargo transport by flying to remote areas.

Understanding the language of the internet can help you protect your personal information from bad actors. Kurt "CyberGuy" Knutsson explains.

Woven City is Toyota's experimental city that is a fully functional environment for people to live, work and play while doing research.

The line between spam and scams is thin. Kurt "CyberGuy" Knutsson details his tips for identifying and avoiding phone scams, robocalls and unwanted solicitations.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents

Kurt the CyberGuy takes you through the steps to easily set your preferred web browser whether you're using a Mac, Windows PC, iPhone or Android.

Google, Instagram, Facebook and weather apps can track your location and use that data to serve you ads; here's what you can do to protect your privacy.

A new debate has emerged about whether airlines should charge passengers based on their weight to help reduce fuel consumption and lower emissions.

Tech expert Kurt “CyberGuy" Knutsson says Hipshipper, which is used by eBay, Shopify and Amazon sellers, exposed millions of shipping labels.

Boxabl’s Baby Box is a 120-square-foot foldable home that can be set up in 60 minutes and has off-grid features. Kurt “CyberGuy" Knutsson says it's designed to maximize functionality.

Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.

Major IoT data breach: Mars Hydro database with 2.7 billion records exposed. Kurt “CyberGuy" Knutsson says the breach is a reminder of the risks that come with using IoT devices.

Unitree H1 robots dance at gala, blending AI and tradition. Tech expert Kurt “CyberGuy" Knutsson examines the convergence of cutting-edge technology and traditional culture.

For the first time ever, SpaceX launched a rocket into space from Florida and landed the booster the Bahamas, allowing for future polar-orbit spaceflight missions.

Microsoft Navision Database Selection: C/SIDE or MS SQL Server - Overview For IT Specialist

Software