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

learn more… | top users | synonyms (2)

0
votes
0answers
27 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 ...
0
votes
0answers
29 views

Move/ Migrate SQL Server 2012 Virtual machine (Win 2012) to new Physical host [on hold]

There are virtual sql servers on d/f physical hosts and I want to know what is the recommended way to move them to One physical host (Hyper-V) running multiple VM's in one data center and have same ...
2
votes
0answers
25 views

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

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
21 views

Another Database to hold 60GB [closed]

Im not sure if this is the right stackexchange to ask it but i have my download folder. With 58.6GB! I need to drop it off somewhere and delete it from my computer since it cant handle it... And i ...
0
votes
0answers
4 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
0answers
5 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
41 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 ...
0
votes
2answers
21 views

Sql Server Data Migration tools cross database [closed]

Is there any tools help migrate data cross database still sql server to sql server? this is my case [OLD].[dbo].[User] - Id(uniqueidentifier)[PK] - Username (nvarchar(50), null) - Password ...
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
62 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
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
1answer
22 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
15 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
31 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 ...
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
2answers
109 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 ...
0
votes
0answers
23 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
963 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 ...
84
votes
13answers
152k 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, ...
0
votes
1answer
674 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 ...
2
votes
2answers
57 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
54 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
14 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
10k 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
35 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
259 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
1answer
104 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
0answers
23 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
51 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
44 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
66 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
85 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
194 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
15 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
72 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
37 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
50 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
88 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
29 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
232 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
150 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
33 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 ...
0
votes
0answers
43 views

Oracle to SQL Data migration failed with No errors using SSMA tool

I'm trying to migrate tables from Oracle (Oracle 11g r2) to SQL Server (SQL server 2014) using SSMA tool, successfully able to create the schema but data migration is failing. I've installed SSMA + ...
0
votes
1answer
55 views

Does exist some software for transforming data from one DB schema to another?

I need to transform between two different database schemas the same data. For example i have one table in old schema like this: and i need to transform it to new schema like this: So i have few ...
0
votes
1answer
15 views

How do I create a new mongo collection with custom indices from an existing mongo db? [closed]

I have a mongo database collection, that I want to modify. I would like to add new indices (text and geo) to the existing data, and remove unnecessary fields. What would be the best way to do this? ...
0
votes
1answer
51 views

Is it possible to restore a database from 10.50.4033 in 10.00.1600

I did one project for my last year exam I want to restore a database. Is it possible to restore a database from v10.50.4033 to 10.00.1600. If yes, how is this possible.
0
votes
2answers
158 views

Strategies to import big data into Oracle

What strategies are available to import about 500 million small transactions every day from an external system? Oracle becomes very slow with very frequent commits. The transfer process which is ...
0
votes
1answer
22 views

How long will it take to migrate a 5 GB Database to Amazon RDS [closed]

I just need an estimation. How long will / can it take to move a 5 GB big database from an external source to amazon RDS. What is best practise to do it? I just moved succesfully a few days ago a ...