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

learn more… | top users | synonyms (2)

1
vote
2answers
26 views

Dynamic script to Drop Indices of a specific column

I´m currently writing an SQL script to update our database and for that I need a script to drop indices that rely on a specific column (because I also want to drop the column). In my script I have ...
1
vote
0answers
21 views

Move SQL Server cluster from one location to other

I am looking for ideas on how to move SQL Server 2012(standard) two node cluster installed on Windows server 2012 standard to other location which is far away from current location. The two locations ...
1
vote
0answers
18 views

UTF8 Trouble while migrating from MSSQL to MySQL with MySQL Workbench

I am tasked with migrating part of our database from an on-site MSSQL server to an Amazon RDS MySQL. This will be my first attempt with a database migration, so I am doing a dry run from our MSSQL ...
0
votes
1answer
13 views

What is the Difference between Data Transformation vs Transportation?

Is there a difference in meaning between "data transformation" and "data transportation" in ETL process and data warehousing? or both concepts can be used interchangeably in this context? Thanks
0
votes
1answer
131 views

mysql database migration of schemas with updated data and structures

I am a newbie with MySQL database dumps and am currently trying to work with data migration between a source schema and a target schema. Assuming the source schema is defined by ...
0
votes
2answers
121 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
votes
0answers
9 views

Export from Oracle To SQL Server [closed]

How can Export All Schema (Structure and Data) from an Oracle database to a SQL Server database without programs?
2
votes
2answers
50 views

Migrate SQL Server backup to MySQL for a Wordpress site

I have a client with an old .Net site that used SQL Server. For lots of reasons they decided to switch to Wordpress. They had a bunch of news articles on that old site that they want turned into posts ...
2
votes
0answers
242 views

Migrate Management Data Warehouse to a New Instance

Is there a defined procedure to follow for moving a SQL Server 2012 Management Data Warehouse to a new server\instance? We intend to setup MDW on a test SQL Server instance first, but will then want ...
0
votes
1answer
700 views

MySQL data transfer to different schema

We have two servers: one for the developer (me) and one for the tester. While working on the app, I sometimes make little changes in tables's schemas. (Like a new field, or a field type) I'm trying ...
0
votes
0answers
29 views

Mysql checksum for data only

I have some groups of two tables, each group table having the same structure. (dev & prod server) Their data will never change from user action, only from admin when a change occurs. I want to ...
0
votes
1answer
114 views

Some tables not found after moving MySQL database from Linux to Windows

I had a MySQL database which I was working with from Linux. Some of the schema/table names were in mixed case. I then needed to work with the same database on Windows, but because of the enormous ...
0
votes
1answer
41 views

SQL Server accepting Access queries?

I am currently working on migrating a legacy codebase from VB6 and Access to VB.NET and SQL Server. I have run the Microsoft SQL Server Migration Assistant successfully and populated a SQL server ...
1
vote
1answer
40 views

Data transferring

Is there any practices to transfer data from two databases that have different structure of table ? For example : old system : table [folder] with col: FolderId, name, age, sexe, date, orders New ...
0
votes
0answers
34 views

Oracle database in maintenance mode without patch

I could not enable maintenance mode in oracle database without patch Also I don't have patch(Since I don't have Support Identifier). @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE SP2-0310: unable to ...
0
votes
2answers
53 views

Migrate SQL server data to new schema

I have a database that was originally created by a couple of people for a small business unit (about 8 staff and 10 customers) in MS Access. The original 'developer' was a non-geek who had been sent ...
2
votes
0answers
25 views

What software or cloud service do you recommend PostgreSQL to get (more) interoperable with? [closed]

We're trying to expand PostgreSQL ecosystem by developing features for interoperability in the PostgreSQL community, as well as asking software vendors and other OSS projects to support PostgreSQL. ...
0
votes
0answers
6 views

Is REDCap a Data Warehouse Environment?

I working with a web application used to capture research data called The Research Electronic Data Capture (REDCap) system. I am assign to a project to manage the clinical data that are captured in ...
1
vote
2answers
46 views

SQL Server engine in one place with database files on NAS

My office uses accountant programs which run on SQL Server 2008 R2. The SQL Server engine must be installed on one of the laptops (called "server") and the other laptops (called "clients") connect to ...
14
votes
2answers
3k views

How to move a database from SQL Server 2012 to SQL Server 2005

What are my options if I need to move a database from SQL Server 2012(32bit) to SQL Server 2005(64bit)? I know I cannot: restore a backup of the database on SQL Server 2005 detach & attach I ...
4
votes
2answers
63 views

Quickest way to migrate mirroring to AG

Scenario is this, prod is two two node FCI with mirroring (primary/disaster DC). This is working just fine. New hardware is coming and a version upgrade to SQL Server 2012 (from 2008 R2) in the form ...
0
votes
1answer
26 views

Galera Cluster not syncing from a standalone Mysql Server

I had setup a 3 node Galera cluster in production network. And I am replicating the data from a Standalone MySQL Server to one of the galera node(node1) through master slave replication. I can ...
0
votes
0answers
22 views

Migrate 2008 R2 SSRS DB to 2014?

