登入
 
MSDN > 論壇首頁 > Visual Studio Database Development Tools (Formerly "Database Edition Forum") > can't get schema compare to work on GDR R2
發問發問
搜查論壇：
 

已答覆can't get schema compare to work on GDR R2

  • 2009年6月26日 下午 03:36Tim Estenson 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    登入以投票
    0
    登入以投票

    we are trying to use the schema compare feature but after upgrading to GDR R2 Compare is not returning anything.

    database to database
    schema to database

    It does not seem to matter which method. Schema compare appers to be doing something but when it returns it shows no changes which i know is not true.

     

解答

所有回覆

  • 2009年6月26日 下午 05:16Chris B. Snyder 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    登入以投票
    0
    登入以投票
    Tim,

    Not sure if this will help you or not, but look for any errors in your schema (in the errors/warnings window). I had the same problem (sveral times) and it was always due to some form of complaint about the schema.
    Chris Snyder, Stumbling through code one day at a time If your question was answered, please mark it.
     
  • 2009年6月29日 下午 06:47Tim Estenson 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    登入以投票
    0
    登入以投票
    Chris that does not seem to be the problem as i see the same issue when Comparing Database to Database. We have reproduced this on 2 machines and are no closer to a resolution. The really interesting thing is I am able to run a Deploy with no issues but the schema compare functionality is not working.
     
  • 2009年6月29日 下午 07:04Barclay HillMSFT, 版主使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    登入以投票
    0
    登入以投票
    Tim, 

    Does Schema Compare show any objects as being equal, diff, etc?  There are no errors or warnings in the error list?

    There could be an object in the database that is failing the reverse engineer.  Can you enable tracing to see if you are getting an exception?
    See here to enable trace: http://blogs.msdn.com/gertd/archive/2008/08/17/trace-helper.aspx

    Thanks,
    Barclay Hill Program Manager VSTS: DB Team (DataDude, DBPro, Database Edition) Please mark the responses as answer if it resolves your question.
     
  • 2009年7月6日 上午 05:59Yann Duran 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     
    登入以投票
    0
    登入以投票
    Hi Tim,

    I've just "upgraded" to GDR R2 as well. I have a similar problem in that Schema Compare doesn't seem to be working right. I run a compare, I get results, I click "Write Updates", it "does it's thing", then it recompares (automatically), but the *same* "differences" are still there. Some are marked "Skip" & I can't change it to update. Some are marked "Update" but still they don't get updated.

    I've done this numerous times now & still can't get a simple schema compare & update to function correctly like it did pre-GDR.

    I'm not a happy camper!

    Yann
     
  • 2009年7月6日 下午 09:34Tim Estenson 使用者勳章使用者勳章使用者勳章使用者勳章使用者勳章
     已答覆
    登入以投票
    0
    登入以投票
    After going back and forth with Barclay off line we found the answer to this issue. I followed the info outlined here and schema compare workes now.

    http://blogs.msdn.com/gertd/archive/2009/03/08/dealing-with-confused-installations.aspx

    Super big thanks to Barclay.