Stack Overflow
Stack Overflow

Questions tagged [database-tools]

18 questions
19
votes
7 answers

What are the real benefits of Visual Studio Team System Database Edition (GDR)?

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…
RobS
  • 9,382
  • 3
  • 35
  • 63
11
votes
1 answer

Auto-tuning tools for Postgres?

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:).
pmoniq
  • 1,883
  • 2
  • 19
  • 22
4
votes
2 answers

SSDT: "Identifiers must include at least one name (for example, MyTable)"

Two days trying to find the origin of this error and can not ... My problem is the same: Link When i build my db project the following error occur: "Identifiers must include at least one name (for example, MyTable)" Build output: C:\Program Files…
Vinicius Gonçalves
  • 2,514
  • 1
  • 29
  • 54
3
votes
3 answers

Concept of In Memory Database and how to see if my data is being populated in HSQL DB?

I am using HSQL in memory database for test purpose of my application and using SQL Server as main database, now when am doing test then HSQL Database is being populated with same data that I have in my SQL Server, now I am trying to test particular…
Rachel
  • 100,387
  • 116
  • 269
  • 365
3
votes
5 answers

PostgreSQL schema design

What is your preferred way of designing PostgreSQL schemata? Would you recommend the use of specific graphical design tools or just design the schema on paper and create everything by hand?
akosch
  • 4,326
  • 7
  • 59
  • 80
3
votes
1 answer

VSTS database schema comparison not saving comments

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…
Oleks
  • 31,955
  • 11
  • 77
  • 132
2
votes
3 answers

Ad hoc querying Oracle PL/SQL - for SQL Server developer

I used to do Oracle development many many years ago. I have spent most of the past 15 years doing mainly SQL Server, and where I have done Oracle work, been insulated from the workings by Web services etc. My question seems to have been asked on the…
kpollock
  • 3,899
  • 9
  • 42
  • 61
2
votes
2 answers

VSTS Database Edition Schema Comparison

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…
Denis Fradlin
  • 376
  • 2
  • 8
1
vote
3 answers

How do I join two tables from two different databases?

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…
MrM
  • 21,709
  • 30
  • 113
  • 139
1
vote
2 answers

How to create a database diagram for SQL Server in Visual Studio 2015?

I need to make a Visual Studio application that connects to a database in SQL Server, and I've seen a lot of people use the "create database diagram" for this, but the option doesn't appear in my Visual studio. The option to create a diagram should…
Tammy Moscoso
  • 57
  • 1
  • 6
1
vote
4 answers

PHP - Where can I find a simple database tool that is easy for non-technical users to use?

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…
John Himmelman
  • 21,504
  • 22
  • 65
  • 80
0
votes
1 answer

Sqlite administration tool for inserting images from the file system ? (OSX or Linux)

Is there a free sqlite administration tool that let me easily insert/update images from the file system as blobs in certain tables ?. I am looking for a tool compatible with OSX and/or Ubuntu Linux.
Sergio
  • 8,532
  • 11
  • 52
  • 94
0
votes
3 answers

How to monitor SQL (which uses prepared stataments)?

When first developing an PHP app (MySQl, but using ODBC interfaces to allow for future expansion), I was simply assigning my SQL to a variable and calling odbc_exec(). That made debugging simple, as I just had to examine my variable $sql. Of course,…
Mawg says reinstate Monica
  • 38,334
  • 103
  • 306
  • 551
0
votes
1 answer

psql database setup and connection on fedora linux

I've recently started work on a project that requires a psql database. I've followed numerous guides on setting up psql database on fedora, and have got my db up and running. I am able to connect into it using sudo -u postgres psql the project I am…
user19660411
  • 9
  • 1
0
votes
1 answer

How to prevent DataGrip to show results from another query console?

When I have multiple query consoles open in DataGrip, I usually make several queries to database simultaneously. One query console - one query. When I execute query to database and switch the query console before I get the result from database, I,…
Yaroslav Zinchenko
  • 63
  • 1
  • 6
1
2