topic Will Migrate Storage break a replication? in Data Management Questions

Will Migrate Storage break a replication?

ChrisMathers — Wed, 19 Nov 2014 16:35:41 GMT

My feature classes geometry are a mix of SQL Geometry in some tables and SDE Binary in others. If I use Migrate Storage on all the feature classes on my production database from SDE Binary, will that break the replications I have going to other databases? Should I convert everything on my publication database to SQL Geometry as well and re-setup the replications?

Re: Will Migrate Storage break a replication?

JakeSkinner — Thu, 20 Nov 2014 13:30:55 GMT

Hi Chris,

Migrating the storage of your feature classes will not break the replication. As for whether you should migrate all of your feature classes to Geometry, I would test a feature class and compare the performance. In my current environment, I experience faster performance with SDE Binary. One reason you may want to migrate your data is if you need to access your spatial or raster data using structured query language (SQL)

Re: Will Migrate Storage break a replication?

ChrisMathers — Thu, 20 Nov 2014 16:21:54 GMT

We already have a blend of the two and I haven't seen any differences. The feature classes from the old db (9.3.1) that were migrated to the current db (10.1) are in SDE Binary but any we have created since are in SQL Geometry as that is the config keyword for our database and is the default at 10.1.