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! [email protected]

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: [email protected]

In The News:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at https://news.google.com/news

Forbes

Hard Questions Raised When A Software 'Glitch' Takes Down An Airliner
Forbes
Defects in software code – strings of numbers and letters – can do it too. Late last month, a Lion Air Boeing 737 Max 8 jetliner crashed into the Java Sea off Indonesia, killing all 189 passengers and crew, due to what investigators described as a ...


Opinion: How old-school manufacturers can reinvent themselves and beat back the software giants
MarketWatch
The software giants start with enormous technological momentum. Nearly all innovation in physical goods now requires a heavy dose of software. The Internet of Things, cloud computing, big data analytics and artificial intelligence are coming together ...


Business Insider

Wall Street thinks these 5 public software companies could get acquired in mega-deals amid the market downturn
Business Insider
"While the list of public software company acquisitions has been relatively short," Berg wrote, "the aggregate valuations have been at a premium level that we consider to be at the upper end of historical ranges." Now with the stock market in a ...

and more »

Forbes

The Good Software Company With The Scary Stock
Forbes
The first story is about publicly traded Autodesk, which sells nifty software for the design of parts and buildings. Engineers are addicted. Does that make it a guaranteed annuity? Consider these addictive products of the past: Netscape, Novell's ...


Harvard Business Review

How Software Is Helping Big Companies Dominate
Harvard Business Review
Even outside of the tech sector, the employment of more software developers is associated with a greater increase in industry concentration, and this relationship appears to be causal. Similarly, researchers at the OECD have found that markups — a ...


Forbes

Software Composition Analysis Startups: Investors Are Looking For These Three Qualities
Forbes
Given these impressive injections of capital into the software composition analysis market, some young entrepreneurs may see an opportunity to break into SCA with their own solutions. However, with all the competition from established players, these ...


Forbes

How A Mysterious Tech Billionaire Created Two Fortunes—And A Global Software Sweatshop
Forbes
rom an office suite on the 26th floor of the iconic Frost Bank Tower in Austin, Texas, a little-known recruiting firm called Crossover is searching the globe for software engineers. Crossover is looking for anyone who can commit to a 40- or 50-hour ...


Economic Times

Facebook says outage was due to a server software problem
Economic Times
WASHINGTON D.C. [USA]: Facebook said Tuesday users had trouble accessing the social network and its other applications such as Instagram for a chunk of the day due to a server software problem. It was the second instance in the past two weeks in which ...

and more »

ZDNet

Autodesk to acquire construction software firm PlanGrid
ZDNet
Autodesk on Tuesday announced plans to acquire the construction software firm PlanGrid for $875 million net of cash. The deal is Autodesk's largest acquisition to date. PlanGrid's software helps general contractors, subcontractors and owners in ...
Autodesk snaps up SF construction planning software company in $875 million dealSan Francisco Business Times
Autodesk acquires construction productivity cloud software startup PlanGrid for $875 millionSiliconANGLE News
Autodesk to Acquire Construction Productivity Software Provider PlanGridForConstructionPros.com

all 41 news articles »

American Inno

The Big One
American Inno
Is Software Different Than Tennis Shoes? If you inside that new pair of Nikes, you'll probably find they were made in China. And, if look at the back of your smart phone, it might tell you it was designed in the U.S. and assembled in China. Many of us ...

Google News

Anti-Virus Software

Anti-virus software is used to find, remove or fix files... Read More

The XP Firewall Isnt Enough

You might think you don't need a firewall... Read More

A Time-Saving Programming Tactic that Doesn?t Work

Let's say that you have a software project that's under... Read More

Microsoft Great Plains: Government & Non-Profit Organization ? Workflow Implementation

Usually workflow & messaging is realized in CRM and then... Read More

Microsoft Great Plains Distribution, Barcoding, Consignment ? overview for consultant

Microsoft Great Plains ? ERM from Microsoft Business Solutions and... Read More

ERP Consulting: Microsoft Great Plains Partner Future Directions

In the Clinton era the status quo was simple: you... Read More

Things You Can Do With Windows XP!

Did you ever give a thought to the number of... Read More

Microsoft Great Plains RW: Report Writer

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Microsoft Great Plains Customization and Development ? Overview for Programmer

When Great Plains Software was designing and developing Great Plains... Read More

HSphere Control Panel Tips and Tricks - Power At Your Fingertips: Part 1

The first topic we are going to discuss... Read More

Getting Technical Support Help Online

Sometimes your PC will start acting strange for no apparent... Read More

Basic Steps To Optimize Your Internet Security

After seeing many people complain about their weak Internet security... Read More

Microsoft CRM and No-Frills Cadillacs

In today's business world it's all but impossible to escape... Read More

Should I Use Windows Update?

Should one use Windows Update?This topic has good and valid... Read More

Great Plains Dexterity ? Microsoft Great Plains Customization Overview

Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More

Run Your Own Search Engine

Our hosted solution allow you to run your own search... Read More

Separate Anti-Keylogging Protection: Who Needs it Most?

If there still are few unprotected computers left, I haven't... Read More

Microsoft Great Plains Implementation in Russia ? Overview for Consultant

Microsoft Business Solutions Great Plains is very popular ERP platform... Read More

Microsoft CRM for Large Corporation ? Security

Microsoft Business Solutions CRM proved to be reliable solution in... Read More

10 Programming Tips

(1) Avoid using the same variable again and again for... Read More

Lowering The Risks In Developing Do-It-Yourself Software Projects

Mike Dunville* had a decision to make. As the new... Read More

Microsoft Great Plains version 8.5: Upgrade, Customization, VBA, Crystal Reports - Highlights

Microsoft Great Plains is one of the Microsoft Business Solutions... Read More

Software Process Improvement -A Successful Journey

Background: For many organizations like ours, the interim target of... Read More

Microsoft Great Plains FA: Fixed Assets ? Overview For Consultant

Great Plains Fixed Assets Management module is a robust tool... Read More

Professional Software Icons For Your Standalone Application

User interfaces and accessibility are some of the most important... Read More