SQL Assistant & DBPro

Question

SQL Assistant & DBPro

Grant Fritchey

SSC Guru

Points: 398882
More actions
August 27, 2007 at 12:28 pm

#93548

We've been doing more and more of our development in the new Team Edition yada, yada, yada, what was called DBPro or Datadude. Regardless of the name, we've found it to be a terrific tool. Unfortunately, most of the third party tools like RedGate SQL Refactor & SQL Prompt (fantastic tools, BTW) don't work with it.
I just found one that does. SQL Assistant from SoftTree technologies. Now it's a little odd in the way that it works with it, but it does work. You actually have to create a new "Target" for the tool to understand that the SQL windows in DBPro are actually objects with TSQL inside them. And, I found I had to actually deploy a database so that SQL Assist had a place to look to for some code (because I didn't want to refer it to the db created by DBPro for internal use). So, all in all it was a bit of pain to set up, but then I had a nice little code formatter & type ahead utility to speed up my development in DBPro the same way I've been using the RedGate tools.
I just thought I'd share this one because I was pretty excited that I got it to work. Others might be in the same boat. Before anyone asks, no I don't work for these guys or anything else like that. I got an evaluation license and I'm evaluating.
"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

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

lholman SSCrazy Points: 2810 More actions · Answer 1

hey Grant,

i wasn't aware that DBPro doesn't support the RedGate tools, the other Team Editions seem to, in actual fact i've seen Team Edition for Software Testers with RedGate SQL Prompt running, do they fail when installing or just not function?

Surely you don't need the refactor as DBPro has that built in, begs the question why MS haven't added intellisense support for SQL in DBPro, maybe they have an "Agreement" with the ISV's not to.

ll

lholman SSCrazy Points: 2810 More actions · Answer 2

just found this which backs up your statement http://www.red-gate.com/products/SQL_Prompt/faq.htm

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 3

Hey,

I see you found the the thread over on RedGate. It is disapointing that the RedGate tools don't work with DBPro, yet. From the MSDN Forums for DBPro, I get a pretty clear indication that the MS guys are looking at creating intellisense for the tool.

In the mean time, until RedGate gets a fix in, this tool is an option.

BTW, this tool also does code formatting similar to RedGate's SQL Refactor. It provides you with a whole series of templates that you can edit. It makes it more flexible and a bit more powerful than RedGate's tool, but a real pain in the tucas to use. I just wanted to swap the comma's from trailing to leading and I would have had to edit 10 different templates. Suffice to say, I'm still using RedGate's tool.

"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

Bart Read SSCommitted Points: 1628 More actions · Answer 4

We've actually done a bit of a back-peddle on this - the next release, due within the next two weeks or so, will work with Data Dude. It'll need a live database connection rather than working with the offline model, but you'll get the support you're after. Reason is that from a technical perspective it's easier to support Data Dude than not, although they appear to have monkeyed slightly with some of the editor operations so we have run into the odd problem.

Thanks,

Bart

Bart Read SSCommitted Points: 1628 More actions · Answer 5

I've also now blogged, in passing, about the Data Dude support, amongst other things:

http://www.simple-talk.com/community/blogs/bart/archive/2007/08/31/36009.aspx

Thanks,

Bart

Bart Read SSCommitted Points: 1628 More actions · Answer 6

maybe they have an "Agreement" with the ISV's not to.

If only.

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 7

That's excellent. I've really enjoyed using your program and I missed it terribly when I spent time (more & more lately) in DBPro.

For what it's worth, I'm still using RedGate's SQL Compare & DB Compare because the MS offerings within DBPro are simply not good enough for anything except capturing objects to move into a DBPro project.

Now, when's SQLPrompt going to get the code formatting out of SQL Refactor? That's gotta be next on the hit parade.

"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

Bart Read SSCommitted Points: 1628 More actions · Answer 8

Try this on for size:

http://www.red-gate.com/MessageBoard/viewtopic.php?t=5606

We've just put out a new EA release of SQL Prompt 3.6 with the promised Data Dude support. Any problems please let me know.

Thanks,

Bart

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 9

Excellent. I'll get it plugged in as soon as I can.

"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