How can we help you today? How can we help you today?
tkdennis
Activity overview Badges (0) Posts (37) Comments (36)

Comments

Sort by recent activity
Thanks for the response. I just wish it would use the default directories configured for the server instead of the SQL Server installation root so I wouldn't have to keep manually moving them off the C: drive. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Restore to default directory
Thanks for the response. I just wish it would use the default directories configured for the server instead of the SQL Server installation root so I wouldn't have to keep manually moving them off t...
0 votes
Another vote! / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. synonyms
Another vote!
0 votes
Please add my votes to the database property compare AND 'server compare' style program for comparing properties above the database object level and server objects) Open Feature Requests [image] Thanks! Traci / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Enhancement request - comparison of database level attribute
Please add my votes to the database property compare AND 'server compare' style program for comparing properties above the database object level and server objects) Open Feature Requests Thanks! T...
0 votes
PLEASE do consider it for a future release. This database has 277 tables and most of them have one or more DEFAULT statements on them. My database doesn't care about anything else except that the column names and datatypes have not been changed for any table so I'm having to manually check the highlighted changes for each table marked different. Thanks! Traci / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Ignore DEFAULT statements?
PLEASE do consider it for a future release. This database has 277 tables and most of them have one or more DEFAULT statements on them. My database doesn't care about anything else except that the c...
0 votes
It let me do the Compare, but not the synchronize. I may have switched the databases so the unmapped dbo was on the right. The actual case was comparing 2 databases, one had schema "stage" that mapped to the second database schema "dbo". The second database didn't have any extra schemas, so there was nothing to map the first database dbo schema to. I wound up moving all the tables in the first database back to the dbo schema since using different schemas for stage<->dbo was causing other confusion. Now we are just using schemas to keep objects from the same data owners grouped together, and they don't compare to anything else so it's not an issue anymore since dbo is mapped to dbo again. Thanks for your help, and I really like the new SQL Compare! Traci / comments
  1. Community
  2. SQL Compare 8 beta
  3. Owner mapping issues
It let me do the Compare, but not the synchronize. I may have switched the databases so the unmapped dbo was on the right. The actual case was comparing 2 databases, one had schema "stage" that map...
0 votes
Using RC1, I was able to get to the compare results, but when I tried to synchronize an object (right-to-left), I got the message "There is an unmapped user or schema. Please check your mappings." So it still doesn't like that I have an uneven number of schemas and leave the dbo schema unmapped on one side. / comments
  1. Community
  2. SQL Compare 8 beta
  3. Owner mapping issues
Using RC1, I was able to get to the compare results, but when I tried to synchronize an object (right-to-left), I got the message "There is an unmapped user or schema. Please check your mappings." ...
0 votes
Duh - Thanks! I was looking for the little icon! Sometimes I just need one object, copy the object sync script and use multi-script to blast the changes to multiple servers. It's faster than deselecting all objects, selecting the one, going through the wizard, etc. This time, I discovered an index was out-of-sync and I was just looking to grab the DROP/CREATE INDEX without having to go back to SSMS and click my way into the right CREATE SCRIPT. Occasionally I have the situation where there are multiple changes to a table (multiple columns and multiple indexes) and I just want to synchronize one part but not the whole thing. So I go into the object to see if it generated a simple ALTER TABLE statement I can pick out and run separately. Thanks, Traci / comments
  1. Community
  2. SQL Compare 8 beta
  3. &quot;view object synchronization script&quot; option missing
Duh - Thanks! I was looking for the little icon! Sometimes I just need one object, copy the object sync script and use multi-script to blast the changes to multiple servers. It's faster than desel...
0 votes
I'm not the original poster, but I'd like to maximize the wizard at step 3 - Review Script to see the more of the Synchronization Script tab. Thanks, Traci / comments
  1. Community
  2. SQL Compare 8 beta
  3. Synchronize Wizard Form
I'm not the original poster, but I'd like to maximize the wizard at step 3 - Review Script to see the more of the Synchronization Script tab. Thanks, Traci
0 votes
That will work. Thanks. / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. $CURSOR$ at beginning of snippet not moving the cursor
That will work. Thanks.
0 votes
That works - thanks! / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Delay/Disable tooltips
That works - thanks!
0 votes
Total activity
101
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
28