Thanks for the link.Ī comment above states that SQL-Prompt will only work in English versions of the Query Analizer only. this should have been around a long time ago. Ī nice tool to fill the gap between now and the RTM of the LINQ project :) I shared it with everyone in my office and everyone has had nothing but raves so far. The newsletter indicated that it was purchased technology, that RedGate will work over and charge for later. I found out about this tool in one of their newsletters. I have been using RedGate SQL tools for about 2 years now and I love them. I thought it was cool how it auto-completed inner joins with the relevant keys/foreign keys. Then you'll get a prompt to log into your remote database. You may need to be enable tcpip to the database, or start typing a query and hit ctrl-space. Even worked for me over the internet, no less. I wonder when Microsoft with release a true intellisense SQL Editor. Now I see the same product packaged with Red Gate Logo with a slightly different Options screen. Because i could not observe the intellisense when i used it on the server. Is this tool, used for local databases only or for the databases existing on the servers as well. The tool works great with sql server management studio.Īs for the marketing problem as written above by paul,well i would only say there is no free lunch ! u can always give fake info to register ! ! ! I'm definitely going to get benefit from this tool. I think the objections expressed in a few of the other comments are a bunch of hooey. Except one: when I type PRINT I don't get any intellisense. This tool worked nicely in SQL Server Management Studio, and performed all the tricks shown in that animated gif. This is what I was looking for in so many time. Scott, I don't know how to thank you !!!. SQL Prompt only work with English language versions of SQL Server I've always been frustrated that when I press Ctrl-Space in SQL Query Analyzer it doesn't do syntax completion like Visual Studio does. Not a commercial endorsement, just an avid fan and user. I also personally recommend Apex SQL Edit - it's a good tool with auto-completion and supports fun things like unit testing, integrated source control and other fun things. HOWEVER - it is a great idea, and it is a very useful tool. Changing table or view aliases after resolving the suggestion list the first time seems to confuse the product, and using an alias for a table or view that is the only one included in a query doesn't seem to work all the time. You can set up databases on the same server to use the same credentials if you want, but each time you use a server for the first time you'll get kicked out of QA into the Prompt connection manager to connect.įinally, it seems a little brittle to me. The first time you connect to a database, you'll need to set up a connection in the Prompt tool. That means it presents an icon in the desktop tray and runs even when QA doesn't. It runs as a separate process, since QA doesn't really support a plug-in model. This is an interesting tool, but people should evaluate it pretty carefully.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |