Questions about any and all tools related to databases or the job of database administration.

learn more… | top users | synonyms

0
votes
1answer
41 views

SQL queries text log analyzing

I have a text log file (log4net) with many SQL queries in parametrized format and with stacktraces. It also contains output from other loggers which should be ignored. An example of one log entry: ...
0
votes
0answers
11 views

Is there a UI tool for moving data from two different tables?

The schemas in the two databases are different. Eg. Database 1 / users - id - name - phone Database 2 / users - id - first_name - mobile Is there a tool that lets me visually create the statements ...
0
votes
0answers
41 views

How to solve MySQL Utilities Error: Server is offline?

I've been working on a MySQL Server 5.7 Community Edition and I would like to use MySQL utilities. I've installed MySQL Connector/Python and MySQL Utilities, both from source. I've checked MySQL ...
0
votes
0answers
27 views

Efficient import of 1 million SQL files in Postgresql

I have a huge problem. I have 1 million SQL files varying in size from 9KB to 3MB that I need to import into one table very quickly. The files represent hundreds of billions of rows. Is there a ...
0
votes
0answers
3k views

Generating an ER Diagram from SQL CREATE TABLE statements

As I can't find any ER diagram feature built in with Apex, I want to create one with the SQL statements I executed in order to set up the tables in my Apex Workbench. I found schemaSpy, which is ...