I am working on upgrading/migrating our SSRS from 2008 R2 on Windows 2008 R2 to SQL 2014 on Windows 2012 R2. I was originally going the route of just recreating side by side. I already have the new ...
0
votes
0answers
16 views

Sending Data Across Databases in Realtime [duplicate]

I have a device that sends data to a database say, DB1. Now, for every insertion or update done in DB1, I want it done on DB2 in real time. Please somebody help me out on what to do here. Thank you in ...
0
votes
0answers
28 views

SQL Server: migrating masters databases between clusters by detaching/attaching them

As a migration strategy is it possible or feasible to detach a master database in a Microsoft SQL Server cluster and then attaching a different master database's files from another cluster? The goal ...
2
votes
1answer
1k views

Fastest way to migrate database to AlwaysOn cluster

I want to make the fastest migration plan to move a SQL Server database in simple recovery from a standalone server (SQL 2005) to a two node AlwaysOn cluster in full recovery. Some databases are ...
86
votes
13answers
155k views

How can I move a database from one server to another?

How can I move MySQL tables from one physical server to another? Such as this exact scenario: I have a MySQL server that uses innodb table and is about 20GB size. I want to move it to a new server, ...
2
votes
2answers
58 views

SQL Server - SQL Plan Management for baseline

I am a .Net developer. I have a database upgrade coming up (from SQL Server 2005 to SQL Server 2012). The database team will be handling the migration. But I have seen forums posts saying that after ...
1
vote
1answer
86 views

Convert Postgres TIMESTAMP to TIMESTAMPTZ

I have a decently-sized (~50k rows) time-series database running on Postgres, with some other structured data (in another database instance) which is much smaller. Stupidly, when I initially designed ...
1
vote
0answers
18 views

MySQL quick database transfer between two servers

I am migrating a reasonably large (18GB) database used for a website from one server to another. There are two tables which make up 95% of that size and they do not have to be fully transferred for ...
1
vote
1answer
11k views

How to export an image column to files in SQL Server?

I will migrate from a database. There is one column of type image that I would like to export to binary files on the file system. One file for each record. How can I do this with SQL Server?
0
votes
1answer
39 views

BIG Binary column - PostgreSQL 9.2

I've got the following table: CREATE TABLE gorfs.inode_segments ( st_ino "gorfs"."ino_t" NOT NULL, -- Inode number the segment belongs to. alongside segment_index, it forms the table's primary key ...
0
votes
1answer
286 views

Why are some of my migrated tables showing “The given key was not present in the dictionary” in WebMatrix's interface?

I'm having an issue while using the SQL Server Migration tool to convert Access accdbs into SQL Server 2014 Express. I am converting the tables using SQL Server Migration Tool and I have a connection ...
0
votes
0answers
25 views

How to migrate AWS dynamodb to mongodb

I am new to NoSQL databases. I am having a database in AWS RDS DynamoDB. I need to migrate this to MongoDB. Can any one help me with the steps to convert database from DynamoDB to MongoDB.
1
vote
1answer
94 views

Migration from Cassandra 2.x to 3.x: schema_keyspaces table is gone. How do you query system keyspaces?

I just migrated from Cassandra 2.x to 3.x (specifically, 3.4). Now the system tables have completely changed, and these changes are not in the documentation. If you look at the current CQL docs for ...
1
vote
0answers
55 views

How can I migrate a WordPress site from MySQL to SQL Server Express?

I have developed a web portal in WordPress using xampp server. I have my database in MySQL. Now I need to deploy this WordPress portal on other system with SQL Server Express Edition. So how can I ...
3
votes
1answer
67 views

Converting standard_conforming_strings from off to on when importing Postgres dump

I've got a Postgres 8.1 instance which has standard_conforming_strings set to off (== handles slashes as escape characters). Recent Postgres versions have this setting on by default (for good ...
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 ...
6
votes
1answer
216 views

SQL Server 2008R2 Alias not working

I have an interesting situation here. We're basically trying to migrate some SQL Server infrastructure to new hardware, and one of the boxes (single-instance, 2-node cluster) is running 2008R2. The ...
0
votes
1answer
18 views

Issues regarding phpMyAdmin - character set

I'm trying to migrate a Wordpress site from one server to another. Everything is going fine apart from the database migration. I have my database 'A', and using phpMyAdmin I am attempting to export ...
1
vote
1answer
101 views

Postgres: how to restore backup with WAL-E?

I am trying to setup Postgres and WAL-E. So far I have managed to install WAL-E and it appears to be working. I can make backups, WAL logs seem to be sent to S3, great. Here is what S3 looks like: ...
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 ...
2
votes
1answer
51 views

Minimise time for migration

I want to migrate production DBs from one server to a different one. This is my plan: Shut down the application Change the DB to single user mode Take a full backup for all databases Restore the ...
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
1answer
38 views

Dump specific tables from DB2 database

Is there any command line tool that I can use on a DB2 database to dump a specific set of tables? The problem is that I work in an application that its database tables was created in an existing ...
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 ...
0
votes
2answers
23 views

Source of network_name for distributor

So, I have a really weird case. Was doing a migration from sql server 2005 to 2012. Built the server, and at the last minute we found that the server was called abc/xyz. We just wanted abc, so the DBA ...
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 ...
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 ...
1
vote
0answers
38 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 ...