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.

Share tech news, updates, or what's on your mind.

Sign up to Post


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.
OWASP: Forgery and Phishing
LVL 12
OWASP: Forgery and Phishing

Learn the techniques to avoid forgery and phishing attacks and the types of attacks an application or network may face.

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.

How many times a day do you open, acknowledge, or close an IT incident? What’s your process? Do you have a process depending on the incident, systems involved, and other factors? New Relic Alerts gives you options for how you interact with notification channels for sending alerts.

Alerts is a new tool to manage your alerting policies and integrate with team communication tools like xMatters, HipChat, Slack, and more—so you can immediately let the right people know when critical issues arise.

We’re pleased to announce that xMatters is an official notification channel in New Relic Alerts.

With the new integration, New Relic provides a notification channel that you can use to manage your xMatters integration and communication plans easily. You can also use custom payload webhooks to control how the xMatters alert is delivered.

xMatters allows you to automate and structure communication as events unfold during a deployment or service outage. New Relic enables you to manage alerting policies and integrations, while still providing industry-leading insights.

How it works
With New Relic Alerts, you can choose the communication tool and easily set up the integration.

xMatters has a similarly easy interface for setting up an integration with New Relic.

Reaping the benefits

New Relic integrates with xMatters to replace manual steps in incident management processes:

  • Notify resolvers based on escalation rules, on-call schedules, skills, and location
  • Enrich notifications with insights from New Relic and other tools in the IT toolchain, to provide actionable content and increase resolver efficiency
  • Configure response options that trigger other xMatters integrations and drive workflow for tasks such as creating tickets, updating consoles, sending additional notifications, and initiating chat & conference-call collaboration all with context from New Relic alerts
  • Use the xMatters mobile app to quickly look up who’s on call, receive & respond to notifications, and engage other teams to minimize time to resolve service disruptions
  • Continuously improve operational processes with reporting & analytics
  • Allow stakeholders to manage subscription and notification preferences for proactive communications during service disruptions

xMatters is now available as a New Relic Alerts notification channel. Please visit https://www.xmatters.com/integration/new-relic for more information.


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 ?

My development tool is powerbuilder 11.5
I'll create chart in powerbuilder, but with eyecatching or much fiture. ;-)

So, I Want to use chart component - ocx form third tools.. such as (fusionchart, teechart, or other tools) ,
Note. platform application desktop version,

if any source code please share..

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 ?
Hello All,

Can any one tell me how to call jenkin parameter value into the groovy script

I'm creating a jenkins job that give permission to a another job to a particular User.

below pic shows the parameter. i want to call this parameter value into the groovy script

Find the script below.

        import hudson.model.AbstractProject
        import hudson.model.Item
        import hudson.security.AuthorizationMatrixProperty
        import hudson.security.Permission

        AbstractProject proj = hudson.model.Hudson.instance.getItem("testjob")
        AuthorizationMatrixProperty authProperty = proj.getProperty(AuthorizationMatrixProperty.class)
        Set<String> users = new HashSet<>();
        Map<Permission,Set<String>> newPermissions = new HashMap<Permission, Set<String>>()
        newPermissions.put(Item.READ, users)

        proj.addProperty(new AuthorizationMatrixProperty(newPermissions))

That parameter value should have to come here [ ->('userid')<-here in the groovy script]

can any one tell me how to call jenkin parameter value into the groovy script

Thanks in advance
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
CompTIA Network+
LVL 12
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

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,
I'm planning to parse Cisco switch(3120x Blade Switch) configuration. How can i do this? Which tools i needed? Can i find an example?
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.............
Learn SQL Server Core 2016
LVL 12
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

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, …

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