Changing Database Name in Geospatial Administrator possible?

Hi all,

I have setting up our project in Geospatial Administrator using an Oracle database which currently working now, but the database administrator adviced the GIS Dept to transfer to another database. What shall we do for us to use the same project schema with another database?

 

thanks

Jun

Parents
  • In the XML file there is a database tag.

    Example for a ODBC connection :

       <Database type="ODBC" name="eastcity1" genFile="database.xml">

         <Tables>

           <Table name="intersect">

    And for a Oracle connection :

      <Database type="Oracle" name="geoCimOra11" genFile="database.xml">

         <Tables>

           <Table name="ns_milepost">

    Change the name there. Make sure you backup the original before making these edit changes.

    Also make sure you do a update on the Database node, in the GSA, just to make sure you have made the change correctly.

    HTH

    Jerry

     

Reply
  • In the XML file there is a database tag.

    Example for a ODBC connection :

       <Database type="ODBC" name="eastcity1" genFile="database.xml">

         <Tables>

           <Table name="intersect">

    And for a Oracle connection :

      <Database type="Oracle" name="geoCimOra11" genFile="database.xml">

         <Tables>

           <Table name="ns_milepost">

    Change the name there. Make sure you backup the original before making these edit changes.

    Also make sure you do a update on the Database node, in the GSA, just to make sure you have made the change correctly.

    HTH

    Jerry

     

Children