The tag has no usage guidance, but it has a tag wiki.

learn more… | top users | synonyms

1
vote
1answer
34 views

Easy way to have non-tech users modify database?

We're in the process of engineering a BI solution. One problem we have is that sadly a lot of HR information (start date, department, department change date, work hours, etc etc) -- seems to me ...
4
votes
4answers
188 views

Validate three digits before decimal and after decimal point six digits

I have columns called longitude and latitude with nvarchar data type. The user can enter something like (23.23424432),(432423.343), which should not be allowed. Can anyone help me to validate this in ...
5
votes
1answer
603 views

Best Practice for SQL Server data validation

I have CSV files that I would like to import into SQL Server 2014. Each record in the files has around 20 columns, each of them should be validated for data type compliance as well as some other ...
2
votes
1answer
192 views

How to validate data before loading it to DB

I have a situation where in I have million records in CSV file, what I need to do is to apply some business validation on certain columns of CSV and load data to DB only if particular record is valid. ...
1
vote
1answer
88 views

MySQL-load data infile- invalid data validation

Is it possible to validate the data and load it in a table using 'load data infile'? This is the query load data local infile 'C:/Users/970685/Desktop/SFcheck.csv' into table wow_macro....
0
votes
0answers
52 views

Why is my valid index not working with DBMS_COMPARISON.CREATE_COMPARISON?

Thanks in advance. I'm trying to use the DBMS_COMPARISON utility to check records in the existing schema vs. other linked databases. The table has a composite primary key. It consists of the NAME ...
3
votes
1answer
273 views

Table structure for validating data using category and subcategory fields

I am creating a simple budget application, and the primary table will be a transaction table that contains things like the amount of the transaction, date, account, the category and subcategory (the ...
1
vote
1answer
30 views

Can I enforce one field being dependent on another?

I would like to know if it's possible to have two fields (in this case bits) in the same table where one is dependent on another. For example Check2 may only be true if Check1 is true. Note: I'm ...
0
votes
1answer
53 views

Multiple queries and a report

im fairly new to databases. I have multiple query's that i normally run individually at the end of loading data to my table doing simple integrity checks like length ,char types and so on (see ...
1
vote
1answer
131 views

Compare table content from different PostgreSQL 9.3 DBs

The problem How do I efficiently and idiomatically compare the content of two tables, each in a different DB? I have 3 DBs (the classic dev, stg and prod). Each DB has a few tables which should be ...
2
votes
1answer
5k views

How to check the consistency of tables in mysql

I have few questions regarding consistency in Mysql in two scenarios 1st scenario: How can I verify a restored backup matches the original DB data on all the tables? We have two hosts with the same ...