One-Way Replica Question

TimHayes — Mon, 28 Jan 2013 16:38:54 GMT

I am using SQL Server Express 2008 R2 with ArcGIS 10.1 (Desktop, Server, and SDE).

What is the recommended approach to create a One-Way Replica:

File Geodatabase? I plan on connecting my Flex Map Viewer to the One-Way Replica. The data in the Flex Map Viewer is derived from a series of MXDs which would be connected to the One-Way Replica File Geodatabase.

OR

SDE Geodatabase? Should I create a One-Way Replica SDE Geodatbase. However, I only have one instance of SQL Server, which can have multiple databases in it. Would you recommend I create a new geodatabase for housing the replica data?

I have heard using a File Geodatabase with a One-Way Replica is the best approach. Just want to get the opinions of others.

Re: One-Way Replica Question

JakeSkinner — Mon, 28 Jan 2013 18:27:05 GMT

Hi Timothy,

I recommend a File Geodatabase unless you need to edit feature classes with your web application. At that point you need a feature service, and a feature service requires the data to exist in an SDE geodatabase.

Benefits of using a File Geodatabase:

1. Public applications are not directly accessing your SDE geodatabase
2. With SQL Server Express (Workgroup edition) you are limited to 10 connections. You will not be using a connection(s) with the published service
3. File Geodatabases can yield faster performance

topic Re: One-Way Replica Question in Data Management Questions

One-Way Replica Question

Re: One-Way Replica Question