New answers tagged

0

I agree with John and Phil. You should document your plan for migrating your database and ask your sales rep. However, if you use a SAN, you could shutdown your database, mount the LUNS on the new server, copy over the Oracle home and related directories and then startup your database on the new server. It sounds like you are running Oracle on a physical ...


0

pg_dump will create a file with the queries that are needed to recreate the state of your database. The file will look like a transaction or write ahead log. pg_dump databasename > dumpfilename pg_restore then will use this file to recreate your database. It's also useful to migrate to a newer database version you could also use psql newdatabasename &...


0

There is certainly no such service by Oracle as they wouldn't want anyone to migrate away from their own database system. MariaDB Corporation has a paid migration service to help migrating to MariaDB. This is run by experts in the field. AWS has a fully automated service that appears to be able to migrate your schema and data, but presumably not much ...


1

This is now possible with tools like Ghostferry: https://github.com/Shopify/ghostferry


0

The tutorial refers to changing an existing database. New tables will not be created unless they did not exist before. But in general, a database migration involves moving a database to an entirely different platform (i.e., SQL Server to MySQL) or a major version release (i.e., SQL Server 2008 to 2016 or MySQL 5.6 to 5.8). Major releases are typically ...


2

You can generate a BACPAC using SqlPackage.exe or the Export Data-Tier Application wizard in SSMS. There are some limitations on what objects can be exported, however, in general, you will be able to export most of the objects in your database. This is similar to MattyZDBA's answer except in a BACPAC the schema and data are wrapped in a single file and you ...


2

BCP by itself may not be sufficient as it won't address non-table objects like stored procedures. To migrate the schema, one option would be to use a Visual Studio database project importing it from the 2016 instance and deploying it to your 2012 instance. Afterwards, two options to import your data rows are BCP and the Import/Export wizard in SSMS.


0

What you are looking for is called ETL (extract transform load) tool https://en.wikipedia.org/wiki/Extract%2C_transform%2C_load There is no FREE/open source pre-built tool that exist to do what you want when moving data from different databases that I am aware of. I have used the paid for ETL tools they just speed up the process coding/typing time. The ...


0

For linux (as root user) Stop mysql service through systemctl rsync or cp -a the whole of /var/lib/mysql to your preferred destination. mv /var/lib/mysql /var/lib/mysql-old edit mysql configuration file and change datadir= under mysqld Start mysql service through systemctl.


2

The information seems to be inaccurate. Oracle has only three numeric data types: NUMBER: binary coded decimals. Slow, but exact. BINARY_FLOAT: IEEE single precision floating point number. Fast and quite imprecise. BINARY_DOUBLE: IEEE double precision floating point number. Fast and less imprecise. You can use INTEGER, DOUBLE PRECISION, REAL and FLOAT in ...


0

I referenced the following link which gave me clues to determine the source encoding and then convert it into the desired UTF-8 encoding. Linux Check and Change Encoding $ file -bi cabot.sql text/plain; charset=utf-16le $ iconv -f utf-16le -t utf-8 -o converted.sql cabot.sql $ file -bi converted.sql text/plain; charset=utf-8


0

This is to be expected and no problem. When logical replication starts, it copied the existing data from the source tables. The data in the target tables will then be densely packed and consume less space. As replication proceeds, the target tables get modified and “dead tuples” will accumulate and be removed by autovacuum. The tables will ...


0

Just to let you know that I've found the issue: related tables on the new server were not broken so everything worked "fine", but the indexes needed to by repaired after the copy from old server (probably because of the big MySQL version upgrade). I just ran mysqlcheck -A --auto-repair and the perf are at least equivalent now! The EXPLAIN SELECT doesn't show ...


2

You cannot add a Linux system to a Windows cluster, so you won't be able to add any Linux systems into a SQL Server 2014 availability group. You also cannot do the migration with distributed availability groups because SQL Server 2014 did not have support for distributed availability groups. From Distributed availability groups: Because the distributed ...


Top 50 recent answers are included