Ask a questionAsk a question
 

AnswerSchema Compare vs Import Database Objects...

  • Friday, November 06, 2009 7:19 PMbadefel Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    When you have an empty database project, is the result of an "Import Database Objects And Settings" different than the result of doing a Schema Compare where the target is your local project and the source is the database you wish to import?  It seems like the Schema Compare method is more useful as it lets me review the changes before I write them to the project.  I wanted to make sure I wasn't missing something by doing this, though.  Thanks!

Answers

  • Sunday, November 08, 2009 12:29 PMGrant FritcheyMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    From the tests I've run, they're the same. You just get more granular control over the compare, so it might be a better approach. Say, in my case, I want to remove logins from developers so that they're not maintained as a part of the core project, instead of doing an import, I do a compare and then just hit ignore on the logins. The other objects are all imported in the same way.
    • Marked As Answer bybadefel Monday, November 09, 2009 9:19 PM
    •  

All Replies

  • Sunday, November 08, 2009 12:29 PMGrant FritcheyMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    From the tests I've run, they're the same. You just get more granular control over the compare, so it might be a better approach. Say, in my case, I want to remove logins from developers so that they're not maintained as a part of the core project, instead of doing an import, I do a compare and then just hit ignore on the logins. The other objects are all imported in the same way.
    • Marked As Answer bybadefel Monday, November 09, 2009 9:19 PM
    •  
  • Monday, November 09, 2009 9:19 PMbadefel Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    That's what I was hoping to hear.  Thanks!