Comments
Sort by recent activity
In the project options screen, there is an option to ignore extended properties (there is a search box at the top if you can't find it)
Simon C / comments
In the project options screen, there is an option to ignore extended properties (there is a search box at the top if you can't find it)
Simon C
In the project options, there is an option to ignore users' permissions and role memberships. Does this option do what you need?
Simon C / comments
In the project options, there is an option to ignore users' permissions and role memberships. Does this option do what you need?
Simon C
You can use the 'AddDatabaseUseStatement' option:
/options:Default,AddDatabaseUseStatement / comments
You can use the 'AddDatabaseUseStatement' option:
/options:Default,AddDatabaseUseStatement
Have you got schema objects corresponding to the non-dbo schemas in the script folder? SQL Compare can only match up schemas if there is also a corresponding schema object. You can also check the schema mappings are ok (Edit Project -> Mapping tab)
Simon C / comments
Have you got schema objects corresponding to the non-dbo schemas in the script folder? SQL Compare can only match up schemas if there is also a corresponding schema object. You can also check the s...
Hi pbz; I've had a look at your database, and the problem is caused by the way the engine finds text object dependencies on 2005 databases.
It is matching up the datetime function parameters in several functions to the dbo.DateTime function, which causes a circular dependency. To try and remove the circular dependency, the engine puts all the functions at the start of the sync script, which is then breaking when you try and run it.
I'm doing a code fix at the moment; in the meantime, you could upgrade to SQL Server 2008 Express which does not have this issue, or rename the DateTime function to something else that does not clash with an object type name.
Thanks for the bug!
Simon C / comments
Hi pbz; I've had a look at your database, and the problem is caused by the way the engine finds text object dependencies on 2005 databases.
It is matching up the datetime function parameters in sev...
Hi dwainew; apologies for the delay. We now have a private release build that fixes this issue - please contact support@red-gate.com and reference this post to obtain it
Simon C / comments
Hi dwainew; apologies for the delay. We now have a private release build that fixes this issue - please contact support@red-gate.com and reference this post to obtain it
Simon C
If you're sure the objects are in the second database, the thing to check for would be permissions; that the user you're logging in as can read the values in the system tables. Try running this as the same user in SSMS and see what is returned:
select * from sys.objects (sysobjects if on 2000)
Simon C / comments
If you're sure the objects are in the second database, the thing to check for would be permissions; that the user you're logging in as can read the values in the system tables. Try running this as ...
This issue is solved in version 8; sql compare detects what programs you've got installed and automatically selects the highest version available
Simon C / comments
This issue is solved in version 8; sql compare detects what programs you've got installed and automatically selects the highest version available
Simon C
I'm afraid there is currently no method to map tables or columns. However, this feature has been requested several times before, so I've added this post to the relevant bug report (SC-1933). Thanks for the request! / comments
I'm afraid there is currently no method to map tables or columns. However, this feature has been requested several times before, so I've added this post to the relevant bug report (SC-1933). Thanks...
Sounds like a bug; could you please send your project file and SQL Compare schema snapshots or backups of the source and target (if possible) to simon dot cooper (at) red-gate dot com, so we can have a look at what's going on?
thanks,
Simon C / comments
Sounds like a bug; could you please send your project file and SQL Compare schema snapshots or backups of the source and target (if possible) to simon dot cooper (at) red-gate dot com, so we can ha...