Questions tagged [testing]
The testing tag has no summary.
73 questions
1
vote
0
answers
63
views
How would I skip test compilation in a MySQL build?
As the title suggests, I am building MySQL version 8.0.37 from source on a Linux machine and would like to skip test compilation.
I have attempted adding the flag:
-DINSTALL_MYSQLTESTDIR=
which, ...
- 21
1
vote
0
answers
86
views
Writing .spec files for PostgreSQL isolation tests
I am developing a PostgreSQL extension for which I would like to run some tests with concurrent connections. If I understand the documentation correctly, I should be able to do so using the PGXS ...
- 824
3
votes
1
answer
496
views
How to cause a SQL Server database integrity error
I have created a stored procedure that uses dbcc checkdb on all userdatabases, if there are any errors detected it then collates the errors and formulates a html table and sends an html email to ...
- 163
3
votes
1
answer
2k
views
Create database from template database, concurrently, in Postgres
In order to run integration tests concurrently, I wish to create a sample database at the beginning of every test. Theses test databases are "clones" of an immutable reference database (the ...
- 155
0
votes
1
answer
116
views
How to handle an expected exception in base postgres
I want to be able to write a .sql script that will carry out an action which fails, and the script should only report failure if the action doesn't fail.
For example, given initial table:
create table ...
- 326
0
votes
0
answers
261
views
How to compare data between MYSQL and PostgreSQL table?
A database of MYSQL is migrated to Postgres. I need to check whether all the data records have been transferred correctly. Is there a way I can compare the contents of the two tables residing in two ...
user18326231
2
votes
2
answers
688
views
Is database development stages the same as software development?
In software development, there are a series of stages that it will goes through - Dev, Test, UAT, Staging, Demo and Production.
This is what I feel is correct, after reading/researching through the ...
- 153
1
vote
0
answers
149
views
SQL Server - cloning a subset of a database for a test environment
I'm trying to set up an automated script which I can run on a schedule in SQL Server 2016 (probably nightly) to copy the structure of our production database and then transfer a subset of data into ...
- 460
0
votes
1
answer
330
views
Stop Dataguard configuration to test standby database
I would like to know how it would be the correct way in which I should proceed to stop the Dataguard configuration in order to perform a series of tests on the standby database.
It turns out that I ...
- 169
0
votes
0
answers
66
views
How to speed up restore database from snapshot in SQL Server? [duplicate]
To revert a test database to an initial state (after running a test), I would like to restore the database from snapshot. I'm using the following script to achieve that. However, the script execution ...
- 39
3
votes
2
answers
1k
views
Speed up restore database from snapshot
To revert a test database to an initial state (after running a test), I would like to restore the database from snapshot. I'm using the following script to achieve that.
However, the script execution ...
- 39
4
votes
1
answer
6k
views
dbeaver check sql for syntax without running
Using the dbeaver tool, I want to check a script for syntax errors without actually running it.
Purpose:
For a long insert query (postgresql syntax, PostgreSQL 10.15) in the form of:
INSERT INTO ...
- 203
1
vote
0
answers
143
views
Testing SQL connections with UDL file
I am testing SQL connectivity between a SQL server (windows server 2000) and client PC that has no SQL tools installed (windows 2000 SP4). The client PC runs a java application that needs to connect ...
- 75
0
votes
1
answer
166
views
How to setup Mysql master-slave replication with the slave meant for testing where divergence is OK
Problem:
I have a staging DB server on which functionality is tested before pushing it to the production environment. Now, we want to start doing VA/PT (Vulnerability Analysis and Penetration Testing) ...
- 119
2
votes
1
answer
308
views
How to create development/test environment of TB reporting database in SQL Server
I am working on a couple large reporting databases with lots of reporting and analytical queries and many ETL jobs. When I make changes I usually do in in production, be that changes in indexing or ...
- 827