Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [schema-migration]

21 questions
12
votes
0 answers

Best practices for keeping protobuf spec in sync with relational database (e.g. PostgreSQL)

1. We have a schema definition in Google's Protocol Buffers format that we use to generate code for different gRPC implementations (Python, PHP) 2. We have a database (PostreSQL) that is initialized from SQL files which map the Protocol Buffers…
Alex
  • 303
  • 1
  • 3
  • 9
2
votes
0 answers

Received an unsupported type from Postgres. (14) (SQLGetData)

I have database in PostgreSQL. It is simplest possible database with schema presented here: http://www.postgresqltutorial.com/postgresql-create-table/ I want to migrate it to MySQL. I trying to follow after…
Daniel
  • 187
  • 1
  • 2
  • 9
1
vote
1 answer

Adding data to a DB as migrations

Some Background We currently have a PostgreSQL DB that is "read-only", i.e. no user is allowed to write to it and all insertions are done in a controlled manner. For a while, these were done by manually adding this data or creating a copy of the DB…
fditz
  • 111
  • 2
1
vote
3 answers

Is it good practice to refer to a table with different names in a database schema?

We have a database currently running with a table named a certain way (let's say thing for the sake of example), and references to that table named the same way (FK would be named thing_id for instance). We also used to have this thing concept in…
Aweb
  • 11
  • 2
1
vote
1 answer

Error: Not run migration 1604169742656_add-users-table is preceding already run migration 1604024614269_table-comments

I was trying to run a migration file to create a table of users but I kept getting the following error: Error: Not run migration 1604169742656_add-users-table is preceding already run migration 1604024614269_table-comments I worked around it by…
Daniel
  • 261
  • 1
  • 3
  • 11
0
votes
0 answers

Best approach to extract 1000 Gbs of Data from Teradata

What should be the best approach to download data from Teradata using python ? I have more than 3000 GBs of data to be migrated from teradata to another code service. Any approach or advise would be great. So far I have explored - Using Pandas it…
starlord
  • 1
0
votes
0 answers

Horizontal scaling with database schema

I am designing a database schema for our customers on-premise, which will be moved to Azure PaaS later. Regarding the "scale out" strategies I lean towards to create "one database", and create schema for each and every customer to store the database…
Avi
  • 266
  • 2
  • 12
0
votes
2 answers

Error when migrating MySQL 8 to SQL Server 2019

I get an error while migrating a database from MySQL 8.0 to SQL Server 2019 using the SQL Server Migration Assistant. The error message: ExecuteReader requires an open and available Connection. The connection's current state is closed. The same…
Carlos Vaz
  • 11
  • 2
0
votes
1 answer

Achieving best practice schema and permissions management on PostgreSQL

I have a PostgreSQL database (12, moving to 13 imminently) with a single (Rails) application running on it, and no other users or systems connecting. The application uses the postgres user to connect to the database for all purposes - regular…
David Aldridge
  • 2,074
  • 9
  • 13
0
votes
0 answers

how to sync one table of AWS RDS to another RDS

I have requirement like need to synchronize one table of data (contain user list) in AWS RDS instance to another RDS Instance. only particular user's table need to synchronize. ex: RDS-1 have schema like "user", "app".... i need to synchronize…
venkat
  • 1
0
votes
0 answers

Merge multiple InfluxDB 1.8 dbs into one + add tags with names of dbs

I have multiple InfluxDB 1.8 databases with same schema but different names of databases. I need to merge them all into one database + add a tag with name of original database the data came from so I can query all that data using those tags. Using…
GTXBxaKgCANmT9D9
  • 121
  • 1
  • 3
0
votes
1 answer

Table design comment_seen vs comment_unseen — migrate data from one to another

I have system that allows comments posted by users and tracks which users seen which comments. The read/unread state is tracked within comments_seen table. Surely enough, it grow tremendously. My goal is to move from comments_seen table to…
Eduard Sukharev
  • 115
  • 6
0
votes
0 answers

Best practice privileges and roles for postgres schema migration

I'm having a re-look at roles and privileges in postgres to minimise the damage that a compromised account can do. Ownership and migrations is a part I'm having trouble getting my head around. As I understand it, a table is initially owned by the…
ChrisJ
  • 429
  • 4
  • 17
0
votes
1 answer

Deploying Oracle ADW Changes from development environment to production

I'm currently running an Oracle Autonomous Data Warehouse (Oracle's cloud-based database offering) on version 19c. I have a development database on the Always Free Tier and my production database is a paid instance (with backups etc). I will likely…
Ash Oldershaw
  • 11
  • 4
0
votes
1 answer

MariaDB Replication - Replicate only specific tables and views

Note: A backend developer here with little to no experience in setting up database servers and replication. What needs to be done Setup DB replication of an existing database with the following constraints: Replicate only a specific list of…
qwertynik
  • 3
  • 2
1
2