The Paste Error says this "Failed to paste. The operation does not support this dataset type. [LRS data cannot be loaded by SDE or DBO.]."
Dear staff,
I've got the above error when trying to follow the instruction of lesson "Migrate an LRS to an enterprise geodatabase" The lesson first shows how to create an enterprise-geodatabase and then how to make a connection to the created db. I chose platform MSSQL, was able to create one and can make a connection to it via New Database Connection tool
The created MSSQL database is per field entries as follows: (resulted in a sde schema indeed)
However, I cannot get pass the subsequent steps, specifically step (4) :
From the Catalog pane, if necessary, expand the Winona_LRS feature dataset.
Hint:
Databases > CityOfWinona_LRS_Model.gdb > Winona_LRS
Right-click the Winona_LRS feature dataset and choose Copy.
Right-click the CityOfWinona_LRS_Production enterprise geodatabase and choose Paste Special. <= this is when the error popup occurs:
--------------------------------------------------------
(1) What am I missing?
--------------------------------------------------------
PS 1: I obviously want to achieve somthing like this
Unfortunately the lesson example only showcased PostgreSQL based geodatabase creation:
Therefore, I do not have matching instructions or references to look up against.
Right now the error message itself is kind of confusing also. Does it mean the MSSQL db admin cannot be a SDE type, nor DBO type? then why it would ask for credentials of such in the first place (such as the checkbox "SDE owned schema" appears in the Create Enterprise Geodatabase asking for password )
PS 2: I also tried to create a db-admin account where the username is "sde" so that it is identified (the same) with the schema name sde but that same Paste Error fires up again when I tried to paste the source LRS feature dataset into destination newly created "irs_training_4_sde" MSSQL database - as shown below. In this trial, the outcome was even worse, there were not any sde. schema based tables generated when it finished running the Create Enterprise Geodatabase, all I got is this:
----------------------------------------------------------------------------------------------------------------
(2) So the "production" MSSQL database which created through ESRI "Create Enterprise Geodatabase" doesn't accept to-be-migrated LRS feature dataset objects ever, does it? What set up procedure pertains to MSSQL platform I need to follow to void the Paste Error popup?
----------------------------------------------------------------------------------------------------------------
Thank you in advance for you help.