I am developing a stock/e-commerce web application. We have been using a version of our software for a while now, and we are ready to introduce some new entities in our database and change the schema a bit. The problem is that I do not want to lose any data, yet if I do a simple backup, then set up the new version of our software, the schema will change significantly. Adding columns for joins, etc. I've never really done this, but is there any way I can backup all data then restore it to a slightly different schema making some adjustments? like renaming a column etc.
Database backup and restoration
155 Views Asked by arg20 At
1
There are 1 best solutions below
Related Questions in DATABASE
- How to add the dynamic new rows from my registration form in my database?
- How to store a date/time in sqlite (or something similar to a date)
- Problem with add new attribute in table with BOTO3 on python
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- SQLAlchemy: efficient relationship loading in 3-way many-to-many relationship
- Cannot connect to Postgres Database when running Quarkus Tests with Gitlab ci
- Local or remote database with react-native?
- I want to edit a specific row in database
- How to enter data in mongodb array at specific position such that if there is only 2 data in array and I want to insert at 5, then rest data is null
- Open Web Library
- database login.py and register.py error showing 404 file not found and doesn't work
- SQL71561: SqlComputedColumn: When column selected
- Liquibase as SaaS To Configure Multiple Database as Dynamic
- Updated max input vars but table still shows error
- Spring does not map set of roles
Related Questions in DATABASE-SCHEMA
- SQL schema for a fill-in-the-blank exercise
- Enforce schema on schemaless DynamoDB database
- Design SQL Schema for User Interests
- Issues Generating ODB Schema and Query Files for C++ Project
- Does setting a .unique(on:) constraint affect the uniqueness of the .id in fluent/vapor?
- My schema is not showing in the Schema List Window
- How to design my Django app database to accommodate multiple level information of an item?
- Copy and use Progress database file at runtime
- In schema compare, some files erroneously appear as missing in the local DB compared to Azure SQL Server DB. Only a few files are affected, not all
- is adding a table for video, image, and audio a good job for normalizing the database or not
- Database schema and query to accumualte total amount of days for each "category" of an animal over a period of time
- Mongoose: Nested Schema Array is throwing an error that _id = null and _id cannot be duplicated
- SQLite3: "CREATE VIEW" fails at "column-name"
- Separating schema and data migrations
- How to specify in Pymongo validator key type in object?
Related Questions in DATABASE-RESTORE
- Restore of backup db failed.(Microsoft.SqlServer. Management.RelationalEngingeTasks)
- Unable to restore sqlite from backup
- Preserve restrictive flag when restoring Db2 database
- Greenplum gprestore - cannot find file (gpfmt_gpss.so)
- Replicate RDS instance into a DEV instance
- Cannot start PostgreSQL database: Invalid primary and secondary checkpoints
- Why `\connect mydb` prevents error `function unaccent(text) does not exists`?
- Oracle DB - Database backup without any data
- TLS Connection Request Failure: Mismatched Server Certificate Name (server_name) During Database Restoration
- Restore the source database changes using RMAN Incremental backup in Oracle 19C where Target Database also changes
- How to use Azure Data Factory to restore an Azure SQL Database from Azure Blob Storage
- Restore Yardi backup (.bak) files to SQL Server
- Restore .bak trouble
- Firebird 2.1 invalid request BLR at offset 1839 on restore database?
- Restore Specific Postgres table from outside Docker container using .sql file
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
I could say it should be part of the development process to create 'migration' scripts from one release to another, test them and then apply a migration copy of the production database one change at the time (check for Continuous Database Integration or Evolutionary Database Design patterns). We use this approach every time we make an big schema change to something that has already been deploy to production and has worked for us like a charm. Just my $0.02.