Question : The following image describes the format of the GST Identification Number: The first 2 digits denote the unique […]
Tag: data-validation
Post migration MySQL database validation
Question : We are migrating from 5.5 enterprise mysql to 8.0 mysql enterprise edition. And we are migrating version by […]
How do I store phone numbers in PostgreSQL?
Question : Let’s assume I want to store phone numbers in a database. I may accept phone numbers from outside […]
How to validate data before loading it to DB
Question : I have a situation where in I have million records in CSV file, what I need to do […]
Loop through list of fields, check against lookup table
Question : I have a list of fields: FIELD_DOMAIN_ENG_VW +————-+————+————-+ | TABLE_NAME | FIELD_NAME | DOMAIN_NAME | +————-+————+————-+ | ENG.TABLE_1 […]
use cases for db.collection.validate() – checks the structures within a namespace for correctness by scanning the collection’s data and indexes
Question : I found on MongoDB mailing list one use case for db.collection.validate(): The count() command is generally an estimate […]
Validating SQL Server Change Tracking Synchronization
Question : I have some tables that I need to synchronize from one SQL Server database to another. I’m using […]
db.collection.validate() missing output and verify() returned EBUSY on first run
Question : logs of the successful run # grep conn103640 mongodb.log | head -10 2017-01-12T11:29:51.492+0000 I ACCESS [conn103640] Successfully authenticated […]
Validate three digits before decimal and after decimal point six digits
Question : I have columns called longitude and latitude with nvarchar data type. The user can enter something like (23.23424432),(432423.343), […]