The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
8 views

Migrating everything to do with a schema from one Oracle DB server to another [migrated]

We have an old DB server, running Oracle 11g on Solaris. We also have a new DB server, also running Oracle 11g, but on RHEL. We want to move a schema to the new db - but we need everything it refers ...
0
votes
0answers
5 views

migrate standalone postgresql database cluster to high availability cluster [migrated]

We have tested one setup of postgres HA with repmgr and pgpool. It is working fine and now we have to migrate our existing database to the HA setup. We have two approaches, Make the HA master as ...
0
votes
0answers
29 views

Migrating SQL Server 2000 from Physical to Virtual

My team will be tasked with a Physical-to-Virtual migration of SQL Server 2000. The main requirement will be: Minimization of downtime and minimization of impact on operation. The action plan is as ...
1
vote
1answer
116 views

What happens to active connections to my SQL Server DB if I back up the transaction log with the NORECOVERY option?

Some background: I'm migrating my SQL Server DBs to a new machine and I wrote a few Powershell scripts to send/apply full backups and transaction logs asynchronously to the new server, but my question ...
-4
votes
2answers
137 views

How, with a mounted disk image, can I migrate a MySQL database to a new server?

One Ubuntu EC2 VPS is fried after an upgrade that went awry. I don't have the server live, but I have its disk mounted on another (Ubuntu EC2) VPS. How can I migrate the contents of a database on ...
4
votes
1answer
127 views

Regarding High Availability for MSSQL Server

Already used in MySQL : Real Time Replication (synchronization) between primary and secondary server is done using master and slave commands. So What is the equivalent feature for MsSQL. Which ...
0
votes
1answer
41 views

migrate SharePoint to SBS Server

We have a SharePoint 2003 server and we need to migrate that data to SharePoint 2011 on a SBS server. We cannot use the migration tool because one of the servers is SBS and the other is not. We ...
1
vote
2answers
2k views

What's the best way to migrate a MySQL database?

We are moving a busy eCommerce site from one server to another. It's a PHP application that uses MySQL. phpMySQL is not installed on either server. We use Navicat Essentials for MySQL to manage ...
1
vote
2answers
99 views

Best way to migrate entire server?

I have a kimsufi box running Ubuntu 12.04, on this machine I have a number of websites supported by various installed packages such as apache and mysql. I have since purchased an improved server and ...
1
vote
1answer
24 views

Migrating from SQL 2008 to SQl express on the same VM

I have a windows 2008 r2 VM running SQL std 2008. I want to migrate my database from SQL server to SQL express which is a free product. Since I have one VM, I plan to install SQL express alongside SQL ...
0
votes
0answers
413 views

Migrate existing mysql server data to percona xtradb cluster

I currently have one server which is a mysql server. I want to get the data from it, into a new 3 node percona xtradb cluster i've set up. I am wondering if there's any alternatives to simply doing a ...
2
votes
3answers
1k views

MySQL per-database replication?

So, my problem is interesting: we want to migrate from one server to another. We made a master-slave replication, but my boss came with the idea to make migration one database at a time. So he asked ...
1
vote
3answers
240 views

How Do I Migrate 100 DBs From One MS-SQL 2008 Server To Another? (looking for automation)

Let me start by saying that I am not a DBA, but I am in a position where I am responsible for moving just under 100 MS-SQL 2008 DBs from our current development server, to a new/better/faster ...
3
votes
3answers
119 views

Mirroring MySQL server with different configuration

I have to migrate MySQL server to a different data center so I would like to create another MySQL slave server in new DC and then promote it to a master later on. I previously used LVM snapshots and ...
0
votes
1answer
59 views

Database server migration and SQL Server 2008 licensing [duplicate]

Possible Duplicate: Can you help me with my software licensing issue? We currently have a dedicated server that hosts a number of websites and also has SQL Server 2008 Enterprise running on ...
0
votes
1answer
83 views

Migrate SQL Server 2008 R2 Express to SQL Server 2008 R2 Web

I need to upgrade to a least expensive SQL Server variant which is SQL Server 2008 R2 Web. I'm currently using SQL Server 2008 R2 Express 64bit. Specs. say there's not direct upgrade path supported ...
2
votes
1answer
220 views

What is best practice for upgrades with AWS autoscaling and database migrations?

I would like to use a combination of an ELB and AutoScaling for a web application. For upgrades to the web application that don't involve changing the database, I can simply rotate all the instances ...
0
votes
1answer
414 views

Convert MYSQL DATABASE TO MSSQL DATABASE [closed]

