How can we help you today? How can we help you today?
Andy_PS
Activity overview Badges (0) Posts (3) Comments (7)

Comments

Sort by recent activity
That seemed to work fine and seems to be the last of the problems [image] (for now [image] ) Here's my final code #region SynchroniseSchema public static void SynchroniseSchema(string server, string database, string snapshotPath) { ConnectionProperties connectionProperties = new ConnectionProperties(server, database); //AJ: Fudge for problem with Extended Properties SynchroniseSchemaExcludingExtendedProperties(connectionProperties, snapshotPath); SynchroniseSchema(connectionProperties, snapshotPath); } public static void SynchroniseSchema(string server, string database, string username, string password, string snapshotPath) { ConnectionProperties connectionProperties = new ConnectionProperties(server, database, username, password); //AJ: Fudge for problem with Extended Properties SynchroniseSchemaExcludingExtendedProperties(connectionProperties, snapshotPath); SynchroniseSchema(connectionProperties, snapshotPath); } private static void SynchroniseSchema(ConnectionProperties liveConnectionProperties, string snapshotPath) { Database liveDatabase = new Database(); liveDatabase.Register(liveConnectionProperties, Options.Default); Database snapshotDatabase = new Database(); snapshotDatabase.LoadFromDisk(snapshotPath); Differences differences = liveDatabase.CompareWith(snapshotDatabase, Options.Default); foreach (Difference difference in differences) { difference.Selected = true; } Work work = new Work(); work.BuildFromDifferences(differences, Options.Default, false); ExecutionBlock executionBlock = work.ExecutionBlock; BlockExecutor blockExecutor = new BlockExecutor(); blockExecutor.ExecuteBlock(executionBlock, liveDatabase.ConnectionProperties.ServerName, liveDatabase.ConnectionProperties.DatabaseName, liveDatabase.ConnectionProperties.IntegratedSecurity, liveDatabase.ConnectionProperties.UserName, liveDatabase.ConnectionProperties.Password); } //AJ: Fudge for problem with Extended Properties //AJ: To solve the problem use a 2 pass approach, //AJ: first without Extended Properties and then with. //AJ: http://www.red-gate.com/MessageBoard/viewtopic.php?t=4433 private static void SynchroniseSchemaExcludingExtendedProperties(ConnectionProperties liveConnectionProperties, string snapshotPath) { Database liveDatabase = new Database(); liveDatabase.Register(liveConnectionProperties, Options.Default | Options.IgnoreExtendedProperties); Database snapshotDatabase = new Database(); snapshotDatabase.LoadFromDisk(snapshotPath); Differences differences = liveDatabase.CompareWith(snapshotDatabase, Options.Default | Options.IgnoreExtendedProperties); foreach (Difference difference in differences) { difference.Selected = true; } Work work = new Work(); work.BuildFromDifferences(differences, Options.Default | Options.IgnoreExtendedProperties, false); ExecutionBlock executionBlock = work.ExecutionBlock; BlockExecutor blockExecutor = new BlockExecutor(); blockExecutor.ExecuteBlock(executionBlock, liveDatabase.ConnectionProperties.ServerName, liveDatabase.ConnectionProperties.DatabaseName, liveDatabase.ConnectionProperties.IntegratedSecurity, liveDatabase.ConnectionProperties.UserName, liveDatabase.ConnectionProperties.Password); } #endregion I could have put the fudge into the 'SynchroniseSchema' method to bring everything into a more oop style, but in this case I decided to keep the fudge separate so it's easy to see what needs changing when the issue is fixed. Thanks for all your help [image] You've been very speedy and hit the mark every time with the problems I've had [image] / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Property cannot be updated or deleted
That seemed to work fine and seems to be the last of the problems (for now ) Here's my final code #region SynchroniseSchema public static void SynchroniseSchema(string server,...
0 votes
Unfortunatly we use extended properties to provide meta data to the DAL. I'll try the 2 pass approach, since it'll only be done during an update the extended time needed shouldn't be too much of a concern [image] / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Property cannot be updated or deleted
Unfortunatly we use extended properties to provide meta data to the DAL. I'll try the 2 pass approach, since it'll only be done during an update the extended time needed shouldn't be too much of a ...
0 votes
We're using it to make any needed schema changes when we update. It seems like a good way of updating any version to any version. We take a snapshot of the latest database schema and then run the compare against that and the live database. It saves having to script all the changes by hand. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Property cannot be updated or deleted
We're using it to make any needed schema changes when we update. It seems like a good way of updating any version to any version. We take a snapshot of the latest database schema and then run the c...
0 votes
Yep its trying to alter the extended properties. Altering extended properties Msg 15217, Level 16, State 2, Procedure sp_updateextendedproperty, Line 36 Property cannot be updated or deleted. Property 'SqlAssemblyFileLine' does not exist for 'dbo.up_CLR_RotaAppointmentTransfer'. (1 row(s) affected) Creating extended properties Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 37 Property cannot be added. Property 'AutoDeployed' already exists for 'PremierSoftware.SqlServer.BusinessData'. (1 row(s) affected) Msg 15233, Level 16, State 1, Procedure sp_addextendedproperty, Line 37 Property cannot be added. Property 'SqlAssemblyProjectRoot' already exists for 'PremierSoftware.SqlServer.BusinessData'. (1 row(s) affected) The database update failed Is there any current work arounds? / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Property cannot be updated or deleted
Yep its trying to alter the extended properties.Altering extended properties Msg 15217, Level 16, State 2, Procedure sp_updateextendedproperty, Line 36 Property cannot be updated or deleted. Proper...
0 votes
Yup that sorted that one [image] For the record would you prefer me to keep it as 1 problem per thread? or post any other problems i come up against on this thread? / comments
  1. Community
  2. SQL Compare Previous Versions
  3. DROP ASSEMBLY failed
Yup that sorted that one For the record would you prefer me to keep it as 1 problem per thread? or post any other problems i come up against on this thread?
0 votes
Yes I am (using the same code). Yes I do (though in this case it was the correct assumption [image] ) And that sounds spot on ... I shall swap Options.None to Options.Default and give it a blast! / comments
  1. Community
  2. SQL Compare Previous Versions
  3. DROP ASSEMBLY failed
Yes I am (using the same code). Yes I do (though in this case it was the correct assumption ) And that sounds spot on ... I shall swap Options.None to Options.Default and give it a blast!
0 votes
Yep your right! Not sure how that slipped in X( Well spotted and many thanks [image] / comments
  1. Community
  2. SQL Compare Previous Versions
  3. "Object reference not set to an instance of an object."
Yep your right! Not sure how that slipped in X( Well spotted and many thanks
0 votes
Total activity
13
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
3