Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [migration]

the process of moving databases or data from one place to another

Filter by
Sorted by
Tagged with
2
votes
1answer
79 views

How to use mysql to migrate database changes from local databases?

I am working on a project with a few people and we have got the point where we all have different local versions of our website database and wish to get these changes to the server, after searching ...
1
vote
0answers
48 views

Migration of SQL Server Database

We have a situation here our application is working on SQL server on a cluster environment. Now we wish to migrate the database to a standalone environment, we have approx 2850 databases 1.6 TB in ...
3
votes
3answers
235 views

Migrate 7TB of Database for Colo Migration [closed]

We are going to migrate our data center from one state to another in next 3 months. I wanted to know, what is the best possible way to migrate one of our biggest database (i.e. ~7TB in size) as ...
3
votes
2answers
936 views

Migrate replication from SQL Server 2008 R2 to SQL Server 2016 - Old to new hardware

I will be working on a project shortly that would involve moving the replicated databases off of old to the new SQL Server instance. I haven't done this in the past so I don't have much knowledge ...
3
votes
1answer
791 views

Sybase ASE to Microsoft SQL Server Replication

I am currently working on several projects to migrate legacy applications from a Sybase ASE (12.5 and 15.0) to a Microsoft SQL Server 2014 platform. There will be a need to replicate data in both ...
3
votes
1answer
66 views

What is the proper type for columns holding GeoJSON?

