Toad World® Forums

Toad-SS 5.6 - New Feature Request --- Rename database needs functionality to close connections

To all of The Toad-SS user!

image001.gif

image002.jpeg

image007.jpeg

image008.jpeg

image010.jpeg

Supporting Hank’s requests…
Dani

On Mar 3, 2012 2:58 PM, “Hank Freeman(msn)” wrote:

To all of The Toad-SS user!

·          I have decided to include you all in on this New feature
request that I am also sending in to support…

·          I will also try to include this NFR in the idea pond.

o    Yes, I do pay for votes in the idea pond. (HEHE)

 

When you drop a database or restore a database, Toad-SS  5.6 gives you the
opportunity to Close existing connections…

 

The code for each is distinctly different and the drop syntax is specific
for that function.  Sooo, this NFR is requesting the when you RENAME a
DATABASE that the syntax for closing the existing connections also be used.

 

Now, just because I am ME, I NEVER EVER just run the Wizard, I always run
the script in an editor session, So I have saved off Both the Drop set
single user as well as the close connection, so I can use them.

I especially like the Set single user with rollback, for that would need to
be included in the generated syntax.

 

Why I pull the syntax from the wizard is simple… Sometimes it is difficult
to close all the connections, especially if the off-shore development group
doesn’t so as requested, so sometimes I have to run the close all
connections before the set single user. 

 

So  here is what I do, and I do not expect Toad-SS Development to take this
much care and concern over a Rename, especially because they cannot perform
the physical file name rename.

 

Lastly, It should be noted that I also rename the internal and external file
names…

Here again, when you are dealing with over 30 databases with multiple (up to
ten) MDF and NDF combinations on a Mega-server/instance  Quad or 4 x (
Processor Intel(R) Xeon(R) CPU E7-L8867  @ 2.13GHz, 2129 Mhz, 10 Core(s),
10 Logical Processor(s) ) system with 128 GB of ram, you kind-of-sort-of
have to keep things tidy and neat so that the file names don’t get out of
hand.

·          Please note this is a DBA function outside the scope of
this NFR request. Soooo!, Please read and learn from the code sent,  it
works quite well and you would have to experimented with if you chose to use
it in your enviroment…!!!

 

 

 

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50   (Skype)

image007.jpeg

Supporting Hank’s requests…
Dani

On Mar 3, 2012 2:58 PM, “Hank Freeman(msn)” wrote:

To all of The Toad-SS user!

·          I have decided to include you all in on this New feature
request that I am also sending in to support…

·          I will also try to include this NFR in the idea pond.

o    Yes, I do pay for votes in the idea pond. (HEHE)

 

When you drop a database or restore a database, Toad-SS  5.6 gives you the
opportunity to Close existing connections…

 

The code for each is distinctly different and the drop syntax is specific
for that function.  Sooo, this NFR is requesting the when you RENAME a
DATABASE that the syntax for closing the existing connections also be used.

 

Now, just because I am ME, I NEVER EVER just run the Wizard, I always run
the script in an editor session, So I have saved off Both the Drop set
single user as well as the close connection, so I can use them.

I especially like the Set single user with rollback, for that would need to
be included in the generated syntax.

 

Why I pull the syntax from the wizard is simple… Sometimes it is difficult
to close all the connections, especially if the off-shore development group
doesn’t so as requested, so sometimes I have to run the close all
connections before the set single user. 

 

So  here is what I do, and I do not expect Toad-SS Development to take this
much care and concern over a Rename, especially because they cannot perform
the physical file name rename.

 

Lastly, It should be noted that I also rename the internal and external file
names…

Here again, when you are dealing with over 30 databases with multiple (up to
ten) MDF and NDF combinations on a Mega-server/instance  Quad or 4 x (
Processor Intel(R) Xeon(R) CPU E7-L8867  @ 2.13GHz, 2129 Mhz, 10 Core(s),
10 Logical Processor(s) ) system with 128 GB of ram, you kind-of-sort-of
have to keep things tidy and neat so that the file names don’t get out of
hand.

·          Please note this is a DBA function outside the scope of
this NFR request. Soooo!, Please read and learn from the code sent,  it
works quite well and you would have to experimented with if you chose to use
it in your enviroment…!!!

 

 

 

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50   (Skype)

image001.gif

Supporting Hank’s requests…
Dani

On Mar 3, 2012 2:58 PM, “Hank Freeman(msn)” wrote:

To all of The Toad-SS user!

·          I have decided to include you all in on this New feature
request that I am also sending in to support…

·          I will also try to include this NFR in the idea pond.

o    Yes, I do pay for votes in the idea pond. (HEHE)

 

When you drop a database or restore a database, Toad-SS  5.6 gives you the
opportunity to Close existing connections…

 

The code for each is distinctly different and the drop syntax is specific
for that function.  Sooo, this NFR is requesting the when you RENAME a
DATABASE that the syntax for closing the existing connections also be used.

 

Now, just because I am ME, I NEVER EVER just run the Wizard, I always run
the script in an editor session, So I have saved off Both the Drop set
single user as well as the close connection, so I can use them.

I especially like the Set single user with rollback, for that would need to
be included in the generated syntax.

 

Why I pull the syntax from the wizard is simple… Sometimes it is difficult
to close all the connections, especially if the off-shore development group
doesn’t so as requested, so sometimes I have to run the close all
connections before the set single user. 

 

