I'm looking to improve my GIS capabilities within ArcGIS for Desktop environment: I want to work with real geodatabase that is stored on a Microsoft SQL Server (SQLEXPRESS) and to have all abilities that are available when working on a File Geodatabase - that is: querying, editing, topology, relationship class and so on. Above that I want also to be able to use the Geodatabase Replication capabilities, i.e. working with a copy of the geodatabase and then syncing it in to the original geodatabase.
Is it possible to do so only having ArcGIS for Desktop Standard licence?
I've got a bit confused by ESRI documentation that mentions constantly that this ability is granted for this level of licencing but on the other hand requires a keycodes file that is granted when authorizing ArcGIS for Server Enterprise (!).
Standard licence example:
Within ArcGIS for Desktop Standard and Advanced, the ArcCatalog application provides the ability for you to fully administer and manage enterprise geodatabases using SQL Server Express. This provides full enterprise geodatabase capabilities for up to a few users at a time. You set up and manage these enterprise geodatabases within ArcCatalog or the Catalog window. No extra software or database administration expertise is required.
Contradicting ArcGIS for Server example:
In order to achieve my goal I've did the following steps: (1) Installing Microsoft SQL Server 2012 SP1 (64-bit). (2) Installing the latest SQL Server Management Studio. (3) Installing the SQL Server Native Client downloaded from My Esri site.
I've succeed the following steps: (1) Connecting to the database server through ArcMAP's ArcCATLOG window. (2) Connecting to a pre-self-made database in the SQL Server. (3) Creating and importing feature classes. (4) Viewing and querying those feature classes.
I haven't succeed the following: (1) Creating new geodatabase within the database server nor using ArcMAPS's GUI nor using the GP tool. (2) Enabling geodatabase in this database. (3) Editing features within those feature classes.
It would be very helpful for me if you can resolve my main question and if the answer is true to point out what I've did wrong.