Red Gate forums :: View topic - Smart rename & identity column
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

Smart rename & identity column

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Dmitry Gokun



Joined: 29 May 2011
Posts: 16

PostPosted: Sun May 29, 2011 8:08 pm    Post subject: Smart rename & identity column Reply with quote

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.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Tue May 31, 2011 12:49 pm    Post subject: Reply with quote

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?
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Dmitry Gokun



Joined: 29 May 2011
Posts: 16

PostPosted: Tue May 31, 2011 12:57 pm    Post subject: Reply with quote

Hello Anu.

Here's sample script which creates table:

Code:

CREATE TABLE Test
(
    TestId INTEGER IDENTITY(1, 1) NOT NULL PRIMARY KEY,
    Name NVARCHAR(MAX) NOT NULL
)
GO

INSERT INTO Test(Name) VALUES ('Name1')
GO

INSERT INTO Test(Name) VALUES ('Name2')
GO

INSERT INTO Test(Name) VALUES ('Name2')
GO

INSERT INTO Test(Name) VALUES ('Name4')
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
Back to top
View user's profile Send private message
Dmitry Gokun



Joined: 29 May 2011
Posts: 16

PostPosted: Tue May 01, 2012 2:32 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 940
Location: Red Gate Software

PostPosted: Tue May 01, 2012 4:36 pm    Post subject: Reply with quote

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
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Dmitry Gokun



Joined: 29 May 2011
Posts: 16

PostPosted: Tue May 01, 2012 5:07 pm    Post subject: Reply with quote

Hello Eddie,

thanks for picking up this ..

Regards,
Dmitry
Back to top
View user's profile Send private message
Dmitry Gokun



Joined: 29 May 2011
Posts: 16

PostPosted: Wed May 09, 2012 10:54 am    Post subject: Reply with quote

And so it goes... No fix, no forum update. Good support, guys (Y)
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 516
Location: Costa Mesa, CA, USA

PostPosted: Wed May 09, 2012 6:28 pm    Post subject: Reply with quote

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:
    Post it again as a new thread, preferably late on Friday as few folks will see it and reply over the weekend. Wink
    Email RG support directly, referencing the post - they are very responsive to direct approaches.
    Call the support line, referencing the bug and post.


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...
Back to top
View user's profile Send private message
Dmitry Gokun



Joined: 29 May 2011
Posts: 16

PostPosted: Wed May 09, 2012 7:50 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 516
Location: Costa Mesa, CA, USA

PostPosted: Wed May 09, 2012 8:06 pm    Post subject: Reply with quote

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! Sad
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 940
Location: Red Gate Software

PostPosted: Thu May 10, 2012 1:51 pm    Post subject: Reply with quote

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
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
dneighb



Joined: 14 Nov 2013
Posts: 1

PostPosted: Thu Nov 14, 2013 9:26 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 940
Location: Red Gate Software

PostPosted: Mon Nov 25, 2013 5:51 pm    Post subject: Reply with quote

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
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group