Questions tagged [data-validation]
The data-validation tag has no summary, but it has a tag wiki.
32 questions
1
vote
1
answer
88
views
UDF vs other solutions for checking valid data
I have many 'title' and 'name' columns in different tables that have the same set of restrictions about what characters can be inserted and what not. For example, names should only allow alphabet plus ...
- 121
0
votes
1
answer
62
views
I should let the user type the primary key?
I have a Products table, 2 options:
Let the user type the PK because some users can input Barcodes or no (in this case, the app will let to user free to input anything for example his own code ...
- 3
0
votes
0
answers
148
views
Data validation for RDS PostgreSQL migration
I'm planning to replace a bunch of RDS PostgreSQL databases using this method defined by AWS.
The DMS task will run will be CDC-only. I came up with data validation requirements for the migration and ...
- 159
0
votes
0
answers
430
views
Validate Excel File data source in SSIS package
I need to load a number of Excel files using SSIS package into a SQL Server table. I am able to successfully loop through and load my Excel files into my table I do not have any issue doing that, BUT ...
0
votes
0
answers
120
views
Oracle Database schema validation
I am working on a database migration and
want to validate the destination schema against the source schema for Tables, Views, Indexes, Sequences, Constraints etc. I can do that by querying the dba_ ...
0
votes
1
answer
203
views
Best practices for tracking ingested data sources
I am in the process of creating an ingestion pipeline wherein there exists a step of periodically reading new .csv files and storing them into a postgres database. This step is functioning, however it ...
- 101
2
votes
2
answers
733
views
Post migration MySQL database validation
We are migrating from 5.5 enterprise mysql to 8.0 mysql enterprise edition. And we are migrating version by version like from 5.5 to 5.6 then 5.6 to 5.7 and lastly from 5.7 to 8.0 also os migration ...
- 21
0
votes
0
answers
908
views
"Document Failed Validation" what is wrong with my schema validation
I am trying to create a collection with JsonSchema (really its "BsonSchema") validation. This is a document that I want to insert (with bogus values). Note that Id is coming from the mongo ...
- 101
1
vote
1
answer
452
views
Validating SQL Server Change Tracking Synchronization
I have some tables that I need to synchronize from one SQL Server database to another. I'm using SQL Server's "Change Tracking" feature. My program uses Change Tracking to synchronize the ...
0
votes
1
answer
17k
views
Validation logic for Mobile Number Column in SQL Server
I am creating a validation script and need help with mobile number validation logic with below details. Mobile number must be:
10 digits in length.
Cannot begin with a 1 or a 0 (For example:...
1
vote
1
answer
447
views
Always Encrypted Data Validation [closed]
Just a question in how could i validate duplicate data's in my database if columns is set to be encrypted(deterministic) in db?
I've tried running the following code, but receive the error below.
...
- 29
2
votes
1
answer
10k
views
SQL Server - MERGE duplicate SOURCE rows validation is only evaluated on UPDATE and DELETE clauses
I want SQL Server to throw an error at me if my SOURCE table contains duplicates as per the ON clause in every case, including INSERT, but it only does for the UPDATE and DELETE cases. Why doesn't it?
...
- 771
1
vote
0
answers
36
views
Selecting Duplicates on All Fields
I have an MS Access (no laughing at the back) database I've used to import a bunch of IIS logs into.
Having looked at the Excel files I pulled these in from, I'm worried going by the dates that some ...
- 11
1
vote
0
answers
42
views
How to use validation rule within database with drop down menus.
Building a scheduling database using access 2013 for my company. I currently have it set up so that only employees that have a rating of 3 or more for the particular job show up when you use the drop ...
- 11
2
votes
2
answers
2k
views
Insert/update data into relational database tables only after administrator approval - how to approach it?
I'm building a relational database that holds 21 tables, which is connected to my website application through PHP.
The website has search functionality which allows users to search this database. ...
- 25