SQLServerCentral / Red Gate Software / Third Party Products / Products and Books

SQL Compare 10

Lynn Pettis — Wed, 12 Sep 2012 17:15:47 GMT

Working with SQL Compare 10 to build upgrade scripts we have found that SQL Compare will map columns of different names that are the same data type and the same ordinal position in the column order.We can correct this, unmap these columns, manually but I am wondering if there is a setting some where that can be set (or unset) to prevent this behaviour.Our problem is that SQL Compare is mapping a column (or columns) that exist in one schema but was dropped in the other to a column that didn't exist in the first schema but added in the second and happen to have the same data type and are now in the same ordinal position as well.

SQL Refactor

bledu — Tue, 06 Mar 2007 09:12:00 GMT

I got the free bundle from Redgate through this site. I have managed to install the prompt but I am at a loss as to how to access the SQL refactor component.

Help!

tool for web

gaquada — Sun, 23 Sep 2007 05:59:00 GMT

http://freefunfree.com

i seach it by google, it is very cool

sql Cursor

vinay-492419 — Wed, 19 Sep 2007 20:34:00 GMT

Somthing what i want to do

Declare @var varchar(8000)

set @var='select col,col2 from sometable'

DECLARE scanprofile CURSOR FAST_FORWARD READ_ONLY FOR

@var

OPEN scanprofile

FETCH NEXT FROM scanprofile

-------

Is it possible to do.....

RedGate or ProxyServe

SQL_ME_RICH — Tue, 04 Sep 2007 11:19:00 GMT

Is anyone aware of any comparison benchmarking that may be out there that reports (independently if possible) the features and benefits of one to the other?

Any side by side stuff would be great.

*****NOTE: When I originally posted this I did not realize that Red Gate was the main sponsor for the site out here. Please know that I am merely looking for any independent reports that may have been done on the 2 of these products side-by-side...if available. Thanks*****

SQL Compare Not Working Correctly

Michael Esposito — Mon, 20 Aug 2007 12:12:00 GMT

I am using SQL Compare v5. I am using a vpn connection to connect to a clients set of servers. When I open up SQL Compare and try to browse to the databases on the server, I get timeout or connection not found errors. Can anyone tell me if maybe they have ports shut off that SQL Compare uses? If so, what they are?

Thanks,

Michael

SQL Prompt 3.5 release candidate is now available

Bart Read — Wed, 18 Jul 2007 05:20:00 GMT

We've finally made the SQL Prompt 3.5 release candidate available. Actually this is only four days later than originally estimated, although in the end we were unable to create the expected early access release last week. We had some installer problems, and in the end these caused things to slip so badly that we decided the overhead of doing two releases within such a short period negated any benefit of getting the EA release out there, so I apologise that you've had to wait a little longer than I originally anticipated to get a look at 3.5.You can download the RC from:ftp://ftp.red-gate.com/sqlpromptbeta/SQLPrompt3.5.0.000323.exeThe 3.5 release is a major new version of SQL Prompt with many new features and improvements including:• Visual Studio 2005 database project support• Cross database queries• Distributed queries across linked SQL Server instances• Correlated subqueries• 3 – 5 times faster metadata retrieval• Large script support• 40 – 95% decrease in memory footprintWe have also included dozens of bug fixes and other enhancements, and importantly have eradicated the editor hangs that have been plaguing some users.Please bear in mind the following tips when installing the RC:• SQL Prompt 3.5 should seamlessly upgrade your options files and snippets, however you may wish to make a backup of these files prior to upgrading. Generally they are stored in “C:\Documents and settings\{Your username}\Local Settings\Application Data\Red Gate\SQL Prompt 3”.• If you also use SQL Prompt 2 you do not need to uninstall it, however when working with version 3.5 you should disable it to avoid having two sets of code completion pop up.We aim to have the final release of SQL Prompt 3.5 out by the end of the month.Kind regards,

Change Managment in database development?

Tony Davis — Wed, 27 Jun 2007 09:10:00 GMT

This whitepaper presents what we believe are the three most common ways of applying change management techniques to database development:

· Ad-hoc merging – periodic merges of modified database developer instances

· Object level source control – controlling and tracking changes to your database design using a source control system

· Offline development – unlike the previous two, this method does not use a 'live' database. Schemas are developed by directly editing the SQL in the creation scripts,

It discusses the advantages and disadvantages of each approach and describes how we believe Red Gate's SQL Compare fits in to the model you choose to adopt, and improves it.

Have we got it right? Are there alternative techniques that we've unjustly ignored?

We'd really like to hear any feedback you've got to give!

Cheers,Tony Davis (Simple Talk Editorial Director, Red Gate Software)

Can''t read sql_logins and don''t understand why

Perry Christenberry — Mon, 25 Jun 2007 16:14:00 GMT

As an audit requirement, we're trying to get a list of all SQL users (across all databases) to our IT audit team. We can do this simply enough logging in as a user with sysadmin role, but we'd prefer not to give that role to our automated report writer user. So, we're trying to select from sql_logins and all we get is sa and the report writer user (instead of the 91 users we should get). We've tried everything we know -- granting permission to sql_logins directly to the user, setting up a new group with permissions to the view & adding the user to it, etc. All to no avail. Any suggestions? Is this no longer possible? Thanks in advance.

Use Red-Gate''s backup... and Go to Jail???

Bob Boule-412584 — Mon, 26 Feb 2007 11:20:00 GMT

Edited by the Editor

I have removed this post, which is a copy of a blog post from InfoWorld that questions Red Gate licensing.

Questioning this is ok, but disclosure is preferred. As is posting under the Red Gate forum for discussion. The author, Bob Boule, is product manager for Litespeed. You can read the blog post here: http://weblog.infoworld.com/dbunderground/archives/2007/02/use_redgates_ba.html

Steve Jones

SQL Refactor for MVPs?

Dinakar Nethi-176633 — Thu, 10 May 2007 13:20:00 GMT

Is there any free version of SQL Refactor available for MVP's? I had the trial version and reformatted lots of code and now the trial period has expired []

SQL Prompt

Michael Lysons — Tue, 13 Mar 2007 02:40:00 GMT

Does anyone have anything to say about this product? I won a copy from SSC and I've given it a little go over the last few weeks, but it's not lived up to my expectations.

Simple things don't seem to work consistently and this is very frustrating. For example, the software regularly 'forgets' that I have told it not to auto-start when QA opens. As it takes too long to initialise a database, this gets very annoying as I keep having to reach for the off button.

The software also has trouble remembering my preferences for formatting etc, so when I do use it I find that all my T-SQL appears in upper case and I then have to trawl the menu to sort that out.

As this is such basic functionality, I'm wondering if there is a problem with my PC not remembering these changes, but no other software has this trouble.

The performance of SQL Prompt is what has prompted me to finally stop using the software. It takes an age to initialise, even if I open a new QA window that is connecting to an already initialised DB, that I'd rather switch it off than wait. I've also found that when switched on it interfers with the movement of the cursor, as it jerks about when scrolling/moving through T-SQL queries. Perhaps I can overcome this by more careful tuning of the options? But, if it isn't going to remember those options then I can't see me using it again.

Thoughts anyone?

EDIT: Re-reading this, I've made it sound like SQL Prompt is rubbish and doesn't work: This isn't the case. It works very well when initialised, but the simple problems highlighted above are enough to put me off using it.

Log Rescue

Christopher Robin — Tue, 23 Jan 2007 07:49:00 GMT

Been using this software for a while and it has saved me many hours of work both in production and development environments. Anyone else have any experience using this???