Giving “hints” to Sql Compare

• 

  inneedofspeed wrote:

  We often rename tables or columns and then need at a later time to produce database upgrade scripts. To do this, we get the schema creation sql scripts from subversion for both versions of the database, create two databases and compare them. However SQL compare only sees that oldName has been removed and newName has been created, it would be great if we could give it the hint that a “rename†was in fact done.
  
  For ever table we create “by hand†we have 2 other tables (for auditing etc) that we create the “table creation sql†automatically as part of our build process, so we can’t just use the sql server rename command.

  
  
  Hi,
  
  in the long term we will be looking at object level mapping, but at the moment we are not supporting table alters that have different names.
  
  Kind regards,
  Andras

  Andras B May 16, 2007 08:47

  - 0 +
• 
  So if I use your database refactoring tool while creating a new version of my software, I will not be able to create a database upgrade that does not loose data to send to my customers. Or am I missing something?
  
  (The new support for syncing to script files may make your database refactoring tool useful to us)

  inneedofspeed May 16, 2007 09:00

  - 0 +
• 
  I was looking exactly for this feature
  
  I'm using SQL Compare to test a devellopement database and compare with the production version.
  
  But If I rename a field and push the version in production all the values in the old column is lost
  
  having a feature that allow mapping of field name when SQL Compare detect the added column and removed column
  
  the same could be done for table renamed.

  Powlin May 22, 2007 17:01

  - 0 +

Add comment

Please sign in to leave a comment.