Comments
Sort by recent activity
Is it possible to get a UI for this so we can search for WIs or by user, etc... / comments
Is it possible to get a UI for this so we can search for WIs or by user, etc...
It's actually an SMO thing. When we build the new database with SMO and compare it to an old one, SMO fills in all the default options like EXECUTE AS, makes keywords like CREATE TRIGGER all caps, uses the keyword AFTER instead of FOR for triggers, etc...
So, when comparing to our previous versions, it flags all these as differences, so I don't really care about them. Obviously, that is kind of our issue, because our old version wasn't properly formatted. So, I guess I was just looking for a way to specify an algorithm or a way to exclude certian things. You can filter out certain objects, but it would be cool to filter out things like CASE for creation statements, or ignore EXECUTE AS or at least if none is specified it matches it to the default.
As a side note, one other thing we do have is our customers can create tables and columns in our database. These are prefixed with ud so, with the algorithm theory, I would want to say ignore all columns that start with [x]* or whatever. / comments
It's actually an SMO thing. When we build the new database with SMO and compare it to an old one, SMO fills in all the default options like EXECUTE AS, makes keywords like CREATE TRIGGER all caps,...
This is in 8.1. I think I figured it out though. I was trying to go to a network share. It looks like SQL Compare creates a new directory during the compare and I didn't have create directory permissions. / comments
This is in 8.1. I think I figured it out though. I was trying to go to a network share. It looks like SQL Compare creates a new directory during the compare and I didn't have create directory pe...
I still am having issues. If I run from the UI, I have to select default collation on the scripts folder of LatinBIN. How do I that from the command line. / comments
I still am having issues. If I run from the UI, I have to select default collation on the scripts folder of LatinBIN. How do I that from the command line.
I figured it out. Looks like there wasn't a primary key on the table so it does not allow me to select it for comparison. / comments
I figured it out. Looks like there wasn't a primary key on the table so it does not allow me to select it for comparison.
Yep, that is what I am trying to do. Honestly, at this time I am only doing research. We are trying to find a better solution to sourcing the database. I am even trying out your CTP of SQL Source Control. Of course, SQL Data Compare works with SQL Source Control, so that is less of an issue if we go that way.
I'll check with MS to see if they are going to support sourcing data soon. / comments
Yep, that is what I am trying to do. Honestly, at this time I am only doing research. We are trying to find a better solution to sourcing the database. I am even trying out your CTP of SQL Sourc...
I think if there was a way to configure the layout of the directory structure, even editing a configuration file, that would be perfect and really flexible for anyone's needs. / comments
I think if there was a way to configure the layout of the directory structure, even editing a configuration file, that would be perfect and really flexible for anyone's needs.