We help IT Professionals succeed at work.

DB Dev Tools

Development in most programming languages is done with an editor or integrated development environment (IDE). Dev Tools covers issues with the use of that software, rather than the actual programming being written. XCode, Visual Studio and Eclipse are some of the more popular development tools.


I have searched the web for an explanation of the following and found no explanation.

In the adminer export dialogue it shows 'auto increment' and 'trigger' in the Table entry.

What does Auto Increment mean here? In tables using auto increment, does it mean to start from the last incremented value plus 1, or to begin again at a chosen starting point, or something else?

Also, what is a trigger in adminer?

Does anyone know how to create a script snippets in Outlook 2016?

I am building an application that will run on multiple instances of the same Mysql schema.  Same database schema, different data in each.  The goal is to keep each clients data in separate instances of the same database.  I have designed my model in MySQL Workbench and have been using the "Synchronize Model" function and that works OK, but i have to specifically push the changes to each instance of the DB.   As this grows that will become unmanageable.  

Is anyone aware of any database management tools that will allow me to push schema changes to multiple instances simultaneously?   Again, this is not replication as the data in each DB is different, i am looking for a way to push Schema changes only.

Thanks in advance.
Does anyone know how to convert Total Access Memo data from FMS to rich text so we can flip to 64-bit Access?  We have many documents that were created with the 32-bit control.   That is the only issue with converting my application and compiling into a 64-bit accde.

I'm not familiar at all with the above tools but recently discovered that a Messenger
software used by financial traders could attach volumes of files, ie risk of data leaks.

Anyone can share what risks & mitigations with using above?
I would like to export all the tables and column names of a said database to an excel file. What is the easiest way of going about this ?

I was able to locate the extension but the installation on DW CC 2015 fails.
It says that the info for the extension cannot be found in the database  :$

This extension is extremely useful. Is there any other way to have it back or will have to keep CS6 forever installed and have to switch between CC and CS6 whenever I need to add recordsets or update them ?

Is there any other extension or software that would be able to connect to the  DB and read/create sp and recordsets like CS6 used to ?
I have a SSIS 2014 Package created in Visual Studio 2013. I have successfully performed a simple Data Flow from one table to another. I am now wondering how to apply additional logic: 1. Check for Existence of data, then either update or insert new data into a table's column, and 2. Avoid data duplication. Any help on coding C# or T-SQL for this small, modest task would be greatly appreciated. Thank you.
Hello Experts
I'm looking more of an advice than an answer here.
We are looking to purchase a tool that can help with code migration - this can be DB procedure/ package/ views, DML, DDL statements and also take backups of all information before they are modified.
this can be one or combination of the above mentioned and can have a specific order of execution.
This tool should also maintain code and deploy into dev/test  and prod as needed.
Do you know if there is any such tool in the market?
This is to be run against 11g and 12C Oracle databases.
Thanks in Advance
Is there any db conversion tool out there to execute sql file from SQLServer to Postgres?
I am trying to use the SQL SSMS tool to connect to Analysis Services and Reporting Services. These should be part of the setup of "SQL Server 2012". However when I run the setup all I see is a  checkbox for "Management Tools - Basic" and I should see a sub-option for "Management Tools - Complete".  How can I get this option to appear. Here is a  screenshot of my setup screen: Setup screenshot
I am looking to manage all the patches on my SQL Server instances, and we don't have WSUS. Also, I need a way to make sure our local dev environment is at the same windows and SQL server patch level as the prod environment hosted in the data center (separate networks).

I would love it if there was a way to log all the updates installed per SQL instance in a database of some kind so I can get reports. I am not opposed to a roll your own solution, however I don't want to roll my own using powershell, then BASH gets to be the preferred method of Windows or Python or something and then I have to roll this solution again.

I have been hearing that windows server will be supporting bash script, I assume when this happens, most people will start using this. Also, using powershell to administer things has been great, however, I am not sure how I would manage the code of a powershell solution like this.

In a perfect world, I would love the ability to have a tool go get the updates and install them in DEV. We can then test and once we feel everything is good, we can just have a script that will execute the exact same update installation in PROD. Using windows updates has not worked for us in the past because at times we have to skip a certain update or by the time can roll to PROD there are newer updates that have not been tested. Also with windows update, I don't know how to to run a query where I can show all the updates that have been installed. I know I can …
He everybody.
To make a long story short, I have a product table with among other columns has prod_code, short_description and description. Now I have to select the prod_code where short_description or description are equal to a given value. I run this query in a loop where the given value changes depending on values of another table.

This is the query:
$sql = "SELECT prod_code FROM products WHERE short_description=\"" . addslashes( $value ) . "\" or description=\"" . addslashes( $value ) . "\"";

Open in new window

