Activity overview
Latest activity by AdamR
Improving performance.
Is there a way to improve performance. I have a database with 25K objects, 1 million lines of code, and working with Source Control is just too slow.
Problem is the get latest tab takes 5-8 minutes...
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,...
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.
Don't compare EXECUTE AS
How do I not compare the execute as on triggers and procs? I also am looking for how not to compare FOR versus AFTER on the trigger keyword.
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...
Error when running from the command prompt
What does this error imply?
Error: Invalid connection database connection parameter: An item with the same key has already been added.
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.
Cannot select checkbox to compare a table
I cannot seem to select a checkbox to compare a table. What is the checkbox not present?
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...