Posts
Sort by recent activity
script folder and index fill factor
When creating a script folder the fill factor is not scripted. how can I change that?
Rename field bug
The rename field generated this sql while renaming RequestId to RequestIdXXXCREATE NONCLUSTERED INDEX [IX_RequestID] ON [dbo].[EmployeeTimeSheet] ([RequestIDXXX]) WHERE ([RequestId] IS NOT NULL) ON...
Deployment Bug
My source table has a column that does not exist in the target. It appears as unmapped in the column selection. Yet when I try to deploy, SQLDC tries to insert null into it resulting in "Invalid co...
How to do one way sync of data using CLI
I have two databases:
one is live data and is holding data for 3 month
the other should hold parts of the data as an archive.
I need to do one way sync from live->archive using CLI but I do need th...
Bug
I have two tables
Table A(Guid - UniqueIdentifier - PK - default newid, other fields)
Table B(Guid - UniqueIdentifier - PK - default newid, A_Guid - FK to table A, other fields)
If the only thing t...
Bug on Find Invalid Objects
I have the function below on a DB. the table ObjectPermissions does not exist anymore but the function does not list as an invalid object
ALTER FUNCTION [dbo].[CheckEnforceGroupPermissionsForEmploy...
error when trying to run command line version
when we try to run the command line version to compare a live DB against the DB on another machine, we get this error
Register Data base
Error : The connection operation could not be completed: Fie...
mod file creation
using sql data compare 10, I have tried running the sqldatacompare.exe from command line to create the mod files but they are not being created
how can I create them?
I am on windows 8 x64 if that ...
How to make sql compare remember passwords?
using the latest version of sql compare, how do I make it remember users & passwords for the various sql servers I am using?
each time I select on the compare dialog a new server I need to enter th...
Feature requests
please add options for context menu exclusions:
1. right click an object to exclude it (by name). opens the filter dialog so i can edit the pattern a bit (e.g. i right click fnUser_XXX and select e...