Does anyone have an opinion on specific “data comparison tools�?
We are looking for something to use in our test or dev environments that will be able to compare snaps shots of the data in a database before verse after a test event.
We have been able to record and compare data in specific tables but are learning that other tables were also being changed that we didn’t track. We want to be able to see all changes to a database.
Michael
Hi all,
Does anyone know any open source tool out there for these purposes?
1. Compare data rowcounts from two databases of the same structure.(On different servers).
2. Compare the structures of two databases.(On different servers).
3. Tool a developer can run on his/her desktop to capture a log of the database that his application is hitting.
Again all, I am new to the database world. Thank you for all assistance.
Just wondering if there are any tools available for SQL Server 2005 which allow the comparison and scripting of data and schema between two databases. This is so that I can migrate between Dev, QA, and Live easily.
A free tool would be best please..
Thanks in advance.
Gaj
http://www.download.com/Firefly-Dat...j=uo&tag=button
View 1 Replies View RelatedCan someone recommend what SQL Database compare tool to useand why?Thank you
View 1 Replies View RelatedI am looking for a tool to compare the result sets.
Is there any free tool or Microsoft built in tool that we can use to compare the result sets. Suppose if I change one thing in code and needs to test the am I getting the same result set or not? Instead of doing manually is there any way to compare both result set.
Does that make sense? I have 2 tables, one is an older version, one newer. The newer version has some additional fields, indexes, etc. I'd love to have a tool to run against them that would generate an ALTER TABLE script to modify the old table so that it matches the new table.
Is there anything like that out there?
I Have a problem when copying data from one server to another in Management studio, I need to create and exact copy of the original because of primary key relationships,
Currently when I export the data the data will run through an insert type statement, which means that all PKs are reissued, rather than being duplicated from the original, How can I be sure that the data will be copied exactly how it is on one server to the other.
I need a recommendation on a data modeling tool that can be used with a data warehouse. My warehouse is running SQL 2012.
Here is my challenge: Most of the tables in the warehouse do not have primary keys and none of the tables have foreign keys on them. However, there are indexes and unique keys/indexes on the tables. I am looking for a tool that I can create virtual relationships on how the data is related, so it is visually easier for the ETL developers to write the code.
I have looked at both ER/Studio 11 and ERwin 9.6. Neither of them do it exactly the way I want it too. However, ER/Studio is pretty close.
any one got a freeware/shareware tool that can script a table's contents?
you know...that it will make a text file of sql insert statements of data for each row in an existing table?
danka!
What is the Web Data Administration tool? More specifically, how does is it different from Enterprise Manager?
View 1 Replies View RelatedI am new to Data Mining
I downloaded the SQL SERVER 2005 Evaluation Edition.
Question:
For Data Mining which Product Edition of VISUAL STUDIO 2005 i have to download ? ,
I am developing one automation tool for data migration from one table to other table, here i am looking for one function or SP for which i will pass source column and destination column as input parameter and want output parameter to return true when source column data is compatible to copy to destination column if not then it should return false.
For example if source column is varchar and destination column is integer, the script should check all the data in source column in good enough to move to integer column or not and return the output flag. I want a script to work this for all types of data types.
Hello everybody, I just wanted to share with you a control that I have been using that has made my life easier:
http://www.geocities.com/scirocco_ha/DataControl.htm
After selecting the CursorType, CursorLocation, LockType and Disconnected status of your Recordset (there are defaults). I bind my controls and that is it
Then I can Navigate, Add New, Delete, Refresh, Search and Save Changes to my recordsets without any other code. That is really it, no other code is needed.
Another marketing campaign :eek:
View 1 Replies View RelatedCan anyone recomend an EXTREEMLY user friendly web based data mapping / conversion tool? I am wanting to transform csv, xml, database sources into csv, xml, db sources. There are a ton of Windows based applications (ie: www.altova.com / mapforce). I am looking for something I can expose via the web...
users has ability to upload a csv file and then define how the data would be mapped to an output source (say another csv or xml). In addition having functions like concantination, sum, if-exists, etc...
Does SSIS have a user friendly interface or has someone written some interactive tools on top of SSIS.
Any information will be greatly apreciated.
Thanx
Hello,
I have some data coming up from an SQL Server source, I have to add it to another SQL Table on the basis of what destination table already have.
For instance, if there is already an entry there for particular record (based on matching primary key value), then I just need to updated 3 columns, otherwise need to insert.
The problem is, I know how to do it by using script component, but I am wondering if there is a better tool that saves me writing code
Any idea?
Thanks,
Fahad
Hi some days ago i put a thread in this forum asking how can i publish my database on a shared server, and i was adviced to use Data Publishing Wizard Tool. But now i'm facing another problem, the database is on the server being filled with data by my clients throught the system that i'm developing but because the system is under construction i have to change some tables once in a while, something like add one or another constraint, add or fix an stored procedure, add for example a field named "Archive" so i dont delete data from the database instead i archive it.. this are the only changes i'm doing.. the database is well modelated so i don't need to do further changes ...
So my problem is how can i reflect this changes on the shared server without deleting the data that are already there? Is it possible, or i have to do it manualy on the server what i have already done on the database hosted on my localhost?!
Hello All,
How to I compare the data between prod and dev databases. I need to create sql script to list the new data and the modified data in development tables comparing with the production tables.
Can anyone give me suggestions on how to do it?
Thanks in advance,
-S
was able to load data from 2005 to 2000 about 100+ tables. Now i'm only concerned about if data is the same the rows and data types (not sure if there is any difference). Any ideas how to test it? should i go row-by-row???? its over 100 tables. OH MY goood...
View 5 Replies View RelatedI've created two tables. One table (Classes) stores data about classesthat we offer. The Classes table stores the class id (classid) and themax number of students allows (maxstudents). The other table(Students) stores student data and the class they register for.When a user registers for a class, the classid column data from Classespopulates the class column in Students.I'm not sure how to count the number of students who registered forcourse X, subtract that from the max number of students in the Classestable, and display that the class if the max is reached either in awarning dialog box or as text on the page.I'm also populating a drop-down field on the registration form with theclass information from Classes. Confused yet?I don't know much about SQL or .ASP. Any help is appreciated.
View 2 Replies View RelatedHello all,I am new to sql and have some Access experience.In sql, how do I: compare 2 identical tables, (except for data); then updatetable 1 with new data from table 2TIAJake
View 1 Replies View Relatedhi, all.I want to verify data merged from access in sqlserver.but it has toomany records .so i need a tooldo this.someone maybe has it.thanks
View 1 Replies View RelatedI know this sounds simple, but I haven't seen it in bol. I need to compare two tables, and list what rows are unique to each table. Thanks for the help!
rb
I have two tables and I want to know if every record from the first table is in the second one and if its data mathes exactly?
Any suggestion for a short way to do this?
Thank you!
I am using MSSQL v8 (if that matters)
The data looks like the following
---------------------------
| PBP 20070420 2:26pm |
---------------------------
Now the data in this field is not uniform it can be blank, a sentence or have a different pre fix, instead of PBP, but the date will be YYYYMMDD when it is supplied.
I need to find all the dates that are within the last 10 months. How do I perform this task?
Hi all,
Newbie here. I was wondering if any of you gurus could answer a question for me. Here is what I need to do (and I stress need):
I have 2 tables.
Table A has 3 columns, column 1 is unique customer numbers, column 2 is ticket numbers, column 3 is empty records.
Table B has 2 columns, column 1 is unique customer numbers (same numbers, although not the same order as Table A) , column 2 is invoice numbers.
I need to compare Table A where records in column 1 match records in column 1 in Table B. Where the records do match, I need to copy the records from Table B, column 2 to Table A column 3.
Can anyone here help me with this, please? It would really get me out of a jam with this, since it is the last step I have to take to finally get this new app rolled out.
Thanks a lot.
Mark
I have a billing database with patient names in it. I received a tab delimited file from insurance plan of our roster of assigned patients.
I now want to compare the insurance roster to our database to see who is missing.
The roster is layed out like this (info jumbled to protect privacy):
Eligibility List Sample
Last Name First Name Date of Birth Gender Insured ID VW Acct #
ALLEN CARRIE A4/16/1939FDH36664A572576-02
BAKER AMBER S11/24/1956FFXI2824C596439-02
BARKLOWLOREN R12/15/1956MKVF0092A588878-01
BRENNANPATRICIA A 1/14/1959FFXI8763A549675-02
BROWN MARTHA E8/14/1967FBD65508A366963-02
CALDWELL MICHAEL V 12/19/1969MLR500N2J595087-01
CLARK CYNTHIA A4/24/1971FVO600M8O596011-02
DEMPSTER SCOTT A 2/21/1976MCC85242A573371-01
DUNNE ANNETTE M10/26/1976FAE88375D598423-02
DUNNE CHRISTOPHER M 8/1/2021MBV81536A598423-01
I have loaded the text into an Excel Spreadsheet to work with it.
I was able to query our patient profile data base to get people with this insurance plan...but of course the data is never an ideal match.
For instance, some of the roster patients above have Middle Initials Concatenated to the First Name. In my database it is a mixed bag of missing initials, initials concatenated to first name or initials in separate Middle field. Thus a strict match on name is not going to work.
Date of Birth should hopefully be valid between both data sources.
Probably the best source of data to validate on would be the VW Acct# as I trust this to be the same in both sets of data. However in my patient data base it is buried in a note field preceded by a "Vital Works ID: " and then the number 602659-02. Generally it is the first part of the note field, but there could be additional notes preceding or trailing this Vital Works ID info.
An example of the query I was able to pull from the patient data base is as follows:
LastFirstMiddleDate of BirthGenderNotes
ClarkLawrence J9/7/1955MVital Works ID: 7575-01
ClarkKayleeann NULL1/3/1955FVital Works ID: 7575-02
ColeCodyNULL8/19/1948FVital Works ID: 8771-02 snt ref req to ohms for impact appt tbs Sent ref req back to ohms for Impact-DX.
CreaseyWadeL7/9/1988FVital Works ID: 602659-02
KennyRoyJ2/27/1953FVital Works ID: 602679-02
UttJannieC4/11/1984MVital Works ID: 602715-01
WestAliciaG9/9/1992MVital Works ID: 602736-02
WrightMinnieO2/17/1991MVital Works ID: 602736-03
YankeeDonald E10/27/1996MVital Works ID: 602762-03
YankeeStephana A4/4/2001FVital Works ID: 602762-04
How could I now construct a query that would tell me what patients were in the eligibility roster that didnt have a match in the patient database?
I would like to then save that to Excel or somewhere that I could print it out from so I can have someone up date the database.
Thanks for your help.
Hi all,
i have a question regarding data comparison in two tables in same database with same table structure.
my table structure is like this
CREATE TABLE xxgfs_gen_text_lookups_new (
lookup_type VARCHAR2(200) NOT NULL,
region_code VARCHAR2(30),
nongfs_value1 VARCHAR2(200),
nongfs_value2 VARCHAR2(50),
nongfs_value3 VARCHAR2(50),
gfs_value1 VARCHAR2(200),
gfs_value2 VARCHAR2(50),
gfs_value3 VARCHAR2(50),
retain_nongfs_for_dflts VARCHAR2(1),
retain_gfs_for_dflts VARCHAR2(1),
comments VARCHAR2(500),
created_by NUMBER(15),
creation_date DATE,
last_updated_by NUMBER(15),
last_update_date DATE,
last_update_login NUMBER(15),
Source_description varchar2(300),
Oracle_description varchar2(300),
defaults varchar2(300)
)
ALTER TABLE xxgfs_gen_text_lookups ADD CONSTRAINT xxgfs_gen_text_lookups_uq_1
UNIQUE (lookup_type,region_code,nongfs_value1,nongfs_value2,nongfs_value3);
i have some data in excel which i have uploaded using sql*loader using control card.Now i want to compare the data in both tables having same table structure only
do any body having idea how to compare the data using storeprocedure.
thanks in advance
regs,
Rajnish kumar
I am trying to determine the changes an application makes to a database.The plan is to copy the existing schema (active) to a reference schema, runthe application and then diff the table data between the reference and thea active schema. I have found one software vendor who has a tool to dothis, but it will only do one table at a time (interactively); I have morethen 300 and will run this a few times.One other way of determining the changes, I guess, would be to log all sqlstatements (in order), but I don't know how to do this (either).Any pointers would be greatly appreciated.Leo
View 3 Replies View RelatedUsing SQL data compare i get the following error message:Could not allocate space for object '(SYSTEM table id: -701903460)' indatabase 'TEMPDB' because the 'DEFAULT' filegroup is full.The comparison is being run on one server between to databases. It hasbeen run several times but each time we get that error message, thetable ID number tends to change each time. We also had a problembefore where the 'TEMPDB' did not have enough space in its log filebut that was fixed by allowing the database to expand in size.
View 1 Replies View Related
SET identity_insert dbo.table1 on
GO
insert into dbo.table1(
PrimaryKeyCol,Col1, Col2 .....)
select
PrimaryKeyCol,Col1, Col2......
from [Sever].Database.dbo.table1 as ClientColumn
where not exists(
select * from dbo.table1 as ServerColumn
where ServerColumn.PrimaryKeyCol = ClientColumn.PrimaryKeyCol
)
DELETE FROM [Server].Database.dbo.table1
where exists(
where ServerColumn.PrimaryKeyCol = ClientColumn.PrimaryKeyCol
)
SET identity_insert dbo.table1 off
GO
I can't complie this code.. anybody see where I went wrong??
Thanks for all your help.
is it possible to change the settings on this tool. i want to have it so that it does not time out at all? or is that possible??
View 1 Replies View Related