Migrating to a new geodatabase

Question

We currently use SDE with versioned editing. Our installation was done several years ago. I know that there have been many changes and performance enhancements since that time and some of the suggested installation parameters may have changed. I am thinking of creating a new geodatabase and transferring our existing data to it. My question is, is there a way to migrate users without having to manually create new connections, repair map data sources, etc.?

NICOLAPEDDIS · Answer

Asrujit is right. You can upgrade your sde geoDB if you are upgrading sqlserver from the 2008 to the 2012 or 2014 without rename it. Then use arccatalog and upgrade the DB, if you have changed arcgis version.

AsrujitSengupta · Answer

Something to keep in mind--

If its the same instance, you can't have the new sde gdb use the same name, because:

- you can't have two databases with the same name on one SQL Server instance

- you can't rename an existing sde gdb and connect to it from ArcCatalog

collindegueurce · Answer

SQL Server. Same instance. Thanks for the link!