Settings and activity
93 results found
-
18 votes
An error occurred while saving the comment -
4 votes
An error occurred while saving the comment There's no way of doing this right now, although it's something we might add in future. Your best bet is either to add it manually, or if you're automating, run your own pre-deployment script with sqlcl or sqlplus prior to running Schema Compare's deployment script. Can I ask why you need this particular statement? Are you generating scripts without schema names so you can execute on a different schema target?
-
1 vote
An error occurred while saving the comment Thanks for the feedback. Yes, this is a limitation of the product today. We currently suggest users just recreate the project, but we acknowledge that this is a workaround and not very practical. We have an item on our backlog to allow all aspects of a project to be modified after creation.
-
6 votes
An error occurred while saving the comment Interesting idea. You could of course build something rudimentary using tSQLt, but I'm wondering whether this could be implemented in Redgate tools as a configurable "high" deployment warning (high so it will can halt/pause an automated release process).
-
5 votes
An error occurred while saving the comment This should be straightforward using the existing command line tool of your VCS (sg svn.exe or git.exe) alongside the DLM Automation commandlets.
-
11 votes
An error occurred while saving the comment @Hans - I think this *is* possible today. In the Edit Project screen can you visit the Tables and Views tabs, and using the buttons at the bottom of the screen, unmap the two tables that you want to compare, and remap the two that you want to compare.
-
16 votes
An error occurred while saving the comment @sarmadh - what would your preferred way be of making this specific change?
-
6 votes
An error occurred while saving the comment One option is the /report command line switch. Scroll to the bottom of: https://www.red-gate.com/simple-talk/sql/sql-tools/mysql-compare-the-manual-that-time-forgot-part-1/
-
5 votes
An error occurred while saving the comment @rich - have you considered using the command line, sqlcompare.exe to achieve this? I'm pretty sure that this can take in a project file as an argument, and you can specify the source and targets as separate switches.
-
7 votes
An error occurred while saving the comment Which VCS are you using? If it has a command line you should be able to achieve this by using it in conjunction with the Schema Compare for Oracle command line.
-
1 vote
An error occurred while saving the comment @Lee - Thanks for the feedback. Out of interest, what is the reason you save off this script?
-
1 vote
An error occurred while saving the comment @Josh - This could be a bug. I've sent you an email.
-
14 votes
An error occurred while saving the comment Have you tried SSIS Catalog Compare? http://sqlblog.com/blogs/andy_leonard/archive/2015/10/12/ssis-catalog-compare.aspx
-
3 votes
An error occurred while saving the comment Have you tried the command line? This would be a way of running multiple comparisons simultaneously.
-
14 votes
An error occurred while saving the comment Can you tell us a little about the use case? ie, what problem would this help you solve?
-
1 vote
An error occurred while saving the comment Are you referring to SQL Compare or SQL Source Control?
-
12 votes
An error occurred while saving the comment It's possible to copy the contents of the results grid and paste into Excel.
-
7 votes
An error occurred while saving the comment I was going to blog about how to do this and I've been putting it off. I will email you individually and show you how this can be done.
-
8 votes
An error occurred while saving the comment Are you referring to comparisons using SQL Compare rather than SQL Source Control? I'd be curious to know if you've tried using the DLM Dashboard and whether this helps solve the problem you have? http://www.red-gate.com/products/dlm/dlm-dashboard/
-
1 vote
An error occurred while saving the comment How does this differ from the view you get from the commit tab in SQL Source Control? This is essentially a list of modified (or new) objects with a difference viewer below showing the exact change.
@nicholas - out of interest, which IDE are you using?