The testing tag has no wiki summary.
0
votes
0answers
29 views
How to test if any attribute values are different in duplicate tables?
I've got some ETL that I'm attempting to test. I want to test the canon data against another set which I run ETL on. My goal is to see if any values in any of the fields change.
The first test is ...
0
votes
0answers
113 views
Performance difference between MySQL and PostgreSQL for the same schema/queries
I'm a newbie DBA, and I have experience in Microsoft SQL Server but I want to jump to FLOSS.
I'm starting a company, and we develop an app (PHP) with a Postgres backend, and we did some tests ...
1
vote
1answer
56 views
System test Database user management
We are in development stage and to be able to give the developers an integration test environment, we need to give them access to the database, they can share and test their code in the system ...
2
votes
1answer
93 views
Good tool for simulating many threads doing INSERTS UPDATES SELECTS and DELETES on an ODBC database?
I've done load testing on a web application already using tools like JMeter, and tested my database for transactional integrity.
But are there any tools for testing an ODBC connected database (like ...
8
votes
2answers
318 views
How can I generate a random bytea
I would like to be able to generate random bytea fields of arbitrary length (<1Gb) for populating test data.
What is the best way of doing this?
0
votes
2answers
276 views
Creating a test database from Production database (different machines & servers)
I'd like to set up a test database on a separate server. Production database is MS SQL Server and the test server is a *nix box so I'd like to have the test server running either PostgreSQL or MySQL.
...
4
votes
3answers
173 views
What methods are available to create a snapshot of an oracle database for testing purposes?
I am new to databases and have just been assigned to work with Oracle. We want to create a snapshot of the database for testing purposes that will allow us to revert back once we're done.
I'm a bit ...
2
votes
1answer
283 views
Programatically testing slave status - What fields in SHOW SLAVE STATUS indicated slave status is OK / in ERROR?
We use pingdom and a few internal heartbeat mechanisms on our product.
We would like to add a 'are our slaves running and in good shape' check.
What fields in SHOW SLAVE STATUS indicate that the ...
2
votes
3answers
604 views
Easy or Schedulable way to move data from Production to Test
What I am looking to do, is schedule a copy of data from my production database to my dev/test database.
The dev/test database will be newer than the production database in terms of schema, but the ...
2
votes
2answers
518 views
What is a good way to verify that a restore completed successfully in SQL Server?
Right now, we test our SQL backups once a month by pulling the most recent backup file and restoring it onto a test database. If SQL Server says the restore is successful, we spot-check a few tables ...
0
votes
2answers
1k views
Progress OpenEdge - how to remove lock from table?
I have some kind of bug leaving lock on table in application that is connecting to Progress OpenEdge Database. Because of the lock I'm not able to test what app is doing wrong there (since I can't ...
1
vote
1answer
63 views
Design for a Testing system
I want to redesign a part of my system. I got the following objects:
Site:
id
Name
Site Version:
id
idSite
Name
Task:
id
idSite
Name
Test:
id
idTask
Name
TestResult:
idTest
idSiteVersion
...
6
votes
3answers
830 views
Testing stored procedure scalability
I have an email application that will be called upon to deliver to the UI the number of new messages for a given user on each page load. I have a few variations of things I am testing on the DB level ...
5
votes
3answers
262 views
Can this method for unit testing a stored procedure be improved?
When I have written unit tests for my stored procedures, they usually look something like this:
/* Unit test for stored procedure which runs a query */
/* Define #temp table with structure of query ...
8
votes
4answers
749 views
What tools are there to generate test data for SQL Server?
As you can see from another question of mine, generating test data is my theme right now.
At this point, I'm still generating my test data by hand. However, this process always generates small ...
0
votes
3answers
172 views
What all are the recoverable points of failure in an Oracle database?
I am testing a product against an Oracle database for failure scenarios. The product talks to Oracle through a session and maintains a few tables. I want to make sure that whenever Oracle recovers ...
3
votes
2answers
340 views
Testing Query Speed
When I'm running a query for the first time, it takes x miliseconds to be executed. When I run it the second time it takes a lot less time. I assume that it is some caching involved in this mechanism, ...
15
votes
4answers
481 views
What is your workflow for planning a data migration?
So many times I've been brought in at the end of a software development effort and been told something like "okay, we've got all this new code and it requires tables to change and data to be ...
5
votes
6answers
4k views
What tools are there for data masking? (MySQL, Linux)
I'm looking for (ideally free, open-source) data masking tools. Do any such exist?
Note: this related question deals with tools for generating test data, but in this question I'm more interested in ...
20
votes
4answers
737 views
How do you test for race conditions in a database?
I try to write database code to make sure that it's not subject to race conditions, to make sure that I've locked the correct rows or tables. But I often wonder: Is my code correct? Is it possible to ...
