 WebProWorld
Dev Forum |
Relational Tables in MySQL
I have three MySQL tables in a database and they are supposed to be of a one-to-one relationship, such that each record in each table is unique, and each line in all three tables are for the same record ...
Advice on DB Setup
I am working on setting up a new database driven site using PHP and MySQL. ...
|
|
|
|
Recent Articles |
Microsoft Great Plains – SQL Querying Trivia
This is beginner level SQL scripting article for DB Administrator, Programmer, IT Specialist.
Oracle Sets World Record
Oracle announced a world record 2-processor benchmark on Linux that placed Oracle Database 10g Standard Edition One (Oracle Standard Edition One) in the coveted Top Ten TPC-C by Price-Performance category. This record benchmark is the best price-performance ever on a 2-processor system, proving Oracle's ability to deliver exceptional performance and value on low-end servers.
MySQL Partner Program Continues to Grow
MySQL AB has signed a Value-Added Reseller (VAR) agreement with GoldenGate Software who will become a Certified ISV Partner for MySQL.
Oracle and Dell Announce Oracle Database 10g Standard Edition
Solution Makes it Easier, Faster and More Cost-Effective to Use Leading Database. |
|
|
|
10.11.04
Microsoft Navision Database: C/SIDE Or MS SQL Server
 By Robert Horowitz
Microsoft Business Solutions promotes Navision (former Attain) on US market as excellent manufacturing applications (formerly it was promoting Great Plains).
Navision is available on its native (solid rock and recommended databse) and Microsoft SQL Server. You should consider several factors in deciding on the database selection. Currently Navision is supported on two platforms - Navision native (C/SIDE) database and on Microsoft SQL Server. 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.
Hosted service tracks 100's of real-time website statistics
- 30 Day Trial |
|
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
About the Author:
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 |
