Interested if anyone has used VSTS Database Edition extensively and, if so, which features did you find the most useful over the standard Visual Studio database projects? What are the most compelling features as opposed to alternative schema management options or tools like RedGate's SqlCompare etc? Edit: Microsoft just released the RT...
Is there any way to use a query and join two tables that is in two different database on the same server for DbVisualizer? I used the following for the SQL server Select * from table union select * from datbase.dbo.table2 I tried this for the DbVisualizer, and it didnt work. How do I do this? ...
I love Oracle SQL Developer so I find myself using it a lot to complete my daily tasks. The thing is that my collection of custom snippets only keeps growing so I though it'd be interesting to learn how to backup them. Before asking blindly I did a bit of work trying to figure out how. I've performed a search within the application's fo...
We use VSTS Database Edition to version control our database schemas. I like the idea of how it is supposed to work but have a big issue with the Schema Comparison feature. I like to use it for my deployments to see what has changed in the project vs a target database. Unfortunately, it shows many changes for objects that have not been c...
We use VSTS 2008 with SP1 and GDR R2 installed. Found the next problem: 2 identical databases (for example Database1 and Database2); Database1 is a working database, Database2 is a production one; adding a new stored procedure to the Database1 with comments (description, author etc. before the CREATE PROCEDURE statement); trying to c...
Hi, I am looking for tools to auto-tuning for postgresql database. Do you know any tools for postgres like DB2 Design Advisor in DB2, Database Tuning Advisor in Microsoft SQL Server or SQL Access Advisor in Oracle? Thanks for any links and ideas:). ...
I'm looking for a simple database admin tool that will allow non-technical users to perform data-entry into a database (imagine a striped down version of phpMyAdmin). It would preferably allow the developer to set restrictions on which tables and fields can be modified. Edit: Most of the tools posted, so far, are developer oriented. I'm...