Skip to main content
Made title better match question body
Link
PolyGeo
  • 65.5k
  • 29
  • 115
  • 352

Is it possible to upgrade plain Enabling SQL Server 2008 database to esri SDEaccess it as Esri geodatabase invia ArcSDE using ArcGIS 10.0?

Put the original question back at the top. (The rest ought to be posted as an answer by the O.P.); Post Made Community Wiki
Source Link
whuber
  • 70.4k
  • 17
  • 189
  • 285

IMPORTANT: I'm playing with backup of customer's database on my machine. Never try to do anything like this quickly on production server without trying it in sandbox first. Use DB backups.

UPDATE: finally proved myself with your help that it's possible when playing with small databases. So final answer is YES.

Always - NO, sometimes you must fail fast.

Later I will check FAQ how to correctly "close a case" here.

I have 1 SQL Server 2008 and 1 Oracle database (did not check which version it is).

So, it possible at all with ArcGIS 10.0 to take a simple database and upgrade to geodatabase?is it possible at all with ArcGIS 10.0 to take a simple database and upgrade to geodatabase?

 

Update: Replaced our code with strategy OLEDb using best practices in the world.


IMPORTANT: I'm playing with backup of customer's database on my machine. Never try to do anything like this quickly on production server without trying it in sandbox first. Use DB backups.

UPDATE: finally proved myself with your help that it's possible when playing with small databases. So final answer is YES.

Always - NO, sometimes you must fail fast.

Later I will check FAQ how to correctly "close a case" here.

IMPORTANT: I'm playing with backup of customer's database on my machine. Never try to do anything like this quickly on production server without trying it in sandbox first. Use DB backups.

UPDATE: finally proved myself with your help that it's possible when playing with small databases. So final answer is YES.

Always - NO, sometimes you must fail fast.

Later I will check FAQ how to correctly "close a case" here.

I have 1 SQL Server 2008 and 1 Oracle database (did not check which version it is).

So, it possible at all with ArcGIS 10.0 to take a simple database and upgrade to geodatabase?

Update: Replaced our code with strategy OLEDb using best practices in the world.

I have 1 SQL Server 2008 and 1 Oracle database (did not check which version it is).

So, is it possible at all with ArcGIS 10.0 to take a simple database and upgrade to geodatabase?

 

Update: Replaced our code with strategy OLEDb using best practices in the world.


IMPORTANT: I'm playing with backup of customer's database on my machine. Never try to do anything like this quickly on production server without trying it in sandbox first. Use DB backups.

UPDATE: finally proved myself with your help that it's possible when playing with small databases. So final answer is YES.

Always - NO, sometimes you must fail fast.

Later I will check FAQ how to correctly "close a case" here.

added 133 characters in body
Source Link

UPDATE: finally proved myself with your help that it's possible when playing with small databases. So final answer is YES. Later

Always - NO, sometimes you must fail fast.

Later I will check FAQ how to correctly "close a case" here.

Update: SET ARITHABORT OFF did not work. Played with empty new database, once set it ON and then OFF. And in both cases result was OK. This means ARITHABORT doesn't matter. That's incorrect error message. Too many if-s in code.

Update: Replaced our code with strategy OLEDb using best practices in the world.

UPDATE: finally proved myself with your help that it's possible when playing with small databases. So final answer is YES. Later I will check FAQ how to correctly "close a case" here.

Update: SET ARITHABORT OFF did not work. Played with empty new database, once set it ON and then OFF. And in both cases result was OK. This means ARITHABORT doesn't matter. That's incorrect error message. Too many if-s in code.

UPDATE: finally proved myself with your help that it's possible when playing with small databases. So final answer is YES.

Always - NO, sometimes you must fail fast.

Later I will check FAQ how to correctly "close a case" here.

Update: SET ARITHABORT OFF did not work. Played with empty new database, once set it ON and then OFF. And in both cases result was OK. This means ARITHABORT doesn't matter. That's incorrect error message. Too many if-s in code.

Update: Replaced our code with strategy OLEDb using best practices in the world.

ARITHABORT doesn't matter
Source Link
Loading
Ran SQLServer2008R2_SetRequiredMagicForXML.sql
Source Link
Loading
Be careful with customers databases!!!
Source Link
Loading
added 904 characters in body
Source Link
Loading
Wrote "the answer is YES"
Source Link
Loading
deleted 206 characters in body
Source Link
Loading
added 992 characters in body
Source Link
Loading
added 149 characters in body
Source Link
Loading
added 561 characters in body
Source Link
Loading
Source Link
Loading