Date compare in customer site

• 
  Hi there,
  
  Sorry, are you looking to take a snapshot of data too?
  
  If that is the case, I am afraid that this isn't supported. About the only option available to you if you want to included data too is to request a backup of the database from your customer.
  
  Pete

  peter.peart July 02, 2010 12:21

  - 0 +
• 
  Hello
  Peter as i sed in my question ,we have 400 station of SQLExp2008R2
  we need to sync the object and some thables not all from our site
  i know to do sanping the objects ,but i dont know how to snap the few tables that we changed in our site
  please advice
  Thank you very much

  yacov July 04, 2010 10:06

  - 0 +
• 
  Hi there,
  
  It sounds to me like you have 400 customers, each with a database in a different state and you want to be able to update each of them on the fly.
  
  The *only* way of doing this would be to create your own custom app using the SQL Comparison SDK. You would need to essentially build an app that contained a snaoshot of your database which would then use the API of SQL Compare to compare the snapshot against the live customer DB on site.
  
  You could also use the SQL Data Compare API to create a script folder version or a backup of all of the data within your database, and ship that within the app to perform a comparison of data against data.
  
  The above though, once running, would compare everything in the databases. If you only wanted a subset of objects or data compare, you would also need to program this into the app yourself.
  
  We have some code examples of using theSDK which are available from the below link, however nothing as in depth as what you require I am afraid:
  
  http://labs.red-gate.com/index.php/SQL_Comparison_SDK
  
  I hope that this goes someway to helping you acheive what it is you are looking for!
  
  Pete

  peter.peart July 08, 2010 12:41

  - 0 +

Add comment

Please sign in to leave a comment.