I would like to ask if there is a software that convert all my database from mysql to mssql 2008
4
votes
4answers
3k views

How to create a SQL Server database from a mysqldump file automatically on a daily basis?

Recently, a vendor announced that they were upgrading their processes, and an automated, daily data dump we are getting from them will now come in a MySQL datadump format. Unfortunately, we're a ...
1
vote
1answer
138 views

SQL Server updated from 2000 to 2005. Now getting TimeoutException

I've recently updated an MSSQL server from 2000 version to 2005, to make use of UDFs and tweak some results in a system. The thing is that we don't have the source code. So, I replaced the SQL ...
8
votes
4answers
2k views

Has anyone migrated production machines from MySQL to MariaDB?

I'm running MySQL for most of our DBs right now, and would like to get off the Oracle ship before it takes more of a turn. My understanding is that the transition from MySQL->MariaDB should be ...
0
votes
1answer
159 views

Migrating databases from SQL 2000 to 2008 R2

Hands-ups, I have no idea what I'm doing! We have an old SQL 2000 Server with 2 databases. I have a new server running SQL Server 2008 R2. Can someone outline the basic steps of migrating the ...
0
votes
1answer
1k views

Mysql: Innodb error when migrating mysql from linux to windows

I have migrated my data directory for an InnoDB mysql server from a linux machine to a windows machine. I started the server up, selected the database, and tried to query a table. Got the error "Table ...
1
vote
2answers
445 views

SQL Server Express - Move by Copying Data Folder?

We are moving our SQL Server to new hardware. Initially we were going to do this simply via backup and restore, but noticed we'd have to recreate all the logins. We don't want to do that :) ...
2
votes
4answers
2k views

MySQL: how to convert many MyISAM tables to InnoDB in a production database?

We have a production database that is made up entirely of MyISAM tables. We are considering converting them to InnoDB to gain better concurrency & reliability. Can I just alter the myISAM ...
0
votes
4answers
896 views

Oracle 10g to SQL server 2008/ migration

We have a reasonably heavy Oracle 10G database (~ 120 GB space occupied). The database consists of tables, packages, materialized views, procedures etc. We are planning to decommission Oracle and ...
2
votes
4answers
908 views

How to change storage location of a database?

my hard-drive is currently almost full!! I need to migrate the db to a different drive, how can I do this? They are all stored in the default C:\ drive. Any ideas?
1
vote
1answer
809 views

Migrate database from SQL Server Standard to SQL Server Express for DotNetNuke

we have an old server that we want to dedicate fully as a public webserver (hosting a few DotNetNuke sites), and for this purpose we would like to install SQL Server Express (probably 2008) on the ...
2
votes
1answer
687 views

How to move MySQL partitions from one machine to another?

I have a MySQL table: CREATE TABLE tweets ( tweet_id INT NOT NULL AUTO_INCREMENT, author_id INT NOT NULL, text CHAR(140) NOT NULL, PRIMARY KEY (tweet_id) ) ENGINE=InnoDB PARTITION BY HASH(tweet_id) ...
0
votes
2answers
211 views

Migration from Oracle 10gR2 to Oracle XE

One of my application currently uses Oracle 10gR2 as the backend, with PL/SQL Stored Procedures, Triggers, Sequences, etc. I want to migrate to Oracle XE. Can this edition serve as the primary ...
3
votes
1answer
448 views

Best way to migrate from MySQL to PostgreSQL

I have to migrate a MySQL database to PostgreSQL. I have tried the mysqldump with --compatible = postresql. I have seen that some poeple use ETL like Talend to make the migration but you must describe ...
1
vote
1answer
608 views

Migrating master-slave MySQL database servers to 2 new servers, any tips or suggestions?

I'm setting up 2 new database servers that will be replacing a current master-slave setup. All boxes are running / will be running MySQL on RHEL. Our current naming conventions: db1 - master ...
1
vote
1answer
206 views

Migrate Django app from ubuntu to red hat

Is there a best practice of migrating django app from ubuntu server to red hat? What could be the challenges? In the same vein will postgreSQL migration pose any challenges?
2
votes
1answer
539 views

How to migrate from DB2 to PostgreSQL database?

I have an existing Windows DB2 database that I'd like to move onto PostgreSQL. The users for the application can live with a weekend's worth of downtime. What's the best way to do that?
3
votes
5answers
5k views

How to move a Windows XP MySQL database to Linux?

What is the recommended way of moving an MySQL database from Windows (XP) to Linux (Ubuntu 9.10)? I am thinking running mysqldump from XP then import on the Linux box - is there a better way? Has ...