February 8, 2017 at 2:31 pm
Didn't Redgate have a tool for creating deployment packages for SQL Databases? It has been about 4 years since I used it but I can't remember the name of the tool and not seeing anything on the Redgate web site.
February 8, 2017 at 3:27 pm
Lynn Pettis - Wednesday, February 8, 2017 2:31 PMDidn't Redgate have a tool for creating deployment packages for SQL Databases? It has been about 4 years since I used it but I can't remember the name of the tool and not seeing anything on the Redgate web site.
Would that be SQL Compare?
February 8, 2017 at 3:37 pm
Luis Cazares - Wednesday, February 8, 2017 3:27 PMLynn Pettis - Wednesday, February 8, 2017 2:31 PMDidn't Redgate have a tool for creating deployment packages for SQL Databases? It has been about 4 years since I used it but I can't remember the name of the tool and not seeing anything on the Redgate web site.Would that be SQL Compare?
That generates scripts, there was a tool that could generate an executable that could be run. Could even have had Packager in its name, I just don't remember.
February 9, 2017 at 5:54 am
djj - Wednesday, February 8, 2017 5:50 AMGrant Fritchey - Wednesday, February 8, 2017 5:11 AMAnd Captain Apollo is dead.I actually hated the series when it came out, but watched it religiously (we had crap SF on TV back in the day).
Hay, but the tight outfits on the ladies were nice, as I was in my early twenties and single.
Good point. I do agree.
"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 9, 2017 at 6:02 am
jasona.work - Wednesday, February 8, 2017 7:26 AMSo much fun trying to track database migrations to new servers, trying to keep track of which DB is going to which server and which are done and not...
I keep myself mostly on-track by taking DBs that have been migrated offline on their old servers, but it'd be nice to have something "graphic" as well...
Visio would be perfect for what I'm thinking of doing (yeah, it'd be a spaghetti tangle of lines, but if it works for me, who cares?) but in the time it would take for me to get Visio on my work laptop, I'll probably be done with the migration...So, instead, I'm selecting all the db names and states from my registered servers, copying those results into a temp table and adding a couple fields to track QAs / Prods and Old / New servers, then joining things up. Then those results get copy / pasted in Excel so I can color code things a bit...
Gotta be a better way to track this, but thankfully this is a once-in-a-while thing (as in, either the OS on the servers is no longer supported by MS, the version of SQL is no longer supported, or there's a mandate from higher up to move to a new OS / SQL)
Take a look at DLM Dashboard. It's a free tool and could do exactly what you're looking for.
"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 9, 2017 at 6:03 am
Lynn Pettis - Wednesday, February 8, 2017 2:31 PMDidn't Redgate have a tool for creating deployment packages for SQL Databases? It has been about 4 years since I used it but I can't remember the name of the tool and not seeing anything on the Redgate web site.
We did have a tool called Packager (or something like that). It's been replaced by all the DLM tools.
"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 9, 2017 at 6:33 am
Grant Fritchey - Thursday, February 9, 2017 6:03 AMLynn Pettis - Wednesday, February 8, 2017 2:31 PMDidn't Redgate have a tool for creating deployment packages for SQL Databases? It has been about 4 years since I used it but I can't remember the name of the tool and not seeing anything on the Redgate web site.We did have a tool called Packager (or something like that). It's been replaced by all the DLM tools.
Thomas Rushton
blog: https://thelonedba.wordpress.com
February 9, 2017 at 6:38 am
Grant Fritchey - Thursday, February 9, 2017 6:02 AMjasona.work - Wednesday, February 8, 2017 7:26 AMSo much fun trying to track database migrations to new servers, trying to keep track of which DB is going to which server and which are done and not...
I keep myself mostly on-track by taking DBs that have been migrated offline on their old servers, but it'd be nice to have something "graphic" as well...
Visio would be perfect for what I'm thinking of doing (yeah, it'd be a spaghetti tangle of lines, but if it works for me, who cares?) but in the time it would take for me to get Visio on my work laptop, I'll probably be done with the migration...So, instead, I'm selecting all the db names and states from my registered servers, copying those results into a temp table and adding a couple fields to track QAs / Prods and Old / New servers, then joining things up. Then those results get copy / pasted in Excel so I can color code things a bit...
Gotta be a better way to track this, but thankfully this is a once-in-a-while thing (as in, either the OS on the servers is no longer supported by MS, the version of SQL is no longer supported, or there's a mandate from higher up to move to a new OS / SQL)
Take a look at DLM Dashboard. It's a free tool and could do exactly what you're looking for.
+ 1 for DLM (disclaimer: I don't work for Redgate)
Possibly a PoSh script could work too?
February 9, 2017 at 8:24 am
Gazareth - Thursday, February 9, 2017 6:38 AMGrant Fritchey - Thursday, February 9, 2017 6:02 AMjasona.work - Wednesday, February 8, 2017 7:26 AMSo much fun trying to track database migrations to new servers, trying to keep track of which DB is going to which server and which are done and not...
I keep myself mostly on-track by taking DBs that have been migrated offline on their old servers, but it'd be nice to have something "graphic" as well...
Visio would be perfect for what I'm thinking of doing (yeah, it'd be a spaghetti tangle of lines, but if it works for me, who cares?) but in the time it would take for me to get Visio on my work laptop, I'll probably be done with the migration...So, instead, I'm selecting all the db names and states from my registered servers, copying those results into a temp table and adding a couple fields to track QAs / Prods and Old / New servers, then joining things up. Then those results get copy / pasted in Excel so I can color code things a bit...
Gotta be a better way to track this, but thankfully this is a once-in-a-while thing (as in, either the OS on the servers is no longer supported by MS, the version of SQL is no longer supported, or there's a mandate from higher up to move to a new OS / SQL)
Take a look at DLM Dashboard. It's a free tool and could do exactly what you're looking for.
+ 1 for DLM (disclaimer: I don't work for Redgate)
Possibly a PoSh script could work too?
Looks like DLM is more aimed at tracking changes to the structure of the DBs, then what I'm at the moment tracking.
We're basically picking up the DBs and moving them as-is to shiny new servers (moving up the OS version.)
So the process is fairly straight-forward:
Set up a time w/customer -> backup existing DB and set to offline -> restore to new server and fix up orphans -> customer test and OK -> rinse-and-repeat
However, I am going to work on getting the necessary approvals to run SQL Monitor, at least for my production instances, after this migration is done. I figure the approval process ought to be wrapping up about the time I'm migrating to Server 2016 / SQL vNext...
:doze::crying:
February 9, 2017 at 11:05 am
jasona.work - Thursday, February 9, 2017 8:24 AMLooks like DLM is more aimed at tracking changes to the structure of the DBs, then what I'm at the moment tracking.
We're basically picking up the DBs and moving them as-is to shiny new servers (moving up the OS version.)
So the process is fairly straight-forward:
Set up a time w/customer -> backup existing DB and set to offline -> restore to new server and fix up orphans -> customer test and OK -> rinse-and-repeatHowever, I am going to work on getting the necessary approvals to run SQL Monitor, at least for my production instances, after this migration is done. I figure the approval process ought to be wrapping up about the time I'm migrating to Server 2016 / SQL vNext...
:doze::crying:
Sorry. I misunderstood.
Good luck on the approvals. I know all too well what that's like.
"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 9, 2017 at 11:29 am
Grant Fritchey - Thursday, February 9, 2017 11:05 AMjasona.work - Thursday, February 9, 2017 8:24 AMLooks like DLM is more aimed at tracking changes to the structure of the DBs, then what I'm at the moment tracking.
We're basically picking up the DBs and moving them as-is to shiny new servers (moving up the OS version.)
So the process is fairly straight-forward:
Set up a time w/customer -> backup existing DB and set to offline -> restore to new server and fix up orphans -> customer test and OK -> rinse-and-repeatHowever, I am going to work on getting the necessary approvals to run SQL Monitor, at least for my production instances, after this migration is done. I figure the approval process ought to be wrapping up about the time I'm migrating to Server 2016 / SQL vNext...
:doze::crying:Sorry. I misunderstood.
Good luck on the approvals. I know all too well what that's like.
Not a problem, I still appreciate the suggestion!
Heh, I think I've said where I work before, so knowing that, take whatever time you think it should take, multiply by 100, then feed that value in as the seed in a SELECT RAND(#)/.0001 and you might get a close approximation...
In days...
February 9, 2017 at 11:47 am
SEAN!
SEEEEEEEAAAAAAAAANNNNNNN!
@whine <poke> <poke> @whine
BTW, this is me pretending to be one of those "I have EXPECTATIONS and people on this site need to help me NOW" people. So feel free to launch pork chops (I've got the grill all fired up and ready). @=)
February 9, 2017 at 12:07 pm
Brandie Tarvin - Thursday, February 9, 2017 11:47 AMSEAN!SEEEEEEEAAAAAAAAANNNNNNN!
@whine <poke> <poke> @whine
BTW, this is me pretending to be one of those "I have EXPECTATIONS and people on this site need to help me NOW" people. So feel free to launch pork chops (I've got the grill all fired up and ready). @=)
Okay, where, I have to see what prompted this.
February 9, 2017 at 12:14 pm
Lynn Pettis - Thursday, February 9, 2017 12:07 PMBrandie Tarvin - Thursday, February 9, 2017 11:47 AMSEAN!SEEEEEEEAAAAAAAAANNNNNNN!
@whine <poke> <poke> @whine
BTW, this is me pretending to be one of those "I have EXPECTATIONS and people on this site need to help me NOW" people. So feel free to launch pork chops (I've got the grill all fired up and ready). @=)
Okay, where, I have to see what prompted this.
Oh, it's not on the forums. Sean sent me an email promising to review my articles "soon" so I thought I'd just mess with him in a public place. @=)
February 9, 2017 at 12:18 pm
Since Microsoft was ever so helpful to remove database diagrams from Visio Pro (without telling anyone so we wouldn't buy the newer versions) what are people using to generate those for presentations, documentation, and such?
Viewing 15 posts - 57,406 through 57,420 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply