Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
I am trying to Build a Incremental Backup Script using Percona Innobackupex , what my problem is i need a shell script to segregate the both First LSN and Last...
Asked on 12/24/2020 by JABIR BAIG
0 answerOn Wikipedia, it says: The decomposition is a lossless-join decomposition of R if at least one of the following functional dependencies are inF+ (whereF+ stands for the closure...
Asked on 12/23/2020 by Kevin Wu
1 answerI've created a materialized view between a primary system (Oracle 18c) and an external system (Oracle 19c):create materialized view primary_system.workorder_mvbuild immediate refresh force on demand start with sysdate next...
Asked on 12/23/2020 by User1973
1 answerI would like to upgrade Mongodb version 1.8.2 with replica set available ( 1 primary, 2 secondary) with same version to version 4.4 with no downtime. What are the steps...
Asked on 12/23/2020 by amanullah
0 answerI'm planning to purchase NAS (synology) for personal use. I'm working also as developer, it is possible to put my test database (SQL server data and log) to NAS? This...
Asked on 12/22/2020
1 answerI created a single table SQLite db from a csv file using python. I was able to open, browse and query the database using DB Browser for SQLite (browser) immediately...
Asked on 12/22/2020 by jkozma
1 answerI am working out of phpmyadmin to export data using an sql. I have an 88 table database. I would like to export all data to a .csv from 85...
Asked on 12/21/2020 by soberuprising
2 answerInstance info: Microsoft SQL Server 2017 (RTM-CU13) Standard Edition (64-bit) on Windows Server 2019 DatacenterLocation: AWSA Java app on another AWS server logs into the SQL instance using a local...
Asked on 12/20/2020 by Alonzo Hess
2 answerI have a postgres database which is set up like this: CREATE TABLE arr_test ( id serial primary key, data jsonb);INSERT INTO arr_test (data) VALUES ...
Asked on 12/20/2020 by KarlSC
1 answerWhat is the correct way to design my application, for a Hotel reservation system. So far i've got 3 tables Customerid pkReservationid pk customer_id fkcheck_id_datecheck_out_dateRoomid pkAnd the premise is: a...
Asked on 12/20/2020 by Rakoun
1 answerGet help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP