Hi Guys and Hi Hal,

 I know one thing for the fact that a SQL server works like a Back end if someone is working on a .Net Project to retreive Data. But if a SQL SERVER is used to retreive Data in .Net. Then what is a Biz Talk server or for that matter any of the Microsoft servers used for what is the Major difference in a SQL Server and a Microsoft server like a Biz Talk server or a Microsoft server. Hal this is a question for u also I have just got in to learning the .Net Technology so can u plz explain me here in vetry simple Terms without using a Lot of Jargons what is actually a SQL server, what role does it play in a .Net Technology,what is it used for and how is it different from any of the microsoft server.

 Augustine

AUgustine- Every server or software package has a different usage.

Windows server is the OS.
SQL server is a Database server.
BiZ Talk supports communication between applications. Often called machine to machine communication.
there are many other software server packages..

NONE of these have anything to do with .NET...

.NET is a development language specification.

Have you read any of the WROX books on the subject?



Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

Hal,

can u suggest me the name of those Books that u r Talkin about.

Augustine

Which books depends on which part you want to learn.

You might want to start with .NET Framework (Which is now an APRESS Book) which gives a good background of what .NET is and what .NET isn't. You can go to http://www.apress.com and search for it there.

From the WROX perspective you should look at Begininning ASP.NET 1.1 (in the language of your choice, C# or VB). You should also go to the various sites on microsoft. http://www.microsoft.com and http://msdn.microsoft.com and read about the technologies.

You seem to be very confused at the basic definitions of what is what- the best thing to do is look at microsofts site to understand each product and where it fits in the puzzle.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

Augustin,

Greetings in the name of Lord Jesus christ.

Friend,

Today only i have seen the message posted by you. I hope you may have received good answer for your question from this forum or you have to find a good answer to this question by your own. If you have received any thing please post it here for others to get benefit. If you have not get answer till today the answer has as follows.

Sql server is using for database

Biztalk server is an integration tool. During installation of biztalk in your machine (Biztalk 2002) the biztalk itself create 4 default databases in your machine.
They are as follows
1. Interchange BTM,
   helps you to keeps track of configuration details made in the messaging services in biztalk server.
2. Interchange DTA,
   helps you to keeps track of messages that have been processed by biztalk server.
3. Shared Queue database,
   helps you to keeps track of messages that that required for processing by biztalk server
4. Xlang database,
   Used to maintain the state of Orchestration instances used by Xlang Scheduler.

all the above said db are created in Sql server alone. These information is for Biztalk 2002 not for Biz talk server 2004

If you need any more help please keep in touch with me to the following mail ID

[email protected]

with regards

Lawrence