All Questions
27 questions
0
votes
1
answer
205
views
Is it possible to query Oracle system tables (DBA_USERS,dba_role_privs,dba_tab_privs) Using Db_link?
Is it possible to query Oracle system tables (DBA_USERS,dba_role_privs,dba_tab_privs) Using Db_link?
I am getting ORA-00942: table or view does not exist when tried to query the same.
- 13
0
votes
1
answer
195
views
SQL Server database not able to update after restoration
We are migrating an application's database between servers and we have used the Attach method to attach the database files to the new location.
After re-pointing the application to the new database ...
- 1
0
votes
1
answer
85
views
Upgrate postgresql database
I'm going to upgrade postgresql from the version 9 to 11, I exported all the cluster using the command pg_dumpall -h localhost -p 5450 > /tmp/all.sql I have installed postgresql 11 on my new ...
0
votes
1
answer
116
views
Mongodb migration and appending data to existing database
I have two databases in two different machines containing data in same schema. Both have relational mappings in form of ObjectIDs as it is done in NoSQL database. The task at hand is to pick one ...
- 111
0
votes
1
answer
790
views
Migrate data from an older version of mongodb
How can I backup and restore a large mongodb database (500GB) from a server running an older version (v2.6) than the target one (v3.6)?. The downtime is critical.
We've tried by making a straight copy ...
0
votes
1
answer
144
views
how to upgrade postgresql 9.0.4 to latest with minimum downtime
I have master-slave-slave setup for postgresql 9.0.4 in our production setup.
We need to upgrade it to latest (11.X), so my question is what would be the procedure to do so with as little downtime as ...
6
votes
4
answers
4k
views
SQL Managed Instance - Cross Subscription Restores/Migration
Short Version:
I am trying to restore a backup from one SQL Managed Instance to another SQL Managed Instance. These are in different subscriptions. Using Example 3 from here I can at least get it ...
- 9,244
1
vote
1
answer
71
views
Legacy data migration to Always on Availability group database
In our application there is a data conversion process that brings all the legacy data to the production database.
Since our database is on availability group and the migration might bring 100GB + ...
- 1,063
1
vote
1
answer
3k
views
Migrate complete postgres database cluster to another machine using pg_dump
I am referring to
How to get a working and complete PostgreSQL DB backup and test
In this example/solution, which part of the restore process does actually the "CREATE DATABASE sandbox"? I have been ...
- 13
0
votes
2
answers
2k
views
Cloning the database to another server with raw data files
I'm trying to clone the database of server 1 to server 2 with raw data files. I'm using Linux 7 and Oracle 11g R2. I have the instance running with same SID in Server 2 but file structure is different....
- 1
3
votes
3
answers
338
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 ...
- 309
3
votes
1
answer
306
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.
...
3
votes
1
answer
1k
views
Loading SQL Server from SQLite with image data
I am trying to load a SQL Server database table from a SQLite database. I have been unable to transfer the data between the two databases since there are:
Difficulties in accessing the data in the ...
- 131
8
votes
2
answers
36k
views
Restore a SQL Server 2012 backup file in SQL Server 2016/2014
I have SQL Server 2012 backup files and want to restore these to SQL Server 2016/2014. Will it work?
I need to find this out before I uninstall SQL Server 2012.
- 201
0
votes
1
answer
104
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.
2
votes
1
answer
728
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 ...
- 133
0
votes
1
answer
46
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 ...
- 101
11
votes
6
answers
29k
views
Migrate from SQL Server 2000 to 2012 without a 2005 or 2008 instance
I have come across three old databases sitting on SQL Server 2000 which I need to move to 2012. I believe the standard approach is to restore into a 2005 or 2008 instance, update, re-export and ...
- 221
0
votes
1
answer
278
views
Restoring SQL Server 2000 database to SQL Server 2008
Is it necessary to restore system databases of SQL Server 2000 to SQL Server 2008, if I am restoring my other databases from 2000 to 2008?
- 69
26
votes
2
answers
21k
views
Best way to migrate a huge SQL Server database with low downtime over network
Problem definition
Our database server needs to be transferred to an other datacenter. It runs on Microsoft SQL Server 2012 Enterprise (64-bit) and contains two databases of about 2TB and 1TB.
...
- 363
1
vote
1
answer
945
views
Postgres database dump and restore on different database [closed]
I have two Postgres databases on the same server, which have the same schemas.
The goal is to have DB1 as the production and DB2, as the database that will receive all the data that is migrated from a ...
- 121
1
vote
2
answers
1k
views
Error While restoring DB2 db from AIX to AIX server?
I am required to migrate 1 database One AIX server to another AIX server.
To achieve, I took backup from 1 machine and followed below steps
1st Command I tried is as following.
db2 restore db ...
- 111
4
votes
2
answers
977
views
Can I open a SQL Server 2008 R2 database in SQL Server 2008 R2 Express?
This question has probably been asked a dozen times but I couldn't find them here or at SO.
Can I attach/restore a SQL Server 2008 R2 database to my local SQL 2008 R2 Express instance?
- 181
3
votes
1
answer
3k
views
How do I have RMAN treat my restored data files like they are originals?
I am planning a migration for this ancient-but-critical Oracle database from one Windows Server 2003 cluster to another.
The database has many data files and they are all getting new paths on the ...
- 14.8k
2
votes
2
answers
1k
views
Attach database from SQL Express 2008 Edition to SQL Server 2008 Enterprise Edition
My friend is stuck on moving a database stored in SQL Express 2008 Edition in a server (called server A) to SQL Server 2008 Enterprise Edition in another one (called server B). There are two SQL 2008 ...
- 131
5
votes
2
answers
13k
views
Move an Oracle database by moving the raw data files
I have a large Oracle database (~300 GB) and I need to move a copy of the database to a new environment in a short period of time. I was wondering if there is a way to just pick up the raw files ...
- 151
11
votes
2
answers
1k
views
A Non-DBA Asks: How to Painlessly Copy/Move a SQL Server instance to another Server via Backup/Restore?
We've just got a new server so I need to copy the existing SQL Server 2008 instance over from the old db box.
I normally do this by copying .mdf and log files over and attaching them but I'm not able ...
- 809