1

I am trying to update a db using the Data Compare functionality in VS.

Once I setup which tables I want to update I can use Write Updates and my DB is updated.

However, when I Export to a .sql file and try to run it from SSMS I don't get anything in the Messages window and I don't have a Results window. At the bottom it says Query completed with errors.

How do I view the errors and/or am I doing something wrong?

Jason
  • 11,435
  • 24
  • 77
  • 131

1 Answers1

3

It appears the generated file was too big. SSMS was choking on it for some reason

Ran sqlcmd -S (local) -i C:\DataUpdateFile.sql and it worked fine.

Jason
  • 11,435
  • 24
  • 77
  • 131