17 questions
0
votes
1
answer
895
views
For Snowflake prod->dev scheduled cloning, what is a good way to handle custom rules? [closed]
We are trying to setup dev and qa environments using data from a prod environment.
We are not using CREATE DATABASE dev CLONE prod because we are trying to avoid cloning database-specific objects like ...
- 599
4
votes
1
answer
3k
views
How to clone a Snowflake database and own all of its child objects?
I love Snowflake's zero-copy cloning feature, but it has a property that seems to seriously reduce its convenience:
The clone creator gets ownership only of the top-level cloned object. The child ...
- 51
1
vote
0
answers
190
views
Replicating Dev database to QA database using SNOWFLAKE
I have a Dev database and I want to create a new schema called QA database which should be a replica (in all aspects including stages) of Dev database.
Could someone please let me know how this can ...
- 521
0
votes
1
answer
47
views
LARAVEL row cloning getting select SQL error
Hi I've been stuck here for days now,
I am trying clone a row from my DB using the replicate method. But I am getting the error
Here is my code:
foreach($e_inserts as $e_data){
$enrollment = \App\...
- 49
1
vote
1
answer
1k
views
Date and Time of Database refresh from PeopleSoft Production database
In a PeopleSoft application running on an Oracle database, how can I find out when a non-Production database got copied/refreshed from Production?
Is there a PeopleSoft/Oracle table (or tables) that ...
- 11
2
votes
1
answer
3k
views
Cloning one of the Database in AWS RDS in order to get a test DB
I am quiet new to AWS and trying to learn things. I currently have a live production environment and trying to create a test environment. I was able to create an image of an ec2 instance in AWS using ...
1
vote
1
answer
998
views
Oracle database connection problem after cloning the server
I just clone a server that hosts Oracle in order to make a linux test machine. But the sqlplus user/password@alias connection does not work on the cloned server.
I do not find what to change.
Thank ...
- 91
0
votes
0
answers
234
views
Docker cloning mysql image for backup
I am using a docker container that provides me a mysql database. I would like to make it as git branches. I wish to clone to container start it, make some db changes, then start another container in ...
- 87
6
votes
1
answer
12k
views
pg_dump and pg_restore on giant databases
I have currently a task to improve a database-structure.
For this we want to effectively dump and restore one single giant database. (approx. 1TB and growing)
To test things with this database, we ...
- 95
1
vote
2
answers
465
views
Can I run a pg_dump automatically removing reference to the owner?
I want to be able to clone the contents of our postgre production database to an ownerless local database efficiently. I've successfully done this, but it was a laborious process with the following ...
- 889
-1
votes
1
answer
30
views
Can I raise a database in the cloud ?
I programming software for rental cars, I have a database, can I raise the database on the cloud?
After putting them in the cloud Can I modify them?
- 23
0
votes
1
answer
649
views
Copy database from one server to another server + trigger python script on a database event
I've a read-only access to a database server dbserver1. I need to store the result set generated from my query running on dbserver1 into another server of mine dbserver2. How should I go about doing ...
- 7,327
1
vote
1
answer
795
views
Copying (Cloning) DB to another Vertica Cluster with Different no. of Nodes and Different IP Addresses
I have this requirement where I have to copy the complete DB from a single node installation to a 2 nodes cluster of Vertica. As per the documentation this is not possible.
Are there no workaround ...
- 355
-1
votes
3
answers
1k
views
Is possible to clone SQL database from ASP.Net application efficiently?
There are a lot of database cloning tools out there such as SQL Data Compare.
However, end users (using ASP.Net Application) want to clone the staging SQL Server 2008 database to production SQL Azure ...
- 62.2k
0
votes
3
answers
3k
views
How to copy everything except data from one database to another?
In T-SQL (Microsoft SQL 2008), how can I make a new database which will have the same schemas, tables, table columns, indexes, constraints, and foreign keys, but will not contain any data from the ...
- 52.2k
0
votes
1
answer
3k
views
what is database cloning?
had been looking towards this "Database Cloning" quite many times.. is it anything different from simply creating a copy of the database... please tell me keeping MySQL in mind...
- 6,949
1
vote
6
answers
1k
views
How to have a "master-structure" database with "children-data" databases in SQL SERVER 2005?
I have been googling a lot and I couldn't find if this even exists or I'm asking for some magic =P
Ok, so here's the deal.
I need to have a way to create a "master-structured" database which will ...
- 11.7k