Activity overview
Latest activity by robin banks
BTW: it did import date and time as [sys].[date], [sys].[time] / comments
BTW: it did import date and time as [sys].[date], [sys].[time]
What am I trying to achieve?
I generate full db script from SSMS. Save the .sql in Source Safe. Make some changes to dev db. Then I want to gen and diff my dev db script with the Source Safe copy to see what changes to deploy to production. SSMS rearranges the order of the objects in its generate script so I cannot just windiff it too easily (need to edit the file to rearrange).
Compare worked great. / comments
What am I trying to achieve?
I generate full db script from SSMS. Save the .sql in Source Safe. Make some changes to dev db. Then I want to gen and diff my dev db script with the Source Safe copy t...
Worked very nice. Thank you. / comments
Worked very nice. Thank you.
compare sql serve db against SSMS generated script file sql
I have generated a .sql file of all db objects using SSMS-Tasks-Generate Scripts. How can I compare that against a live SQL Server database instance? 2008 R2 Express.