Comments
Sort by recent activity
I am aware that it is possible to only sync certain tables but is it possible to set Data to only compare certain tables during the compare?
Running a Data Compare between our development database and live server takes approximately 30 minutes when we are only actually interested in changes between tables we have flagged as static. If it was possible to only compare these static tables (approximately 15-20 tables), the compare would be much quicker. / comments
I am aware that it is possible to only sync certain tables but is it possible to set Data to only compare certain tables during the compare?
Running a Data Compare between our development database ...
Thanks for your reply.
In that case, is there any way to configure SQL Data Compare to be able to only check for changes in static data? / comments
Thanks for your reply.
In that case, is there any way to configure SQL Data Compare to be able to only check for changes in static data?
Ah, excellent. That could well be our issue too as we had some users on earlier versions too.
Thanks for letting me know. / comments
Ah, excellent. That could well be our issue too as we had some users on earlier versions too.
Thanks for letting me know.
No there wasn't a resolution. With with business of Christmas coming up and a few other source control issues I didn't actually get round to sending a schema script over to Red Gate / comments
No there wasn't a resolution. With with business of Christmas coming up and a few other source control issues I didn't actually get round to sending a schema script over to Red Gate
sounds good to me.
really should have taken a note of the problem in detail but was in bit of a tight deadline. next time [image] / comments
sounds good to me.
really should have taken a note of the problem in detail but was in bit of a tight deadline. next time
my problem with extended properties has come up again.
A colleague of mine clicked on the Commit Changes button on one our of databases and was told a difference between the database and source control versions had been found. This once again related to a view that looks at a single table (that has not changed). Whilst I cannot be 1005 certain, it is highly unlikely anyone would have changed this view, esepcially as the view is little more complicated than a 'select * from '
The change between versions is below, with the change highlighted in red: Database Version
EXEC sp_addextendedproperty N'MS_DiagramPaneCount', 1, 'SCHEMA', N'dbo', 'VIEW', N'VIEW Customers Union', NULL, NULL
GO Source Control Version
EXEC sp_addextendedproperty N'MS_DiagramPaneCount', NULL, 'SCHEMA', N'dbo', 'VIEW', N'VIEW Customers Union', NULL, NULL
GO / comments
my problem with extended properties has come up again.
A colleague of mine clicked on the Commit Changes button on one our of databases and was told a difference between the database and source con...
yes there was but unfortuantely as this was a few days ago i can't remember what that change was, but it definitely wasn't anything I had done. I commited the change and as yet, the same problem hasn't come up again. / comments
yes there was but unfortuantely as this was a few days ago i can't remember what that change was, but it definitely wasn't anything I had done. I commited the change and as yet, the same problem h...
We do have plans at some point to move over to TFS but as this has been a plan for some time, I couldn't say when it will happen.
i did eventually manage to find this link myself and connect to VSS but after discussions here we have decided to wait until the switch over to TFS before looking into this product further. / comments
We do have plans at some point to move over to TFS but as this has been a plan for some time, I couldn't say when it will happen.
i did eventually manage to find this link myself and connect to VSS...