So  here is what I do, and I do not expect Toad-SS Development to take this
much care and concern over a Rename, especially because they cannot perform
the physical file name rename.

 

Lastly, It should be noted that I also rename the internal and external file
names…

Here again, when you are dealing with over 30 databases with multiple (up to
ten) MDF and NDF combinations on a Mega-server/instance  Quad or 4 x (
Processor Intel(R) Xeon(R) CPU E7-L8867  @ 2.13GHz, 2129 Mhz, 10 Core(s),
10 Logical Processor(s) ) system with 128 GB of ram, you kind-of-sort-of
have to keep things tidy and neat so that the file names don’t get out of
hand.

·          Please note this is a DBA function outside the scope of
this NFR request. Soooo!, Please read and learn from the code sent,  it
works quite well and you would have to experimented with if you chose to use
it in your enviroment…!!!

 

 

 

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50   (Skype)

image002.jpeg

Supporting Hank’s requests…
Dani

On Mar 3, 2012 2:58 PM, “Hank Freeman(msn)” wrote:

To all of The Toad-SS user!

·          I have decided to include you all in on this New feature
request that I am also sending in to support…

·          I will also try to include this NFR in the idea pond.

o    Yes, I do pay for votes in the idea pond. (HEHE)

 

When you drop a database or restore a database, Toad-SS  5.6 gives you the
opportunity to Close existing connections…

 

The code for each is distinctly different and the drop syntax is specific
for that function.  Sooo, this NFR is requesting the when you RENAME a
DATABASE that the syntax for closing the existing connections also be used.

 

Now, just because I am ME, I NEVER EVER just run the Wizard, I always run
the script in an editor session, So I have saved off Both the Drop set
single user as well as the close connection, so I can use them.

I especially like the Set single user with rollback, for that would need to
be included in the generated syntax.

 

Why I pull the syntax from the wizard is simple… Sometimes it is difficult
to close all the connections, especially if the off-shore development group
doesn’t so as requested, so sometimes I have to run the close all
connections before the set single user. 

 

So  here is what I do, and I do not expect Toad-SS Development to take this
much care and concern over a Rename, especially because they cannot perform
the physical file name rename.

 

Lastly, It should be noted that I also rename the internal and external file
names…

Here again, when you are dealing with over 30 databases with multiple (up to
ten) MDF and NDF combinations on a Mega-server/instance  Quad or 4 x (
Processor Intel(R) Xeon(R) CPU E7-L8867  @ 2.13GHz, 2129 Mhz, 10 Core(s),
10 Logical Processor(s) ) system with 128 GB of ram, you kind-of-sort-of
have to keep things tidy and neat so that the file names don’t get out of
hand.

·          Please note this is a DBA function outside the scope of
this NFR request. Soooo!, Please read and learn from the code sent,  it
works quite well and you would have to experimented with if you chose to use
it in your enviroment…!!!

 

 

 

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50   (Skype)

image010.jpeg

Supporting Hank’s requests…
Dani

On Mar 3, 2012 2:58 PM, “Hank Freeman(msn)” wrote:

To all of The Toad-SS user!

·          I have decided to include you all in on this New feature
request that I am also sending in to support…

·          I will also try to include this NFR in the idea pond.

o    Yes, I do pay for votes in the idea pond. (HEHE)

 

When you drop a database or restore a database, Toad-SS  5.6 gives you the
opportunity to Close existing connections…

 

The code for each is distinctly different and the drop syntax is specific
for that function.  Sooo, this NFR is requesting the when you RENAME a
DATABASE that the syntax for closing the existing connections also be used.

 

Now, just because I am ME, I NEVER EVER just run the Wizard, I always run
the script in an editor session, So I have saved off Both the Drop set
single user as well as the close connection, so I can use them.

I especially like the Set single user with rollback, for that would need to
be included in the generated syntax.

 

Why I pull the syntax from the wizard is simple… Sometimes it is difficult
to close all the connections, especially if the off-shore development group
doesn’t so as requested, so sometimes I have to run the close all
connections before the set single user. 

 

So  here is what I do, and I do not expect Toad-SS Development to take this
much care and concern over a Rename, especially because they cannot perform
the physical file name rename.

 

Lastly, It should be noted that I also rename the internal and external file
names…

Here again, when you are dealing with over 30 databases with multiple (up to
ten) MDF and NDF combinations on a Mega-server/instance  Quad or 4 x (
Processor Intel(R) Xeon(R) CPU E7-L8867  @ 2.13GHz, 2129 Mhz, 10 Core(s),
10 Logical Processor(s) ) system with 128 GB of ram, you kind-of-sort-of
have to keep things tidy and neat so that the file names don’t get out of
hand.

·          Please note this is a DBA function outside the scope of
this NFR request. Soooo!, Please read and learn from the code sent,  it
works quite well and you would have to experimented with if you chose to use
it in your enviroment…!!!

 

 

 

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50   (Skype)

image008.jpeg

Hi Hank,

Thanks for the request. CR98943 created.

regards,

Alexander Maximov
image002.jpeg

Hi Hank,

Thanks for the request. CR98943 created.

regards,

Alexander Maximov
image001.gif

Hi Hank,

Thanks for the request. CR98943 created.

regards,

Alexander Maximov
image010.jpeg

Hi Hank,

Thanks for the request. CR98943 created.

regards,

Alexander Maximov
image008.jpeg

Hi Hank,

Thanks for the request. CR98943 created.

regards,

Alexander Maximov
image007.jpeg