Comments
Sort by recent activity
Swallowing would be a good first step but it will still freeze the UI at least 10 sec. each time. Would there be a way to flag a registered server so SQL Prompt ignores it?
Or, since those db are shown as [C:\...] in SSMS, a SQL Prompt option could be to ignore dbs with paths in their names. Quite crude, but efficient workaround if the elegant solution is expensive in time for the v3 release.
thanks,
Eric / comments
Swallowing would be a good first step but it will still freeze the UI at least 10 sec. each time. Would there be a way to flag a registered server so SQL Prompt ignores it?
Or, since those db are s...
I could, but it seems that applying several patches (VSTS SP1 among them) fixed the problem.
BTW, improvements are impressive! We had a buch of V1 licenses, then moved to the free but quite buggy V2 but did not participate in the V3 beta because of time constraints.
Can't wait to order a few :P
Never thought it would/could be improved that much...
Eric / comments
I could, but it seems that applying several patches (VSTS SP1 among them) fixed the problem.
BTW, improvements are impressive! We had a buch of V1 licenses, then moved to the free but quite buggy V...
Brian,
I do extract in those formats. What I was refering to is not exporting the view itself but only the content of the Dependencies Panel in the lower right.
that small panel gives a nice quick summary of what other objects may be impacted by a modification of the current (selected) object. In a database with thousands of objects, it is real useful for quick analysis and I have found myself wanting to print that list on a 2 minutes notice before going into a meeting...but no way to print or export it. Just a list of Uses and Used By.
Just being able to copy the tree to the clipboard (as text) would be ok.
Eric / comments
Brian,
I do extract in those formats. What I was refering to is not exporting the view itself but only the content of the Dependencies Panel in the lower right.
that small panel gives a nice quick ...
No 2005 only. Same server in fact. / comments
No 2005 only. Same server in fact.
Brian,
I think I have found the culprit. In reviewing the compare options I was surprise to see that Ignore Indexes was ON. The "Ignore" word is in the header and easy to miss and my eye just saw that Indexes was checked.
Anyway, that schema has some FK defined on unique indexes that are not necessarily PK. This is legal/valid and there are good design reasons for this (NULL are invalid in PK but not in unique keys & I dislike compound PK made of 4+ columns).
I unchecked that option and the synch script was ok...
Eric / comments
Brian,
I think I have found the culprit. In reviewing the compare options I was surprise to see that Ignore Indexes was ON. The "Ignore" word is in the header and easy to miss and my eye just saw t...
Brian,
If you look in the source script, you will find the following line:
ALTER TABLE [dbo].[cSaleAssign] ADD CONSTRAINT [PK_cSaleAssign] PRIMARY KEY NONCLUSTERED ([SaleAssignTK])
So the table DOES have a PK. Anyway, the update script is generated by SQL Compare by comparing the source DB with an empty database; so it can't see a FK on a non existent PK. / comments
Brian,
If you look in the source script, you will find the following line:
ALTER TABLE [dbo].[cSaleAssign] ADD CONSTRAINT [PK_cSaleAssign] PRIMARY KEY NONCLUSTERED ([SaleAssignTK])
So the table DO...
Yes, I can supply scripts. Is there a way to send them to you without posting them publicly on the forum? / comments
Yes, I can supply scripts. Is there a way to send them to you without posting them publicly on the forum?
Done.
Thanks / comments
Done.
Thanks
Hi Brian,
No, I was synchronizing from a 2005 db to another 2005 db. I then tried between the same first db and a totally empty one (on the same 2005 server).
By totally empty, I mean it: no tables, views, sp, fn, etc. I just ran "Create database Test" in SSMS and then tried a Compare between that empty db and another one that had some user objects (about 20 tables, a couple of views and a CLR assembly) / comments
Hi Brian,
No, I was synchronizing from a 2005 db to another 2005 db. I then tried between the same first db and a totally empty one (on the same 2005 server).
By totally empty, I mean it: no table...
Hi Dan,
Your workaround works. Took me 30 minutes to get the objects I wanted to print correctly (large db), but it works.
Thanks
That tool has a future :P
I will order my copy this week / comments
Hi Dan,
Your workaround works. Took me 30 minutes to get the objects I wanted to print correctly (large db), but it works.
Thanks
That tool has a future :P
I will order my copy this week