473,386 Members | 1,708 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Saving the db state for bug reproduction and tests

We are developing a .net database driven application. The application is
already quite complex and uses at time aprox. 150 data tables stored in the
MSSQL 2000 database server. Our application has multiple modules. Some
customers already use some modules while we currently developing more
modules.

The problem that we are starting to have is the difficulty to save the
database state in case of a bug. We need the database state in order to
reproduce and correct the bug and also to write and run some tests to be
sure the bug never occurs.

The simplest way is to use the MS SQL 2000 database back-up functionality.
Another way could be to use SQL Server Tools (like Red Gate, etc.)

I am also a student and I tried to find some answers in the academic field
(books, asking some other students/assistants) but nothing to find. It seems
that a solution can only be found in practice. That's why I ask the people
who had this kind of problem to help me to get closer to a solution. How are
you resolving this kind of problems? Which tools can be used to automate
this process?

Any ideas, literature, links could help me a lot.

Thanks,

George Homorozeanu.
Sep 20 '05 #1
0 952

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Jacob H | last post by:
Hello list... I'm developing an adventure game in Python (which of course is lots of fun). One of the features is the ability to save games and restore the saves later. I'm using the pickle...
138
by: theodp | last post by:
--> From http://www.techdirt.com/articles/20040406/1349225.shtml Microsoft Patents Saving The Name Of A Game Contributed by Mike on Tuesday, April 6th, 2004 @ 01:49PM from the...
5
by: Michael Albanese | last post by:
Can you save objects a (custom class) to Viewstate and then get them on a later page?? I have a custom class for an ASP.Net application that I would like to make available across several web...
1
by: Mahesh Devjibhai Dhola [MVP] | last post by:
Hi, User can adjust the size of columns of a table or the position of splitter in UI. We want these adjustments to be remembered when we restart the application. Currently, we are saving these...
11
by: cwdjrxyz | last post by:
Several threads have discussed the accuracy of time calculated using script when Daylight Saving Time (DST) is considered. A page at http://webexhibits.org/daylightsaving/ gives much information on...
0
by: headware | last post by:
I've been reading about saving the state of the controls of a page so the user can be redirected to another page and then return to the original in the state it was in when they left. I've seen a...
2
by: Børge Hansen | last post by:
Hi. I am trying to create functionality for saving the contents (state) of a page. The idea is that when navigating away from a webpage and later returning the state of the textboxes, etc should...
1
by: George Homorozeanu | last post by:
We are developing a .net database driven application. The application is already quite complex and uses at time aprox. 150 data tables stored in the MSSQL 2000 database server. Our application has...
1
by: nmahesh567 | last post by:
Hi All, I have a following task to be implemented in my project and I would like to know ideas and best possible solution with little code from you guys. Please let me know and any help would be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.