4

there are two databases to compare,but I can't connect one database directly. so I want to compare the schema,then get a script to update one database. VS2010 can compare two databases by dbschema file. How can I get a dbschema file of an existing sql 2005/2008 database, Notes:the machine which has the database doesn't install vs2010.

ty!

Sunny sun
  • 45
  • 1
  • 6

1 Answers1

4

Take a look at the VSDBCMD.exe that allows you to generate .dbschema files.

Will A
  • 24,780
  • 5
  • 50
  • 61