?
Solved

DOT NET MSSQL and windows 2008 server

Posted on 2012-04-09
1
Medium Priority
?
420 Views
Last Modified: 2016-03-18
Dear Experts:

We are implementing the Sugar CRM for our business now that are going live .in this stage management has asked me to look for the ERP so that sugar crm to be integrated with the ERP,  based on our budget one of the vendor have given the near matching proposal almost we can go with them as they have agreed for the sugar crm interfacing with the ERP. sugar crm runs  on the linux  server LAMP. ERP is on windows platform with the below  prequistes :

1.Win2008 enterprise server
2.ms sql 2012 enterprise
3. Dot.Net v 2.0
4. Crystal components

can you please help me on the below points:

1.Dot.Net V2.0 can it be the one of the best choice of application.  I had asked them for the java but the deleoper says they have expertise in Dot.Net and this is does all the job , java not required.

Please suggest me can we go with the Dot.Net

2. developer says we need not procure Crystal reports application they will be installing the crystal components , first does crystal components be a good choice or asking better than this will be a better choice , please suggest,  also iam still confused whether license will be required for the crystal components.

3. Devloper says Windows 2008 STANDARD SERVER will be sufficient but MS SQL required is enterprise edition , please suggest is it recommended practice for windows 2008 enterprsie and MS SQL enterprsie as both will be of enterprise class.

Please help me with the above 03 points
0
Comment
Question by:D_wathi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 20

Accepted Solution

by:
Marten Rune earned 2000 total points
ID: 37826551
1.  .Dot Net is a good choise for application development. I would not care for Jave if it's note neccesary with cross platform application.

2. Crystal Reports is a de facto standard for creating reports for a variety of applications. It works as a database/Data reader, and then it takes it's query and out comes a formatted print. What you have to do is create these reports, i e whats the datasource, how should header and footer look like, a different header for the first page, different odd and even pages and so forth. This is the streangth of Crystal Reports.

3. Editions and versions. Yes thats a difficult one. I cant tell you what to use, but I can tell you what theyr'e fore. Starting with the OS. Enterprise is demanded if you plan to cluster your SQL or Application. Otherwise I would go with standard. The price difference isn't that huge, but it's still big enough to be considered. I don't thing you should buy enterprise windows as a default choice, rather standard as a default choice, and if needed choose enterprice when it's needed. Download comparison guide from here:
http://www.microsoft.com/en-us/server-cloud/windows-server/2008-r2-editions.aspx
and it'll help you choose.
SQL versions, ah thats more my turf. Well the enterprise has very good features, but if they are not used, standard should be the choice, unless a roadmap for the application states that a SQL Enterprise feature is going to be implementetd, such as partitioned tables, always on (demands Enterprise on the OS also since MSCS clustering is used). Comparision can be made from this link:
http://www.microsoft.com/sqlserver/en/us/sql-2012-editions.aspx
Ask what features demand the Enterprise flavour of SQL Server, and then you can choose. Observe that the price difference between the editions is quite big. So choosing the right licensing and version is well worth its time.

Yes licensing, I generally dont advice, but basically it comes down to how many are benefitting/using the system. For example if you have a system for doorpassage. Every employee has a accesscard, and one adminstrator administers the door system. One could argue that its only one user against the database. The way Microsoft sees it is that every cardholder is a database user, and should be licenced. And when you start to think about it their way of reasoning is logical. Now in your case look at how many users will use the system. Then you can look att licensing and its flavours.
Licensing information here: http://www.microsoft.com/sqlserver/en/us/get-sql-server/licensing.aspx

Regards Marten
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question