Updating production ArcSDE database from staging? Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Using SQL Server Spatial without ArcSDE?Create ArcSDE Database from ArcCatalogArcSDE & Oracle & Database Model — Best diagram the systemAccess Feature Classes on Multiple Database Schemas with ArcSDERegistering SQL Spatial View in ArcSDE and updating Row_ID?ArcSDE Database Refactoring Tools?Deleting SQL Server database in order to delete ArcSDE geodatabase?Using CURRENT_DATE function on ArcSDE SQL Server Database?Loading layer from ArcSDE for SQL Server Database using PyQGIS?Adding database connection to ArcSDE database?Syncing database with ArcMap and ArcSDE?
Why is a lens darker than other ones when applying the same settings?
What order were files/directories output in dir?
How were pictures turned from film to a big picture in a picture frame before digital scanning?
Is it possible for an event A to be independent from event B, but not the other way around?
What are the main differences between the original Stargate SG-1 and the Final Cut edition?
Tannaka duality for semisimple groups
Is multiple magic items in one inherently imbalanced?
One-one communication
Nose gear failure in single prop aircraft: belly landing or nose-gear up landing?
Why does electrolysis of aqueous concentrated sodium bromide produce bromine at the anode?
How to change the tick of the color bar legend to black
Random body shuffle every night—can we still function?
Where did this useful matrix decomposition come from for Nodal Analysis?
Putting class ranking in CV, but against dept guidelines
How can I save and copy a screenhot at the same time?
What does it mean that physics no longer uses mechanical models to describe phenomena?
What is the "studentd" process?
A term for a woman complaining about things/begging in a cute/childish way
Printing attributes of selection in ArcPy?
Why do early math courses focus on the cross sections of a cone and not on other 3D objects?
Mounting TV on a weird wall that has some material between the drywall and stud
Did any compiler fully use 80-bit floating point?
How does light 'choose' between wave and particle behaviour?
Relating to the President and obstruction, were Mueller's conclusions preordained?
Updating production ArcSDE database from staging?
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
Announcing the arrival of Valued Associate #679: Cesar Manara
Unicorn Meta Zoo #1: Why another podcast?Using SQL Server Spatial without ArcSDE?Create ArcSDE Database from ArcCatalogArcSDE & Oracle & Database Model — Best diagram the systemAccess Feature Classes on Multiple Database Schemas with ArcSDERegistering SQL Spatial View in ArcSDE and updating Row_ID?ArcSDE Database Refactoring Tools?Deleting SQL Server database in order to delete ArcSDE geodatabase?Using CURRENT_DATE function on ArcSDE SQL Server Database?Loading layer from ArcSDE for SQL Server Database using PyQGIS?Adding database connection to ArcSDE database?Syncing database with ArcMap and ArcSDE?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
We have development, staging and production instances of the same ArcSDE database, similar to this ancient thread from the ArcGIS Discussion Forums.
Our development to staging deployment employs lots of schema changes with exclusive locks that involve dropping tables and recreating them. Our schema itself is pretty fluid as we are always adding new data to it.
Our staging database is an exact copy of what we want our production database to be.
How do I deploy our staging ArcSDE instance to production while minimizing or eliminating downtime?
We use SQL Server 2012.
arcgis-desktop enterprise-geodatabase sql-server
edited Apr 12 at 9:46
PolyGeo♦
54.1k1782246
asked Jan 27 '15 at 16:35
ConorConor
2,63511143
add a comment |
We have development, staging and production instances of the same ArcSDE database, similar to this ancient thread from the ArcGIS Discussion Forums.
Our development to staging deployment employs lots of schema changes with exclusive locks that involve dropping tables and recreating them. Our schema itself is pretty fluid as we are always adding new data to it.
Our staging database is an exact copy of what we want our production database to be.
How do I deploy our staging ArcSDE instance to production while minimizing or eliminating downtime?
We use SQL Server 2012.
arcgis-desktop enterprise-geodatabase sql-server
edited Apr 12 at 9:46
PolyGeo♦
54.1k1782246
asked Jan 27 '15 at 16:35
ConorConor
2,63511143
add a comment |
We have development, staging and production instances of the same ArcSDE database, similar to this ancient thread from the ArcGIS Discussion Forums.
Our development to staging deployment employs lots of schema changes with exclusive locks that involve dropping tables and recreating them. Our schema itself is pretty fluid as we are always adding new data to it.
Our staging database is an exact copy of what we want our production database to be.
How do I deploy our staging ArcSDE instance to production while minimizing or eliminating downtime?
We use SQL Server 2012.
arcgis-desktop enterprise-geodatabase sql-server
edited Apr 12 at 9:46
PolyGeo♦
54.1k1782246
asked Jan 27 '15 at 16:35
ConorConor
2,63511143
We have development, staging and production instances of the same ArcSDE database, similar to this ancient thread from the ArcGIS Discussion Forums.
Our development to staging deployment employs lots of schema changes with exclusive locks that involve dropping tables and recreating them. Our schema itself is pretty fluid as we are always adding new data to it.
Our staging database is an exact copy of what we want our production database to be.
How do I deploy our staging ArcSDE instance to production while minimizing or eliminating downtime?
We use SQL Server 2012.
arcgis-desktop enterprise-geodatabase sql-server
arcgis-desktop enterprise-geodatabase sql-server
edited Apr 12 at 9:46
PolyGeo♦
54.1k1782246
asked Jan 27 '15 at 16:35
ConorConor
2,63511143
edited Apr 12 at 9:46
PolyGeo♦
54.1k1782246
asked Jan 27 '15 at 16:35
ConorConor
2,63511143
edited Apr 12 at 9:46
PolyGeo♦
54.1k1782246
edited Apr 12 at 9:46
PolyGeo♦
54.1k1782246
edited Apr 12 at 9:46
PolyGeo♦
54.1k1782246
54.1k1782246
asked Jan 27 '15 at 16:35
ConorConor
2,63511143
asked Jan 27 '15 at 16:35
ConorConor
2,63511143
asked Jan 27 '15 at 16:35
ConorConor
2,63511143
2,63511143
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
We use FME Workbench via the ArcGIS Data Interoperability Extension, which comes with our ESRI Enterprise License Agreement.
Using FME gives us the ability to:
- Promote from Dev to QA to Prod instances of ArcGIS
- Ensure Field names and Field Types are consistent between environments
- Provide an accessible tool for our non-GIS-using DBA to run an ETL to our production environment by embedding an FME tool into a Model Builder model
- Translate between SDE features classes and Native SQL Spatial
- Incorporate FME ETL processes into Python Scripts for automation
When we originally spoke to ArcGIS tech support regarding this same issue, we were told to 'copy and paste' between SDE geodatabases. This was not the workflow we wanted...
answered Jan 27 '15 at 16:46
DPSSpatialDPSSpatial
12.1k14281
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f131977%2fupdating-production-arcsde-database-from-staging%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
We use FME Workbench via the ArcGIS Data Interoperability Extension, which comes with our ESRI Enterprise License Agreement.
Using FME gives us the ability to:
- Promote from Dev to QA to Prod instances of ArcGIS
- Ensure Field names and Field Types are consistent between environments
- Provide an accessible tool for our non-GIS-using DBA to run an ETL to our production environment by embedding an FME tool into a Model Builder model
- Translate between SDE features classes and Native SQL Spatial
- Incorporate FME ETL processes into Python Scripts for automation
When we originally spoke to ArcGIS tech support regarding this same issue, we were told to 'copy and paste' between SDE geodatabases. This was not the workflow we wanted...
answered Jan 27 '15 at 16:46
DPSSpatialDPSSpatial
12.1k14281
add a comment |
We use FME Workbench via the ArcGIS Data Interoperability Extension, which comes with our ESRI Enterprise License Agreement.
Using FME gives us the ability to:
- Promote from Dev to QA to Prod instances of ArcGIS
- Ensure Field names and Field Types are consistent between environments
- Provide an accessible tool for our non-GIS-using DBA to run an ETL to our production environment by embedding an FME tool into a Model Builder model
- Translate between SDE features classes and Native SQL Spatial
- Incorporate FME ETL processes into Python Scripts for automation
When we originally spoke to ArcGIS tech support regarding this same issue, we were told to 'copy and paste' between SDE geodatabases. This was not the workflow we wanted...
answered Jan 27 '15 at 16:46
DPSSpatialDPSSpatial
12.1k14281
add a comment |
We use FME Workbench via the ArcGIS Data Interoperability Extension, which comes with our ESRI Enterprise License Agreement.
Using FME gives us the ability to:
- Promote from Dev to QA to Prod instances of ArcGIS
- Ensure Field names and Field Types are consistent between environments
- Provide an accessible tool for our non-GIS-using DBA to run an ETL to our production environment by embedding an FME tool into a Model Builder model
- Translate between SDE features classes and Native SQL Spatial
- Incorporate FME ETL processes into Python Scripts for automation
When we originally spoke to ArcGIS tech support regarding this same issue, we were told to 'copy and paste' between SDE geodatabases. This was not the workflow we wanted...
answered Jan 27 '15 at 16:46
DPSSpatialDPSSpatial
12.1k14281
We use FME Workbench via the ArcGIS Data Interoperability Extension, which comes with our ESRI Enterprise License Agreement.
Using FME gives us the ability to:
- Promote from Dev to QA to Prod instances of ArcGIS
- Ensure Field names and Field Types are consistent between environments
- Provide an accessible tool for our non-GIS-using DBA to run an ETL to our production environment by embedding an FME tool into a Model Builder model
- Translate between SDE features classes and Native SQL Spatial
- Incorporate FME ETL processes into Python Scripts for automation
When we originally spoke to ArcGIS tech support regarding this same issue, we were told to 'copy and paste' between SDE geodatabases. This was not the workflow we wanted...
answered Jan 27 '15 at 16:46
DPSSpatialDPSSpatial
12.1k14281
answered Jan 27 '15 at 16:46
DPSSpatialDPSSpatial
12.1k14281
answered Jan 27 '15 at 16:46
DPSSpatialDPSSpatial
12.1k14281
answered Jan 27 '15 at 16:46
DPSSpatialDPSSpatial
12.1k14281
12.1k14281
add a comment |
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f131977%2fupdating-production-arcsde-database-from-staging%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
