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

learn more… | top users | synonyms (2)

3
votes
1answer
67 views

Is replication a suitable method to move a SQL Server database to new hardware?

I need to move a live database with about 100 GB of data to a new machine. As I understand the easiest way to do that would be to take it offline, move the files and bring it back online. But: The ...
1
vote
0answers
48 views

How do I disable constraint checking during schema migration?

How do I disable FOREIGN KEY checking for the time of database schema migration? Currently I found engine-based commands like: PostgreSQL: SET CONSTRAINTS ALL DEFERRED; MSSQL: EXEC ...
1
vote
0answers
39 views

Reporting services database was NATIVE, now it's UNKNOWN

After migrating a database from Sql Server 2012 to Sql Server 2014, we found a little problem. It was told me that the reporting server was not used, so I just installed the SQL Server 2014 and ...
2
votes
1answer
36 views

Replace content of only one table with new version (should disable foreign keys?)

I have 2 tables. 2nd has foreign keys to reference 1st. I need to replace the whole content of the 1st table with the new version from another database. The new version satisfies all constraints and ...
0
votes
0answers
31 views

SQL Server 2000 Migration on Production [duplicate]

I have a couple databases on server1 and I want to put them on server2. Application is adding new data in every couple of minutes to databases on server1. I would like to not switch off application ...
1
vote
1answer
40 views

Migrate Postgres from VM to VM

I have 2 VMs, both are identical in structural terms (came from the same snapshot, nothing installed, upgraded or removed). One VM is "clean", never used. The other VMs was heavily used and it has ...
1
vote
0answers
64 views

How to speedup pg_dump big database

I've got big database (about 900GB), and when I migrate it to new server dump speed is not more than 2MB/s (very slow). Link between servers is 10Gb/s. The database contain 20 tables with different ...
5
votes
1answer
164 views

Set “Encryption Enabled” to FALSE…what can go wrong?

I'm migrating a database from SQL Server 2012 to SQL Server 2014 on the Same server. I'm configuring LOG SHIPPING on a database that is apparently encrypted: When setting the log shipping i got ...
3
votes
1answer
45 views

How to handle Schedules when moving Jobs to another server?

We are migrating our SQL Server 2008 R2 to another physical server. For this, I will script out all jobs and run it on the target server. My question is about handling the schedules: When a job is ...
0
votes
0answers
26 views

Slony PostgreSQL replication from Chile to US (between datacenters)

We are moving from a datacenter in Chile to one in AWS (in USA). We've already moved most of our servers but the database (PostgreSQL). As the source server is in a VMWARE environment, we took a copy ...
3
votes
1answer
64 views

MS SQL Server IP address change considerations

I am very new to MS SQL Server Administration and wants to learn on Migration of SQL Server in detail. We are in a Datacenter migration Project where the Windows server (SQL Server is residing in it) ...
2
votes
1answer
85 views

SQL Server Database Migration - Backup/Restore while Original DB still in Production

I have a very large DB in full recovery mode. My SQL Server is 2008 R2. The thing is that I need to migrate to a new server while having the original DB still in production. Both backup and restore ...
3
votes
1answer
46 views

Agent shows disabled(although it is not) after migration

I am migrating our old server to a more reliable and powerful new server. SQL Server edition and build number stays the same (SQL Server 2008 R2 Standard). For this I followed the steps given in this ...
0
votes
1answer
161 views

Migrate/Export DB from Oracle 11g Enterprise to Oracle 11g Express

So I'm a DBA newbie and I've got an Oracle Enterprise server running in production with the following information under All Reports -> Data Dictionary Reports -> Version Banner, under ...
0
votes
2answers
92 views

Database Migration - Can it be this easy?

We have an old SQL Server 2008 server that needs to be replaced, and as the sole developer (and by extension DBA), I have been asked to figure out the best way to move the 5 databases to a new server. ...
0
votes
0answers
15 views

How to migrate logins ( not users ) from one instance to another? [duplicate]

I have lots of instances here where I work, and I'm planning to put all of them into just one. I will migrate all databases from these instances to only one instance. Ok, I can do this (I will ...
0
votes
2answers
27 views

Migrating Pure PHP Site with Associated Database To New Server

