February 24, 2015 at 12:25 pm
Jeff Moden (2/24/2015)
Thanks folks. Has anyone any particular pleasantries that have occurred from Dev to Stage to Prod with RedGate Compare?@Lynn...
Are you saying that you had to make some tweaks to the RedGate code?
The code generated by SQL Compare works great. The problem I actually ran into with preparing for our latest upgrade (happening in just a couple of days) was that our current theater tech lead wanted me to go through all the SQL code to ensure that things were good, and running in the correct parts of the upgrade process.
This actually made me start splitting out code into separate files (17 in this particular case) so I could easily make comparisons in the code to be sure we had matching draft/published tables for reports, that primary keys were properly declared, and such. Since the RedGate Compare had this code all through the script, that was the only way I could make the necessary validations. Technically, all of this should have been done back in CONUS.
The MasterSchemaUpgrade script, after all the work I went through, was good. I actually ran into issues with our data upgrade scripts. We have two different scripts, one for the (replication) hub and another to be run on all servers. The difference in these are that the hub data upgrade replicates out to the spokes where as the data upgrade script for all servers inserts/updates/deletes data that is not replicated.
The hub data script contained both data that would replicate and would not. The all servers data script contained schema changes that were also contained in the master schema upgrade script (this script is run on all servers as well since DataXtend does not replicate schema changes).
February 24, 2015 at 12:46 pm
Jeff Moden (2/24/2015)
Brandie Tarvin (2/24/2015)
Jeff Moden (2/24/2015)
Just curious... does anyone use RedGate Compare to promote code from Dev to Staging to Prod? Looking for both positive and negative comments on experiences. Thanks folks.Sorry, Jeff. We use TFS.
Actually, that's good feedback, Brandie. Thanks.
And SQL Compare works with TFS... just saying.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 24, 2015 at 12:47 pm
Jeff Moden (2/24/2015)
Just curious... does anyone use RedGate Compare to promote code from Dev to Staging to Prod? Looking for both positive and negative comments on experiences. Thanks folks.
When I had Production databases, yes, I did. Overall, very positive experience. This was in the days prior to it working directly with source control and before it had the Migrations functionality added in. So, we fairly regularly had to edit the scripts manually when there was the possibility of data loss. But except for that, it really did work well. Part of why I asked them for a job.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 24, 2015 at 12:55 pm
Grant Fritchey (2/24/2015)
Jeff Moden (2/24/2015)
Just curious... does anyone use RedGate Compare to promote code from Dev to Staging to Prod? Looking for both positive and negative comments on experiences. Thanks folks.When I had Production databases, yes, I did. Overall, very positive experience. This was in the days prior to it working directly with source control and before it had the Migrations functionality added in. So, we fairly regularly had to edit the scripts manually when there was the possibility of data loss. But except for that, it really did work well. Part of why I asked them for a job.
I like the tools as well, even considering buying the toolkit myself. Biggest problem out here is getting permission to install on government networks, and trying to get the software licensed on networks that have no access to the internet.
RedGate SQL Backup is stable once we go through the manual licensing steps. Unfortunately SQL Compare and SQL Data Compare seem to get lost at times and have to be relicensed to work because we can suddenly get the message that your trail has expired.
February 24, 2015 at 1:29 pm
Jeff Moden (2/24/2015)
Thanks folks. Has anyone any particular pleasantries that have occurred from Dev to Stage to Prod with RedGate Compare?@Lynn...
Are you saying that you had to make some tweaks to the RedGate code?
There are certainly places you might need to do deal with issues. Adding NOT NULL column, renames, splits, etc. We handle most things well, but there are a few things that are impossible to script correctly looking at states.
There are also issues with filtering at times. You might want to pick and choose certain objects and the filtering is rudimentary.
February 24, 2015 at 1:37 pm
Clean up in Aisle 12, some one brought their horse in again.
February 24, 2015 at 1:43 pm
Lynn Pettis (2/24/2015)
Clean up in Aisle 12, some one brought their horse in again.
Sorry about that. I thought the horse was gonna be sanitary.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 24, 2015 at 1:47 pm
SQLRNNR (2/24/2015)
Lynn Pettis (2/24/2015)
Clean up in Aisle 12, some one brought their horse in again.Sorry about that. I thought the horse was gonna be sanitary.
Not your horse. 😉
February 24, 2015 at 5:53 pm
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
February 24, 2015 at 6:18 pm
Yeah - that is a might bit large.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 24, 2015 at 7:20 pm
And now for all of you conspiracy buffs:
That is the most fascinating thing I've read in a long, long time.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
February 24, 2015 at 9:03 pm
... Mark one off, 3 days on the calendar to go. 3 days on the calendar to go, 3 days to go, ...
And for the geeks out there:
... Mark one off, 11 days on the calendar to go. 11 days on the calendar to go, 11 days to go, ...
February 24, 2015 at 9:55 pm
ROFL... maybe I need a binary calendar?
February 25, 2015 at 12:33 am
Jeff Moden (2/24/2015)
Brandie Tarvin (2/24/2015)
Jeff Moden (2/24/2015)
Just curious... does anyone use RedGate Compare to promote code from Dev to Staging to Prod? Looking for both positive and negative comments on experiences. Thanks folks.Sorry, Jeff. We use TFS.
Actually, that's good feedback, Brandie. Thanks.
We use a combination of TFS and SSDT database projects.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 25, 2015 at 4:41 am
Grant Fritchey (2/24/2015)
Jeff Moden (2/24/2015)
Brandie Tarvin (2/24/2015)
Jeff Moden (2/24/2015)
Just curious... does anyone use RedGate Compare to promote code from Dev to Staging to Prod? Looking for both positive and negative comments on experiences. Thanks folks.Sorry, Jeff. We use TFS.
Actually, that's good feedback, Brandie. Thanks.
And SQL Compare works with TFS... just saying.
I think our release coordinator uses it, or something like it, to verify the releases.
What we do in TFS is this:
Each database has its own folder. In each database folder are subfolders for views, procs, and functions. In each folder is the "master copy" of each query with a DROP and a CREATE statement. These are the queries we check out for edit (exclusive so no one can mess with the code while the developer is coding a project).
In a separate "master" folder, we have our release folders that are dated. Each release folder has a subfolder for each database affected by that release. Here's where we store schema changes and then we use TFS to branch out the master copy of the proc / function / view that is changing (after check-in). The release coordinator notes the change log # and puts it in his release document, which is saved on sharepoint.
When release time comes up, he has us review the document, compare it to our project numbers and what we think should be in the release. The DBAs and server people doing the release make sure everything listed on the release doc is in the proper release folders and named correctly. If we notice items are missing or see that there are extra items, we clear that up before the release. Then we check off the document as we do the release.
It's actually a pretty good system.
Viewing 15 posts - 47,581 through 47,595 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply