Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Continuous Integration and test/compare Product Backend SQ..

  
   Database Help (Home) -> Programming RSS
Next:  I need help with a trigger  
Author Message
sippyuconn

External


Since: Apr 06, 2008
Posts: 6



(Msg. 1) Posted: Wed Apr 23, 2008 11:59 am
Post subject: Continuous Integration and test/compare Product Backend SQL DB tab
Archived from groups: microsoft>public>sqlserver>programming (more info?)
Hi

Have an application that is integrated into a Continuous Integration
environment.
All is well with the build. Part of the app loads text files into SQL Tables.

As part of the Continuous Integration I want to compare the contents of the
SQL Tables after the product is loaded with results from prior build or
validated results.

Looking for some suggestions on comparing the SQL Table contents???

Should I
a)Dump tables to text files and diff between 2 databases
b)Keep old database and run queries against the 2 databases

Any suggestions are appreciated
If this question is suited for another newsgroup - please let me know

Thanks

 >> Stay informed about: Continuous Integration and test/compare Product Backend SQ.. 
Back to top
Login to vote
Aaron Bertrand [SQL Serve

External


Since: Jan 10, 2008
Posts: 2166



(Msg. 2) Posted: Wed Apr 23, 2008 3:13 pm
Post subject: Re: Continuous Integration and test/compare Product Backend SQL DB tab [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
> a)Dump tables to text files and diff between 2 databases
> b)Keep old database and run queries against the 2 databases

I would prefer b) ... tools like Red Gate's SQL Compare (www.red-gate.com)
will help tremendously here.

 >> Stay informed about: Continuous Integration and test/compare Product Backend SQ.. 
Back to top
Login to vote
Charles Wang [MSFT]

External


Since: Apr 18, 2008
Posts: 268



(Msg. 3) Posted: Thu Apr 24, 2008 2:52 am
Post subject: RE: Continuous Integration and test/compare Product Backend SQL DB tab [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi,
If you installed Visual Studio 2005 Team Edition for Database
Professionals, you can simply create a Microsoft SQL Server Project and run
schema compare/data compare to check this. You may refer to:
How to: Compare the Data of Two Databases
http://msdn2.microsoft.com/en-us/library/aa833428(VS.80).aspx

If you do not have this edition of Visual Studio 2005 installed, I think
either a or b is OK. Your option a may win better performance; while b is
quite straightforward. Of course, as Aaron mentioned, you may also search
some third party tools for working out your requirement conveniently.

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg.TakeThisOut@microsoft.com.
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
 >> Stay informed about: Continuous Integration and test/compare Product Backend SQ.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Best way to represent category, subcategory, product - What would be the right pattern (is pattern the right word?) to model the following scenario in a relational database? A category has many subcategories, a subcategory has one category. So: Cat:(CatID, CatName) Subcat:(SubcatID, SubcatName, CatID) So....

Get the latest date of a product price - I have 2 tables, a list of products, and a list of product prices. The price table contains a list of the wholesale and retail price on any given date, so a product may have had several price changes and hence has several related records in the price...

Why does the Cartesian product of two tables differ when - Hi, I have the below two tables "TAB1" & "TAB2": TAB1 ---- T1C1 T1C2 ---- ---- 1 A 2 B 3 C TAB2 ---- T2C1 T2C2 ---- ---- 2 D 3 E 4 F When I executed the below sql statement, it displayed the Cartesian prod...

date compare - Hi. I have a commission report that resets the commision percent base on the first day of each year. Right now I have the date hard coded, so I have to go in and edit the code every year. I was wondering if there's a date function that will allow me...

best way to compare data - We're at the end of a long data conversion project and need to make sure all of the data from the old system is updated in the new system. The data was imported or entered manually, so there needs to be some kind of check to verify everything is..
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]