Once I have the prod_code I have to run a second query to update another table where I want to put the prod_code in the record which should correspond to the value used in the first query.
But since there are at least 2 products with an identical description (don't ask me why: clients are always right), this second query result wrong:

UPDATE es SET prod_code='SOLARGREEN' WHERE id='1118' is right short_description

UPDATE es SET prod_code='SOLARGREEN' WHERE id='1119' is right description

UPDATE es SET prod_code='SOLARBL' WHERE id='1120' is right short_description

UPDATE es SET prod_code='SOLARGREEN' WHERE id='1121' is wrong: this is the secon description identical to the one above and the prod code should be SOLARBL

I'm not sure if this makes sense or if it's quite cryptic: I tried to be as concise as possible.
If you need more info, I'll be happy to tell you everything you need.

Any idea about I can change the first query?

The problem is that there is at least 2 products which have an identical description so I end to have that
Hi Experts,

Is there any free / Paid tool that visualize SQL queries and make more complex queries easier rather than MS SQL studio? Looking for your recommendation.

Thanks a lot in advance.
Windows 7
Fujitsu iX500 Scanner, Model: PA03656-B005
ScanSnap Software, CardMinder v5.3L10

CardMinder generates SQLite databases (I believe). I want to be able to edit the database or merge elements from one database to another. Can you tell me what tool(s) will enable me to perform edit operations?

I called Fujitsu support, but they were not able to help with this issue. I tried RazorSQL, but I am not sure how to use it. Note that I have used mySQL for Wordpress using cPanel's phpMyAdmin, but only for lookup and very simple edits. I am not experienced with the Query language instructions or syntax and might need some help with this.
Hello all,

we have old exchange with EDB (2010) and we want to export all the mail boxes to PST can you please recommend on relevant utility.

Best Regards,
We have a C++ application which was originally developed on the VS 2008 platform.

We have since migrated to VS2013 and are finding that when the exact same code is compiled on the VS 2013 the application runs at a substantially slower speed.

Our developers are a little stumped by this, so can anyone suggest possible reasons for this?

They have done some investigation work but have not been able to resolve the issue; we did think that VS2013 compiled projects would actually run faster than when compiled using VS2008!

I know this is a little vague so I will attempt to add data related to any further information that you might need to help us out.

Thanks in advance.............
I have registered  using regsvr32 hashctl.dll  and getting the message that it has been registered but I am still getting the message " Unable to load hashctl.dll please make sure this file has been registered.
Is there any way to verify via registry ?
I am looking for a tool (library, free program, robust propriétary tool...)  able to access my banks, ask for my transaction data, retreive them and string them under an identical format whatever the bank in the world. NOTHING more.
Does this exist?  

Thank you for the help
I wanted to download dependencies from different location (maven and one from my custom), I added this in ,my gradle :-

 repositories {
    ivy {
        url "http://XXXXXXX.com"
        artifactPattern "lib/com/[organization]/[module]/[revision]/[artifact].[ext]"
        ivyPattern "lib/com/[organization]/[module]/[revision]/[artifact].[ext]"

and the compiling the jar as:-

 compile 'organization-name:module-name:1.0'   // I have used actual organization-name and moule-name in the code , here its only for representational purpose.

gradle build fails :--

FAILURE: Build failed with an exception.

* What went wrong:
Could not resolve all dependencies for configuration ':testCompile'.
> You cannot mix different URL schemes for a single repository. Please declare separate repositories.
I have both an on premises and a Visual Studio Online Team Foundation Server and I'd like to add my documents\WindowsPowershell folders to source control and I have no idea of how to do this.
We are currently developing an internal web tool and I want to be able to monitor performance and analyze the site from my local machine.  IE not install it on a server or have a tool that requires a .com outside our network.

I want to be able to ping the site and different pages to constantly check response times and see when it is either slow or non responsive.  Also any additional performance analysis tools would be welcome.

Just to reiterate I need to tool to be locally run on my machine and have it actively checking when I want it to.  Any thoughts?  I prefer a free ping tool but paid is fine as well.
So I have an xml document that looks like this:

I want to be able to read this file and load it to a dom document and based on a variable and the product node n times so if I wanted it to repeat 2 times it would look like this:

I am attempting to perform this with the below code but when I print out the new node, it looks like the original.
      public Element cloneXMLNode(Document d, String tagname, int numOfClones) throws TransformerFactoryConfigurationError, TransformerException, IOException{
            //get the last child node of the doc
            Node node = d.getLastChild();
            //normally this will be the same as last child
            Node product = d.getElementsByTagName("product").item(0);
            Element xml = d.getDocumentElement();
            int cntr = 0;
            //adding the product node to the last child n times
            while (cntr++ <= numOfClones){
            //uses the Transformer to print out the new node
            printNode(node, "C:/Test/nodeonly.xml");
            //replacing the new node with the original
            d.replaceChild(node, …
I am attempting to run a jmeter script that I inherited and I do not seem to understand the issue that it is complaining about. This is the error I see in the log:

15/11/12 10:23:12 ERROR - jmeter.util.BeanShellInterpreter: Error invoking bsh method: eval      Sourced file: inline evaluation of: ``import org.apache.jmeter.services.FileServer; //Get Var CHANNEL_ID = vars.get("C . . . '' : Object constructor

And this is the code that I see it is complaining about:

import org.apache.jmeter.services.FileServer;
//Get Var
CHANNEL_ID = vars.get("CHANNEL_ID");
CS_ID = vars.get("chsdetId");
promasId = vars.get("promasId");
ADDRESS_ID = vars.get("ADDRESS_ID");

// Open File(s)

f = new FileOutputStream("DBValues/SFTPChannelServerIDs.csv", true);
p = new PrintStream(f);

// Write data to file
p.println( CHANNEL_ID + "," + CS_ID + "," + promasId + "," + ADDRESS_ID + "," + "SFTP");

// Close File(s)

I am not sure what the problem could be.
Windows 7 Desktop
Firefox v42.0
Firebug v2.0.13

When I attempt to view the CSS code for an element in its hover state, I've enabled the :hover option, then I hover the mouse cursor over the element in the browser window above the Firebug console. The code then appears in the console side panel. However, as soon I move the mouse cursor to that console sidebar so that I can select and copy the text of the code; that code has already disappeared (because the mouse is no longer hovering over the element.)

How to make the CSS :hover code display persistently (freeze it) in the side panel so I can highlight, then copy and paste it?

Firebug Side Panel with Hover option enabled

DB Dev Tools

Development in most programming languages is done with an editor or integrated development environment (IDE). Dev Tools covers issues with the use of that software, rather than the actual programming being written. XCode, Visual Studio and Eclipse are some of the more popular development tools.

Top Experts In
DB Dev Tools