We were using Schema Compare version 4.2.35, but needed to upgrade when we installed a SQL Server 2017 instance.
One of the Source servers has read_only databases, but this has never been a problem during synchronization as this property was ignored. After the upgrade the target databases are in read_only. How do I ignore this database property during compare so it is not included in the synchronization script?
Synchronized Databases are in read_only after upgrade
-
- Posts: 4
- Joined: Mon 29 Jul 2019 18:26
-
- Posts: 4
- Joined: Mon 29 Jul 2019 18:26
Re: Synchronized Databases are in read_only after upgrade
Based on the description of the "Compare database properties" Common option, the switch doesn't even matter??
Is this correct?
If I'm reading this, the option's setting doesn't really matter; the database properties object WILL be synchronized, period.When selected, a database object is included in comparison and synchronization. Note a database object will be synchronized even if the Compare database properties option is turned off, in case the database object is dependent on other objects that are selected for synchronization.
Is this correct?
Re: Synchronized Databases are in read_only after upgrade
Please try using the 'Compare database properties' option on the 'Options' page of the schema comparison wizard

