I am happy to announce the new major release of dbMigration .NET v2. It is a simple, easy and intuitive multiple database migration and sync tool , With it you can easily migrate schema and data between different databases without complicated procedures. Supported databases: PostgreSQL, SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix, HP Vertica, NuoDB, Teradata, Sybase ASE, Firebird, SQLite, SQLCe, Access, dBase, FoxPro...etc.

Free, All-In-One, Portable, and Single executable file.

Major New features from version 1.1 to 2.3:

• Compatible with PostgreSQL 9.5
• Updated to Npgsql.dll 2.2.7
• Added Data Synchronization
• Excel, Generic ODBC and Generic OleDB support
• VIEW Objects support
• Added Automatically create indexes
• Added Saving Changes
• Added Skipping error rows
• Improved Automatically match columns
• Change Password prompt dialog when password expired
• Added Selecting multiple columns to Edit
• Added Auto Completion for Filter
• UPPERCASE and lowercase support
• Improved Automatic column matching
• Improved Filter source data
• (Command-Line) Default Confirmation Options (if the target table exists): -defopt:[rename/recreate/delete/append/sync]
• (Command-Line) Log mode and No window (DBMigration.log): -log
• (Command-Line) Exit Code: Success=0, Failure=1
• (Command-Line) Automatically create a target database (Firebird/SQLite/Access/SQLCe/Excel)
• (Command-Line) Automatically add source and target connections (Firebird/SQLite/Access/SQLCe/Excel/FoxPro/OleDB)
• ...and more

The new version is immediately available for download.

Postgres Professional (Postgres Pro), the Russian PostgreSQL company, has prepared binary Windows® builds of PostgreSQL. Versions 9.5.0 and 9.4.5 are available for download at http://postgrepro.com/windows. The installer sources are on github.

The installer sources contain the complete build scripts set. This allows everybody to build custom variants of PostgreSQL with any versions of all the required libraries including openssl, perl or python.

Toute l’équipe de VMware France vous souhaite une excellente nouvelle …

Read More

Register Now! In Q1, opportunities approved in Ad + until Feb. 29th count toward prizes… This means more prizes and more time to drive pipeline and WIN BIG. Also, to help kickoff your prospecting efforts in 2016, we encourage you to attend the V2M vmLIVE on Jan. 14th.

The post Attn NORAM Partners: Register Now for Velocity 2 Millions (V2M) appeared first on Partner News.

In recent years, businesses have been disaster-prepping for the certain doom and demise of email. The shift seemed inevitable: email is fundamentally flawed (hello, information overload), better technology exists and new generations are ushering in brand new ways of communicating.

Read more on Email’s Stayin’ Alive…and Evolving with Mobile Collaboration…

Each month, we share the top VMware Global Support Services (GSS) news, alerts, and announcements from our sister blog, VMware Support Insider. Read on to find out what you might have missed. New NSX KBs you need to know Check out this blog post for last month’s trending Knowledge Base articles covering issues related to […]

The post New NSX KBs, What’s New in vSphere 5.5 Update 3b and Top 20 KB articles appeared first on VMware Education and Certification Blog.

By: Eiad Al-Aqqad, Consultant Architect and Author of virtualizationteam.com. At VMworld 2015, VMware introduced the Hybrid Cloud Manager, however, with the excitement of the Cross-Cloud VMotion tech-preview that was shown at the same demo, many overlooked the Hybrid Cloud Manager announcement. In this post, I want to introduce you to the Hybrid Cloud Manager and […]

The post Hybrid Cloud Manager is your Bridge to the Cloud appeared first on VMware vCloud Air Blog.

It’s 2016, are you still installing VMware ESXi by mounting ISO images in a browser-based console? That’s probably fine for one-off efforts, and it sure beats making a trip to the datacenter with physical CDs, but network deployments are the way of the future. If you have not yet made the move to PXE deployments, […]

The post Technical Paper: Installing VMware ESXi 6 Using PXE appeared first on VMware vSphere Blog.

Are you ready to answer customer questions about next year’s hottest IT trend? Start your prep by watching this video.

The post Hot IT Topics for 2016: Network Virtualization and Micro-segmentation appeared first on Partner News.

If you want a quick and easy way to learn more about joint VMware | IBM solutions, join the new VMware IBM Partner Hub. This new sales enablement portal has been customized for IBM partners to go straight to the latest sales assets, training, and event information across the joint tracts supported by our alliance: […]

The post Announcing the VMware IBM Partner Hub appeared first on Partner News.

2ndQuadrant is pleased to announce the General Availability release of 2UDA 9.5.

2UDA (2ndQuadrant Unified Data Analytics) is a data analytics application suite that unifies databases, spreadsheets, data mining and visualisation in one seamless desktop installer.