What data type do you prefer for columns holding GeoJSON information, in the major RDBMS families (i.e. Oracle DB, PostgreSQL, MySQL, SQL Server, SQLite, DB2..? In general, do you prefer / is better ...
0
votes
1answer
247 views

Importing CouchBase dump to BigQuery

After creating a CouchBase dump and copying it to a Google Storage bucket I tried importing the data to BigQuery. I failed miserably, apparently the design.json or the files that appear in the same ...
2
votes
1answer
494 views

Data Warehouse - DB2 to SQL Server: how & what impacts on ETL? [closed]

I'm working towards migrating an IBM DB2 database to SQL Server, however the DB2 database sits in a Data Warehouse environment. As I am very new to Data Warehousing, DB2 and DB Migration between ...
-3
votes
3answers
251 views

How to administer large databases? [closed]

This is my situation right now: I'm working with SQL Server 2012, and I have 2 databases, one is 3.5 GB and the other one is 7.6 GB, and the company I work with is going to migrate the server to a new ...
2
votes
2answers
3k views

Create bacpac from SQL Server 2008

Is it possible to export bacpac file from SQL SERVER 2008 (running 10.50.6220)? I can only see option for dacpac.
3
votes
1answer
230 views

Migrating from Postgres 8.4 to 9.4 in different data centers

I'm trying to migrate a Postgres 8.4 database in a Brazilian machine to Amazon RDS Postgres 9.4 in North Virginia. The database uses encoding LATIN1, tablespace pg_default, lc_collate and lc_ctype C. ...
-1
votes
1answer
166 views

Move data chunk from table with 200+million rows to a new table MySQL

Our DB is hosted in AWS MySQL RDS. The data is such that each company that signs up gets its own set of tables which then receive enormous amount of data in them. Currently we want to move a chunk of ...
2
votes
1answer
5k views

Changing IP address of SQL Server 2012

I administer a Microsoft SQL Server 2012 instance on VMWare, and I need to change the IP address. Reading similar questions here on the site I am hopeful that the change will be a simple one, but my ...
2
votes
2answers
80 views

Migrating SQL Server databases

We have a handful of SQL Server databases. Probably not relevant but just for info: OS: Windows Web Server 2008 R2 RDBMS: SQL Server 2012 Express My question is: When using SQL Server Management ...
0
votes
1answer
26 views

how to Upload xml data to db Table by check primary key in oracle

i want to upload xml file data to db table by checking the primary key and wants update the each row data.Here trid getting as a primary key.example OFF 1133 2388977 is their any solution ...
0
votes
1answer
51 views

Updating data when data is from an external source

A government organization provides data in a series of files which can be re-engineered and imported into a database. The files are updated monthly. I have been able to reengineer the database in ...
2
votes
3answers
32k views

Bypass MS Access 2GB file size limitation

I am creating a MS Access *.accdb database with multiple tables and specific relationships. This database will be used for a one time data transport to another system, containing order of a few ...
1
vote
1answer
113 views

Why is my dev server faster than a much more powerful RDS?

I'm running a huge data migration. Probably ~100 million rows total across a few dozen tables. There is a lot of reformatting. About 50% of it is done through PHP while the rest uses INSERT INTO... ...
0
votes
1answer
197 views

How to make datapump apply directly to the destination schema

I have a schema on a server that returns and half I need to replicate it to another server, so I'll la and do an expdp on server1 sending the file to server2 and do an impdp. Solve the problem. ...
2
votes
1answer
65 views

Migration to new database

We have a weird situation. We have an old database and new database both different schemas (SQL Server). We are using abinitio to replicate data from old to new. Now if for some reason the new ...
2
votes
1answer
84 views

How to do a SQL Server 2016 continuous upgrade

I watched this channel9 video, and it mentioned you could now do a continuous upgrade to MS SQL Server. This allows you have a side by side install and it will keep the databases in sync until you ...
1
vote
0answers
33 views

Options for transferring/transforming from one database to another?

We have a hosted instance of intersystems-cache. There is an aggregate log that is near 600 million rows and is rather abstract and complicated. I am planning to parse this log and store more ...
2
votes
1answer
1k views

How to execute alter database commands from DbUp scripts?

I am using DbUp to maintain and upgrade my SQL Server 2016 databases. Typical SQL scripts that I have executed so far included tasks like creating tables, creating or altering stored procedures, etc. ...
1
vote
1answer
39 views

Database migration program, that can analyze source and target db, and tell diff [closed]

I'm looking for a program that can help with migration of both database schema and data from a source db, to a target db. And it has to be able to do it while target db stays live, all the time. So ...
3
votes
1answer
210 views

Upgrade and migrate SQL Server 2014 AlwaysOn AGs to SQL Server 2016, using the existing WSFC name

Here are the components: WSFC Name: SQLPROD1 Existing Nodes in this "cluster": SQL2014OnSite and SQL2014OffSite New Nodes to be added (?) to SQLPROD1: SQL2016OnSite and SQL2016OffSite All 4 servers ...
4
votes
2answers
1k views

Need Help Finding a Replacement for sys.sysprocesses

The SQL 2016 Data Migration Assistant (Upgrade Advisor) is saying that I need to stop using old system table references. Namely, it wants me to stop using sysdatabases and sysprocesses. I have some ...
1
vote
1answer
134 views

Migrating SQL Server 2008 databases to new 2-node WSFC SQL2014 Alwayson AG

I am currently working on migrating our single FCI Prod SQL Server 2008 Enterprise instance (on Win2008) multiple databases (>2TB total) to a new 2-node WSFC cluster (Win2012 R2 & SQL2014 ...
1
vote
0answers
215 views

MongoDB: removeShard when dbsToMove is an empty array

Background: Two empty shards with no explicit sharding scheme - shard0000 and shard0001. mongorestore a single database, all of which defaults to shard0000 Add a shard key to one collection and let ...
1
vote
1answer
78 views

Dependency management by decoupling table name from table key

If I share a Google Spreadsheet with someone, I will share a link like this: https://docs.google.com/spreadsheets/d/1UL0Aii1aaErbUm6pdmZ_D9dsqx2p3BPZ5GHxz7TH37M/edit This means that I am free to ...
0
votes
1answer
826 views

After migrating from MySQL 5.7.16 to MariaDB 10 database fails to start

MySQL Server Version is 5.7.16-0ubuntu0.16.04.1 (Ubuntu) I want to switch over to MariaDB, but I can't get MariaDB to accept the existing database. I also tried doing a slow shutdown with InnoDB ...
3
votes
1answer
909 views

Renaming table and putting a view in its place on Postgres

I have a very central table in our database that is used by a range of applications, it has rules attached to it, triggers and all the dependencies that you can imagine. Now I would like to modify the ...
2
votes
3answers
13k views

Easiest way to import access db (.accdb) into SQL Server 2016?

I have a .accfb file from an access 2016 database and am trying to import this database into a SQL Server 2016 developer edition instance. While I found posts online discussing using import/export ...
0
votes
1answer
1k views

Data Migration and altering tables in one SSDT deployment script

I'm using SSDT and MS SQL Server 2012. And I need to handle next cases in one deployment script: --1 CREATE TABLE Table1 (Col1 INT) --2 INSERT INTO Table1(Col1) SELECT SomeCol FROM SomeTable --3 ...
1
vote
1answer
170 views

Is it possible to replicate data changes of a database with triggers using binary logs?

I'm tasked to minimize the downtime of the database update. Unfortunately, I cannot use pt-online-schema-change toolkit because some tables in the current database has MySQL triggers that does further ...
1
vote
0answers
875 views

fast way to migrate existing mongo cluster data to new one

Currently, I have a existing mongo3.0 cluster(using WiredTiger storage engine and directoryPerDB is true) as below settings: 3 x shards(rs01, rs02, rs03) 2 x mongos 3 x mongo cfg All the databases/...
3
votes
1answer
1k views

Fastest Way to Move Data from Current Database for Multiple Tables to New Database?

This is my first question and post so let me know if I can improve. I'll err on the side of providing too much information. I'm a fairly new DBA at my company, less than two years with the DBA team, ...
1
vote
1answer
813 views

Is it possible to achieve zero downtime when upgrading database schema using this method?

I am looking for a solution in achieving zero downtime schema upgrade with the assumption that every schema upgrade is backwards-compatible with the previous application version which makes things ...
1
vote
0answers
811 views

How to avoid downtime during postgresql upgrade

Im having a production PostgreSQL server 9.2, it has a few databases around 150GB. I want to upgrade this to 9.6, so I decided to upgrade this on QA server. I have installed PostgreSQL 9.6. Then ...
2
votes
2answers
93 views

Error while trying to export logins from SQL Server 2000 to SQL Server 2005

I'm trying to migrate logins from an instance in SQL 2000 to a destination instance in SQL 2005. I've used revlogin before as explained here: https://support.microsoft.com/en-us/kb/246133 (I'm ...
0
votes
1answer
51 views

Migrate data from MySQL to SQL Server, database names differ

I'm using SQL Server Migration Assistant for data migration from MySQL to SQL Server. I would like to know whether it is possible to migrate data from databases of different names but tables inside ...
1
vote
1answer
257 views

MySQL import and export data without update on insert

I have a table that updates a timestamp column on every insert. This timestamp is indexed uniquely with a few other columns and I am unable to import this table. I guess the mysql dump/import inserts ...
0
votes
2answers
38 views

Maximizing Availability on a Table When Changing Data Type

I'm looking for some advice on the best way to change the data type on a column from an INT to a BIGINT on a table with 220 million rows, as it has reached the upper limit of the INT data type. The ...
4
votes
3answers
406 views

Best way to merge tightly coupled SQL Server Instances

I´m looking for some recommendations or best practice for the following scenario: I need to merge several SQL Server 2014 instances into one (we are switching from many instances to a single ...
2
votes
1answer
662 views

Remove index fillfactor for Azure migration

I'm deploying a SQL Server database to Azure. I've tried to export to a .bacpac, but receive an error: fill factor set and is not supported when as part of a data package Using the script in this ...
5
votes
1answer
1k views

OLE DB error 0x80004005 using Copy Database Wizard

Background: freshly installed SQL Server 2012 SP3 on Windows Server 2012R2. Problem: When I use the Copy Database Wizard to copy a database from server2 to server2 I receive: While trying to find ...
-1
votes
1answer
548 views

Logical model in workbench

I have a physical data model of db in MySQL Workbench, how i can create an a logical model of this db(like in Allfusion data modeler(ERwin))? May be Sorry for my english!
9
votes
3answers
17k views

Migrating Data from SQL Server 2005 to 2016

I am new to administering SQL Server however I am comfortable with the SQL language and making SSIS packages. I want to migrate data from SQL Server 2005 to 2016. My question is do I need to worry ...
0
votes
0answers
61 views

Efficiently moving Data from CSV to SQL 2014

I am working on a requirement to transfer almost 1 TB of data from a CSV file to SQL server. Which is the fastest way to do this? I am considering bulk copy and came across this link which actually ...
1
vote
1answer
612 views

Ora2pg - migration Oracle db into postgreSQL without instalation of Oracle

I have sql file with structure:create table,insert into table, contrains, etc.... This script was generated in oracle, and my job is tranform this script into compatible script for postgreSQL. Does ...
3
votes
1answer
255 views

online Oracle database migration to different Oracle database release

We currently have the following environment Source data center: 1) OS: Oracle Enterprise Linux 5.7 2) DB: Oracle Database Enterprise Edition 10.2.0.1.0 3) Server Type: Physical Server 4) Data ...