First, let me say I'm not a DBA or network admin, but have moved large scale CMS websites from host to host. But, I have never moved a pure php coded database driven website from one host to another. ...
0
votes
1answer
79 views

How to skip/ignore duplicate records on insert based on a generated string

I have hundreds of millions of rows in one table (snapshots_old) and I want to copy it to another table (snapshots), with one new column (snapshot_id) for which values will be generated while ...
8
votes
2answers
240 views

Moving Databases to New Datacenters

My company is moving our infrastructure to new data center and I am trying to figure out the best way to keep the database on the new server in sync with the current production database until the new ...
2
votes
1answer
57 views

Migrate a schema structure from one server to another MySQL

We have two Database environment server (Development and Production). Production DB is already being used in Production(means it already has production data etc.). My question is, is it possible to ...
0
votes
1answer
100 views

Microsoft SQL Server -> Postgres Data Migration

I have data in a Microsoft SQL Server that needs to be migrated to Postgres. The problem is that the SQL Server gets continuous updates and is hosted on our local net, while the Postgres instance is ...
0
votes
0answers
34 views

Which would be a recommended approach for migrating a Postgresql database from one server to another?

We are moving out of our current dataserver based on Santiago, Chile to Amazon (AWS) in North Carolina, all other servers have been successfully migrated with no problem, but our "migration consultant ...
3
votes
2answers
1k views

Schema Migration: SQL Server Data Tools vs Liquibase and Flyway

This might seem like a stupid question, but I've been looking into open source solutions for schema migration, namely Liquibase and Flyway. However, my boss told me that SQL Server Data Tools (SSDT) ...
0
votes
0answers
17 views

Temporary migration to a new server for firmware upgrade

I need to temporarily migrate an SSRS deployment to a new server so that I can perform a firmware upgrade on the server. Once the firmware upgrade has been completed, I will move SSRS back to its ...
0
votes
0answers
28 views

Data Base Migration - Adaptative Server Anywhere to Maria DB

I need to migrate a data base which is in my local computer to a on-line server. The RDBMS used in my local computer is Adaptative Server Anywhere 9.0.2.2451 while the RDBMS used on the server is ...
0
votes
2answers
123 views

Does MySQL Workbench lock database during migration process?

I am doing a migration of my database from one server (RDS) to another (localhost) via the MySQL workbench tool. I want to know if during this process my database will be locked for write and read ...
1
vote
1answer
58 views

Final steps of data center migration

Just to preface this, I am just a developer with some DBA experience but not an expert. We are migrating from one data-center to another. Basically we are doing this: Create a full copy of ...
0
votes
1answer
104 views

Migrate database from SQL Server 2008 Enterprise to SQL Server 2014 Standard

I need move database with "data compression" from SQL Server 2008 Enterprise to SQL Server 2014 Standard. But Standard edition does not support "data compression". How can I disable "data ...
0
votes
0answers
21 views

Migrating a DB of mysql 5.0 to 5.5

Sorry this is a newbie question. I have a DB of mysql 5.0 on a shared host and I would like to migrate this DB to another mysql server (5.5) on another shared host. What I did is like this. ...
0
votes
0answers
35 views

How to Normalize dump table, Perform-query, Perform-database Mysql

I need to migrate information hosting provider to our own systems, in this context I pose the following: The vendor provided us with history of transactions totaling approximately 7.5 million ...
4
votes
4answers
317 views

Migrating Large Database from SQL Server 2008 to 2014

I currently have on a large database (~500GB) on SQL Server 2008 that is going to be relocated to a new SQL Server 2014 server. My aim is to keep migration time down to a minimum. Migrating the ...
10
votes
5answers
2k views

Archiving of old data

We're currently running into some performance problems since our database is getting too big. There are data stored from the last 10 years and I don't see a reason why the data older than 2 years have ...
0
votes
1answer
58 views

Microsoft SQL migration full/diff backup/restore

I would like to move a database from one physical location to another. I already have a copy of the full database backup at the new location which is done by a nightly SQL job and is about 20GB. If I ...
4
votes
2answers
295 views

Loop through tables or copy paste

I have to do a migration where I should retrieve data from 40 Access tables, which should contain several of the same columns (but not all, the schemas are different). To make it simpler, I used SSMA ...
1
vote
1answer
48 views