This new release continues to provide easy installation of three open source applications for visual data analysis: PostgreSQL 9.5, Orange 3, and LibreOffice 5, which together offer a powerful combination of database, data visualization and spreadsheet in a single, easy-to-use package.

Following the General Availability release of PostgreSQL 9.5, the development team are pleased to offer a number of improvements to take advantage of the latest PostgreSQL features, creating a highly stable product and fixing discovered and reported bugs in previous releases of 2UDA.

Full release notes for 2UDA 9.5 are available at http://packages.2ndquadrant.com/2UDA/ReleaseNotes_9.5-GA_20160107.txt

We are particularly appreciative of users trialling 2UDA and providing valuable feedback to the development team, on all of the previous pre-GA releases. This has helped us to build a robust software package, the result of which is 2UDA 9.5.

2UDA 9.5 is available to download at http://2ndQuadrant.com/2uda

You’ll also find more details about the 2UDA project, including a tutorial to download.

In vRealize Operations Manager 6.1 we introduced a new construct called Custom Datacenter (CDC). I wanted to describe how to create Custom Datacenter objects, and how you would leverage these objects. The Custom Datacenter object can be created in the vR Ops UI, and you can add one or more Cluster objects. Not only can […]

The post vRealize Operations Manager Tech Tips: Tip #1 - Custom Datacenter object appeared first on VMware Cloud Management.

Machine learning will give cars the ability to analyze and learn from hundreds of thousands, even millions of driving situations to learn better than any human being can, Audi execs told the press at CES 2016 Wednesday. “In one year a 16-year old driver might encounter 1,000 situations with a four-way stop,” said Peter Steiner,… Read More

The post Audi: Machine Learning to Give Cars Superhuman Capabilities appeared first on The Official NVIDIA Blog.

27 technology sessions, 7 hands-on labs and access to a …

Read More

2016 has started out with substantial fanfarefor the vRealize Team. The vRealize suite was called out in the Baseline story as a key component of Tribune Media’s “software-defined everything” approach. The article features great quotesfrom David Giambruno of Tribune on benefits to date of adopting an SDDC architecture: “The SDDC platform has dramatically changed the […]

The post vRealize Automation: Tribune Media profile in Baseline Magazine appeared first on VMware Cloud Management.

What constitutes business-critical data for an enterprise today? A decade ago, the answer would be straightforward: the data associated with business-critical applications such as inventory management, email systems, financials, etc. IT was focused primarily on transforming business processes into efficient electronic workflows. Today, globalization is forcing enterprises to better optimize and personalize workflows to remain competitive (and relevant). As such, enterprise data today is no longer limited only to application-centric state — there is an exponential data growth in a new class of data that I refer to as “activity-related data” — data such as click logs, IoT sensors, supply-chain logistics, and other industry vertical data.The Big Data revolution has democratized the availability of analytics that enterprises are employing to explore and extract patterns, correlations, and other characteristics that can improve their business top-line and bottom-line. This paradigm is also referred to as “data-driven enterprises”. Given the changing face of enterprise data, the emerging solutions in the storage industry are analogous to “old wine in a new bottle” i.e., traditional data management solutions such as backup, DR, tiering, etc., being applied to the new breed of data. To clarify, traditional application-centric data will continue to be critical — the question we [...]

The post The Changing Face of Enterprise Data appeared first on Office of the CTO.

By Petr McAllister One of my customers successfully completed the VMware vSphere: Fast Track [V6] class. The customer provided a lot of positive feedback in regards to the class, and also about new functionality in vSphere 6. However, one thing was unclear: The instructor stated there is a maximum of 10 VMware solutions per vCenter. […]

The post Platform Services Controller (PCS) and vCenter Server 6 Maximums appeared first on VMware TAM Blog.

Acquiring and managing a secure cloud network is difficult no matter where you are. But for those who have operations in Latin America and Brazil, setting up and managing a true hybrid cloud can be especially complicated. Thankfully, there’s a simple solution, and that solution is this edition of the vCloud Air Network Service Provider […]

The post vCloud Air Network Service Provider Spotlight: UOLDIVEO appeared first on VMware vCloud Air Blog.

OpenStack’s security groups capability is a key feature in its support for multi-tenant workloads. Security groups are sets of rules that users utilize to specify access to their application infrastructure. This access is specified either via a classless inter-domain routing (CIDR) network range or by specifying the name of another security group. Let’s take a […]

The post VMware Integrated OpenStack Video Series: Security Groups appeared first on OpenStack Blog for VMware.

Happy New Year everyone! 2016 will be a very exciting year for Socialcast and we can’t wait to share all the new things currently in the works. But first, let’s take a look back at all the feature enhancements and mobile apps that were released in December to round out 2015.

