Posts
Sort by recent activity
prevent unique constraint from being scripted?
I am creating a script that will drop database objects.
However, it is including unique constraints in the script.
The problem is, the next time the database is created, the constraints are differe...
"authenticate" popup despite disabling sqlprompt
I'm getting this whenever I switch to one particular tab.
Why is this occuring when I have specifically disabled prompt on the menu?
It's driving me nuts
quick ER diagram from script
I'm currently working with an unfamiliar db and would at times be aided by the ability of viewing an ER diagram of the query.
SSMS does not seem to have such functionality, can this be added to pro...
table/view data sample (similar to table/view def'n preview)
Is it possible to get it to pop up some sample data when viewing the table definition, with the options for
select top X <optional> * from table order by newid() <optional>
cache the result <optional>
hover over table/view to popup defn (same as typing it out)
When you type a table name out, you can set the option to view the table or view definition.
Why can't this happen when just hovering over it?
I keep having to go and edit the table name to get it ...
GROUP|ORDER BY to filter by useable values rather than all
after GROUP BY or ORDER BY
why can't prompt show you a list of only those values which are valid?
This is especially annoying when you have to add a case statement in or are using other complex logic
generate script execution order from cmd?
does this tool have a cmd interface?
if so:
can you use it to generate the run order of a bunch of sql scripts (views, funcs, procs)
more verbose errors?
I'm getting an error (this is from the log)
Synchronizing databases
Error: Error Comparing Scripts/DB vs <server>/<db> : Incorrect syntax near '.'.
when running from the cmd with the /sync flag
How...
cmd, A <=> B, B to be B plus new+diff from A
How can I create the syntax for this at a command line level:
Database A (exists as folders/scripts)
Database B (live db)
N.B. "A" is only a small subset of "B"
Compare A with B and sync them
Make ...
fixed in 7? command line switch must exclude items !present
If I run the command line version of SQLCompare, it errors if the item it is trying to compare is missing, and I have to use the exclude switch.
This seems odd as the GUI just says the item is miss...