One-Way Replica Question

[TimHayes]

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.

[JakeSkinner]

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