Read more on Feature and Mobile Updates: December 2015…

7 JANUARY 2016: The PostgreSQL Global Development Group announces the release of PostgreSQL 9.5. This release adds UPSERT capability, Row Level Security, and multiple Big Data features, which will broaden the user base for the world's most advanced database. With these new capabilities, PostgreSQL will be the best choice for even more applications for startups, large corporations, and government agencies.

Annie Prévot, CIO of the CNAF, the French Child Benefits Office, said, "The CNAF is providing services for 11 million persons and distributing 73 billion Euros every year, through 26 types of social benefit schemes. This service is essential to the population and it relies on an information system that must be absolutely efficient and reliable. The CNAF's information system is satisfyingly based on the PostgreSQL database management system."

UPSERT

A most-requested feature by application developers for several years, "UPSERT" is shorthand for "INSERT, ON CONFLICT UPDATE", allowing new and updated rows to be treated the same. UPSERT simplifies web and mobile application development by enabling the database to handle conflicts between concurrent data changes. This feature also removes the last significant barrier to migrating legacy MySQL applications to PostgreSQL.

Developed over the last two years by Heroku programmer Peter Geoghegan, PostgreSQL's implementation of UPSERT is significantly more flexible and powerful than those offered by other relational databases. The new ON CONFLICT clause permits ignoring the new data, or updating different columns or relations in ways which will support complex ETL (Extract, Transform, Load) toolchains for bulk data loading. And, like all of PostgreSQL, it is designed to be absolutely concurrency-safe and to integrate with all other PostgreSQL features, including Logical Replication.

Row Level Security

PostgreSQL continues to expand database security capabilities with its new Row Level Security (RLS) feature. RLS implements true per-row and per-column data access control which integrates with external label-based security stacks such as SE Linux. PostgreSQL is already known as "the most secure by default." RLS cements its position as the best choice for applications with strong data security requirements, such as compliance with PCI, the European Data Protection Directive, and healthcare data protection standards.

RLS is the culmination of five years of security features added to PostgreSQL, including extensive work by KaiGai Kohei of NEC, Stephen Frost of Crunchy Data, and Dean Rasheed. Through it, database administrators can set security "policies" which filter which rows particular users are allowed to update or view. Data security implemented this way is resistant to SQL injection exploits and other application-level security holes.

Big Data Features

PostgreSQL 9.5 includes multiple new features for bigger databases, and for integrating with other Big Data systems. These features ensure that PostgreSQL continues to have a strong role in the rapidly growing open source Big Data marketplace. Among them are:

BRIN Indexing: This new type of index supports creating tiny, but effective indexes for very large, "naturally ordered" tables. For example, tables containing logging data with billions of rows could be indexed and searched in 5% of the time required by standard BTree indexes.

Faster Sorts: PostgreSQL now sorts text and NUMERIC data faster, using an algorithm called "abbreviated keys". This makes some queries which need to sort large amounts of data 2X to 12X faster, and can speed up index creation by 20X.

CUBE, ROLLUP and GROUPING SETS: These new standard SQL clauses let users produce reports with multiple levels of summarization in one query instead of requiring several. CUBE will also enable tightly integrating PostgreSQL with more Online Analytic Processing (OLAP) reporting tools such as Tableau.

Foreign Data Wrappers (FDWs): These already allow using PostgreSQL as a query engine for other Big Data systems such as Hadoop and Cassandra. Version 9.5 adds IMPORT FOREIGN SCHEMA and JOIN pushdown making query connections to external databases both easier to set up and more efficient.

TABLESAMPLE: This SQL clause allows grabbing a quick statistical sample of huge tables, without the need for expensive sorting.

"The new BRIN index in PostgreSQL 9.5 is a powerful new feature which enables PostgreSQL to manage and index volumes of data that were impractical or impossible in the past. It allows scalability of data and performance beyond what was considered previously attainable with traditional relational databases and makes PostgreSQL a perfect solution for Big Data analytics," said Boyan Botev, Lead Database Administrator, Premier, Inc.

Links

• Downloads
• Press Kit
• Release Notes
• What's New in 9.5

Contact

PostgreSQL Press Team press@postgresql.org Phone: +1 (347) 674-7759

About PostgreSQL

PostgreSQL is the world's most advanced database system, with a global community of thousands of users and contributors and dozens of companies and organizations. The PostgreSQL Project builds on over 25 years of engineering, starting at the University of California, Berkeley, and has an unmatched pace of development today. PostgreSQL's mature feature set not only matches top proprietary database systems, but exceeds them in advanced database features, extensibility, security and stability. Learn more about PostgreSQL and participate in our community at: http://www.postgresql.org.