Smart rename & identity column

Dmitry Gokun · May 29, 2011 3:08PM

Hello,

i'm trying to use "smart rename" feature to rename identity column on one of my tables. But that end ups with identity values screwed. However, i can edit generated changes script, add IDENTITY_INSERT statements and so on. But why SQL Prompt cannt do that by itself??

Do you know about this problem and is it planned to be fixed in future versions?

Regards,
Dmitry Gokun.

Anu D · May 31, 2011 7:49AM

Thanks for your post.

I replicate the issue but it works for me.

What exactly you mean by "identity values screwed"?

Does it breaks the sequence? Or does it tries to reset the identity value?

Dmitry Gokun · May 31, 2011 7:57AM

Hello Anu.

Here's sample script which creates table:

CREATE TABLE Test
&#40;
    TestId INTEGER IDENTITY&#40;1, 1&#41; NOT NULL PRIMARY KEY,
    Name NVARCHAR&#40;MAX&#41; NOT NULL
&#41;
GO

INSERT INTO Test&#40;Name&#41; VALUES &#40;'Name1'&#41;
GO

INSERT INTO Test&#40;Name&#41; VALUES &#40;'Name2'&#41;
GO

INSERT INTO Test&#40;Name&#41; VALUES &#40;'Name2'&#41;
GO

INSERT INTO Test&#40;Name&#41; VALUES &#40;'Name4'&#41;
GO

DELETE FROM Test WHERE TestId = 1
GO

DELETE FROM Test WHERE TestId = 3
GO

SELECT * FROM Test
GO

After running this, you have two rows in table "Test":

TestId Name

2 Name2
4 Name4

Now, right-click TestId column in SMSS's Object Explorer and "Smart Rename..." it to "Id". After script ran, try selecting from "Test". What you get is:

Id Name

1 Name2
2 Name4

As you can see, values of identity column just renamed are screwed.

Regards,
Dmitry Gokun

Dmitry Gokun · April 30, 2012 9:32PM

Well, 11 monthes passed since i reported this problem. It's not fixed. Can you let us know if you ever have plans to fix it?

Fix is as hard as adding SET IDENTITY_INSERT ON statement to generated script.. It's very frustrating that it makes such a big problem for RedGate to fix.

Eddie D · May 1, 2012 11:36AM

Hi Dmitry

Sorry that we have overlooked this forum post.

I have recreated your issue, as soon as our Bug Tracking system is back on line, I will check to see what the progress there is on the bug report and seek to update the urgency of this bug report.

Also I will post back and provide an update to you.

Many Thanks
Eddie

Dmitry Gokun · May 1, 2012 12:07PM

Hello Eddie,

thanks for picking up this ..

Regards,
Dmitry

Dmitry Gokun · May 9, 2012 5:54AM

And so it goes... No fix, no forum update. Good support, guys (Y)

PDinCA · May 9, 2012 1:28PM

Hi Dmitry,

As a sometimes-frustrated fellow bug-reporter, I've found that if ANYONE posts a reply to the initial post, Red Gate's nightly post-crawler doesn't pick up your post and automatically add it as a case, which WILL get attention.

Thus, if someone replies and you don't get a timely response from Red Gate, either:

To NON-RED-GATE posters:
Unless you are offering a SOLUTION, REFRAIN from posting a reply to an INITIAL post reporting a bug! WAIT until Red-Gate has responded, then throw in your two-cents-worth, please...

Dmitry Gokun · May 9, 2012 2:50PM

Do not you think it's idiotic that we should do this magic to have bugs fixed in product we paid money for?

What i do here is simple - we will not buy RedGate's products anymore and i will storngly advise all people i know to do the same. Thanks God, there full set of competitive products on the market.

PDinCA · May 9, 2012 3:06PM

Sorry to see you go, Dmitry.

I've been a user of about 80% of the SQL tools for over 7 years and, yes, there have been some frustrations, but overall, having looked at and evaluated all the competition, Red Gate's tools are IMO, yes IMO, the best value for money and the most comprehensive.

Hope you find support by the other vendors up to your high expectations. I have tools from three other vendors and their support is worse than Red Gate's and their availability, even for a US Company calling a US Vendor, much worse, too.

Enjoy!

Eddie D · May 10, 2012 8:51AM

Hi Dimitry

Sorry for my delay in replying back to you, following my post into this forum topic on the 1st May 2012.

Upon checking our Bug Tracking system, there is an existing Bug Report, SP-3975. My colleague, Anu Deshpande (who originally replied to you on the 31st May 2011), submitted this bug report in early June 2011. Also a support call was created for this forum topic, call reference F0048263.

I can only apologise that the above information was not communicated to you either via the support call or this forum topic.

Unfortunately the bug you have reported to Red Gate in the Smart Rename Feature of SQL Prompt is still unresolved. Therefore I will be requesting that SQL Prompt Product Manager and SQL Project Manager review the Bug Report and generate a fix for this problem.

Many Thanks
Eddie

dneighb · November 14, 2013 3:26PM

We have encountered this issue now as well in a project and really dissapointed this has not been resolved now more than two years since it was raised, a fundamental bug for a rename feature. Not impressed redgate.

Eddie D · November 25, 2013 11:51AM

Thank you for your posts regarding a problem with the Smart Rename feature of SQL Prompt.

I have some good news, a patch has been generated that fixes this issue.

Please download SQL Prompt V6.2.0.125 using this LINK.

Any problems either reply to this forum post, or e-mail support@red-gate.com or submit a new support request via the support PORTAL.

Many Thanks
Eddie

Smart rename & identity column

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk

Smart rename &amp; identity column

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk

Smart rename & identity column