Migrating system and user databases to a new server by moving the lun

I have to lease replace a server and the system and user databases all reside on the e which is a SAN LUN. The method they want to employ is to remove the lun from the current server and present it to ...
0
votes
0answers
205 views

Troubles on export data with PL/SQL developer

I'm trying to export data from a specific table using PL/SQL developer and Oracle 11g. Here's how I did : select * from mytable right click on mytable then "Export data" chose my table on a grid ...
2
votes
2answers
71 views

Moving database from one server to another

I have a virtual machine running SQL Server 2012 in Azure and have also generated a script of my database to be run on the SQLSERVER2012 VM on Azure, however I am getting an error "C:\Program ...
1
vote
1answer
44 views

Missing Oracle Schema in SSMA Object Explorer

We are currently working on a project to move all of our disparate DBs (MySQL, Oracle, older versions of MS SQL) to SQL Server 2014. So far, pretty much everything has gone smoothly, however, there is ...
1
vote
1answer
176 views

Migrating from Oracle to MySQL via MySQL workbench: Table list is empty

MySQL workbench offers a migration tool that I'm using to migrate an Oracle database to MySQL. I'm using the migration wizard to migrate the complete Oracle schema to MySQL. I used that for the ...
1
vote
1answer
61 views

Database migration - Simply change connection string?

We are migrating our database (MySQL/MariaDB) onto a dedicated server. Previously, our web server hosted the database. I've already set up master-slave replication between the web server and the new ...
1
vote
1answer
38 views

How to get SQL Server Compact 4.0 Database content query?

I need to migrate data to a SQL Server 2014 database from an existing SQL Server CE 4.0 database. I'm having difficulty because my computer runs SQL Server 2012 so I'm not able to port the data via a ...
3
votes
2answers
2k views

How to create and populate a PostgreSQL table from CSV automatically?

I am new to database management and we are using PostgreSQL. All I need to do is to migrate CSV files (corresponding to around 200 tables) to our database. Manually creating tables for every CSVfile ...
1
vote
1answer
69 views

Migrating from PostgreSQL to SQL Server

I have been tasked to migrate a database from PostgreSQL 9 to SQL Server 2008 R2, and I have found some issues I need to address. I have quite limited experiences with PostgreSQL I'm afraid. Most ...
1
vote
2answers
86 views

Partition of a table - how to minimize the time offline? How to check if all the statistics were updated?

As you ca see on the picture, I have a table called "tblsapdispatch" that has 55,707,259 records. Last sunday 30-aug-2015 they run a big update on this table, and I can see that the statistics were ...
1
vote
0answers
71 views

Migrating SQL 2012 Analysis Services to another server

We have a SQL Server 2012 installation that was built on...let's say a compromised Windows installation. It's had so many installs/uninstalls done on it that nothing runs consistently, and we're ...
0
votes
1answer
24 views

Mongo DB Site to Site Migration

I am somewhat new to MongoDB but I do have some experience with MySQL and PostgreSQL. Currently, I need to migrate Mongo DB from one site to another. The sites should be identical (development and ...
4
votes
1answer
3k views

SQL Server data folder access rights

I did a fresh SQL Server 2014 install. Next, I wanted to attach some databases from a previous SQL Server 2012 server. I copied all mdf and ldf files to the data directory, but when I tried to attach ...
2
votes
1answer
153 views

Converting old SQL Server outer join syntax

I'm a Power Builder (PB) developer. I've migrated PB from 10 .5 to 12.5, and now I need to migrate the stored procedures from SQL Server 2005 to 2012 as well. I get a invalid expression error when I ...
0
votes
2answers
122 views

Handling lossy data before character- set migration

I am trying to migrate a database from US7ASCII to AL32UTF8 using CSSCAN. During the initial scanning using CSSCAN we have found the presence of lossy data both in data dictionary() and application ...
0
votes
1answer
76 views

SQL Azure Migration Wizard - Duplicate Primary Key

Just did a test at migrating a 120gb database onto RDS using SQL Azure Migration Wizard Because we can't afford any downtime for "just" a test we ran the tool on the live database (meaning data was ...