pasterpreview.blogg.se

Microsoft sql server client statistics tiers
Microsoft sql server client statistics tiers





microsoft sql server client statistics tiers

c) Database Server Install a version of SQL Server other than SQL Server Compact to act as the server database. I have used the same development machine for middle tier so I did not have to install it again. Install sync services on this machine too. SQL Server Compact is available in three ways: - Integrated with SQL Server 2008 or later versions, Integrated with Microsoft Visual Studio 2008 or later versions and as a download from the Web site at: sqlserver/2005/en/us/compact-downloads.aspx b) Middle tier If you want to use a separated middle tier server for IIS to run WCF service then make sure you have IIS installed and configured on this box to run WCF. You can also download it from Install SQL Server Compact 3.5 Service Pack 1 on this client machine if it is already not there. Sync Services for ADO.NET version 2.0 comes with Microsoft Sync Framework 1.0 which gets installed if you install SQL Server 2008 or Visual studio 2008, SP1.

microsoft sql server client statistics tiers

Install sync services on this client machine. We will use Visual Studio 2008, SP1, so it should be installed on this machine.

microsoft sql server client statistics tiers

a) Client tier We will develop the application (client and WCF service) and run the client part of the application in this machine. If you like, you can use the same development box for IIS and database server too. Preparing Environment: We need a development machine that we will use to develop the application, a middle tier server where IIS is installed and configured for WCF services and database server. In this blog we will use IIS and setup N-tier configuration of sync service for ADO.NET version 2.0 which comes as part of Microsoft Sync Framework 1.0. Recently I have worked on couple of cases where customers were trying to use N-tier configuration of Sync services for ADO.NET on IIS.







Microsoft sql server client statistics tiers