Oğuz Yağmur'un Günlüğü
Net Bi'log (Tecrübe, ilimden üstündür. İbn-i Sina)
Navigation for Oğuz Yağmur'un Günlüğü - tablediff.exe
Content
Sidebar
Footer
August 26, 2008
@ 10:35 PM
Comments [3]
tablediff.exe
Bazen aynı database içindeki tablolar ya da farklı database lerdeki tabloları ya da farklı sunuculardaki farklı databaselerdeki tabloları karşılaştırmak isteyebiliriz. Sql 2005'i kurduğunuz da
C:\Program Files\Microsoft SQL Server\90\COM
dizininde
tablediff.exe
isimli bir araç ile bu karşılaştırmaları yapabiliyoruz. Aşağıdaki resimde gördüğünüz gibi aynı sunucu üzerinde diffTest ve difftest1 isimli iki farklı database oluşturdum. Her iki database'e de kullanicilar isimli tablo ekledim. Ve her ikisine de farklı veriler girdim.
Şimdi geldi tablediff.exe yi kullanmaya. Bu araç ile ilgili detaylı bilgiyi
şurdan
edinebilirsiniz. Göreceğiniz üzere bir hayli fazla parametre alarak çok kapsamlı işler yapabilen bir araç. Ben sadece çok basit olarak iki tabloyu karşılaştıran ve farkları bana ismi "fark" olan bir tablo şeklinde vermesini istedim. Bunun için komut satırından aracı aşağıdaki gibi kullandım.
C:\Program Files\Microsoft SQL Server\90\COM>tablediff.exe -sourceserver ".\sql2005" -sourcedatabase "difftest" -sourcetable "kullanicilar" -destinationserver "
.\sql2005" -destinationdatabase "difftest1" -destinationtable "kullanicilar"
-et
"fark"
Bu kullanımda difftest1 database'inde fark isimli bir tablo oluşturuyor.
Birbaşka örnek olarak da, her iki tablodaki farkları giderecek bir sql sorgusu üretmek için yine komut satırından aracı aşağıdaki gibi kullanmak gerekiyor.
C:\Program Files\Microsoft SQL Server\90\COM>tablediff.exe -sourceserver ".\sql2005" -sourcedatabase "difftest" -sourcetable "kullanicilar" -destinationserver "
.\sql2005" -destinationdatabase "difftest1" -destinationtable "kullanicilar"
-f
"farklari_gider.sql"
Bu işlem sonucunda oluşan dosyanın içeriği aşağıdaki gibi oldu.
-- Host: .\sql2005
-- Database: [difftest1]
-- Table: [dbo].[kullanicilar]
SET IDENTITY_INSERT [dbo].[kullanicilar] ON
UPDATE [dbo].[kullanicilar] SET [ad]='osman1' WHERE [id] = 2
UPDATE [dbo].[kullanicilar] SET [ad]='murat1' WHERE [id] = 3
SET IDENTITY_INSERT [dbo].[kullanicilar] OFF
Bu T-SQL'i çalıştırdığınızda her iki database'deki tabloların içerikleri eşitlenmiş olacaktır. Aracın geniş kullanımını yukarda belirttiğim linkten detaylı inceleyebilirsiniz.
Categories:
Inceleme
Related posts:
Tech-ed 2009 Berlin Episode-II
Çok mu basit ?
LINQ to SQL ne durumda ?
Kral Çıplak! mı?
Dil yenilikleri ve Faydaları
C# Code Injection ( Bir Managed Exe ya da DLL'e Kod Ekleme)
« Visual Studio 2008 Service Pack 1 ve .N...
|
Home
|
ServiceController »
Friday, October 16, 2009 10:49:26 AM (GTB Daylight Time, UTC+03:00)
<h2 align="center">Costs For Uggs--What It Costs?</h2>
<p>-->Are you lusting after a few (or even more) <a href="http://www.goodugg.co.uk/ugg-classic-cardy-c-161.html">Ugg boots</a> and if so, you're in good company, as girls and women of all ages, especially with the simple, slipper-like design of these sheepskin <a href="http://www.goodugg.co.uk/grey-ugg-boots-5819-classic-cardy-p-23458.html">ugg boots sale </a>, which are relatively easy and very comfortable to wear. And they appear to be affected. Some men are also jumping on the trend and luxury UGGs? Australia, the brand also offers a range of contemporary styles for them.</p>
<p>-->Could you mind giving everyone loves from <a href="http://www.goodugg.co.uk/ugg-classic-tall-c-162.html">ugg classic </a>? There are so many types of uggs, <a href="http://www.goodugg.co.uk/ugg-bailey-button-c-178.html?zenid=847c0f495b87cb43928dcc19d09f4019">ugg bailey button</a>,ugg <a href="http://www.goodugg.co.uk/ugg-classic-tall-c-162.html">classic tall</a>, ugg <a href="http://www.goodugg.co.uk/ugg-classic-short-c-160.html">classic short</a>, ugg <a href="http://www.goodugg.co.uk/ugg-classic-cardy-c-161.html">classic cardy</a>. How to choose your favorite? Or do you really want to one uggs regardless its style? Despite their design is awkward and slipper-lile, <a href="http://www.goodugg.co.uk/">Uggs</a> is one of the few stations that are of general interest, have argued that cross generational lines.</p>
<p>-->Young people, students and young mothers and the Middle Ages, the original Black <a href="http://www.goodugg.co.uk/ugg-ultra-tall-c-167.html">Ultra Tall UGG Boots</a>, seem pulled the fleecy-lined boots that are manufactured in Australia, with the best materials. Are you sure that your feet warm in winter without socks, and cool in summer so that is more versatile too? If no, hurry up to take one <strong>ugg boots </strong>on <a href="http://www.goodugg.co.uk/ugg-classic-tall-c-162.html">uggs on sale</a> ! That's why we see people wear them in schools, supermarkets, on the slopes and even in the most popular beaches in the United States and abroad. Many surfers also use uggs to keep their feet warm.</p>
<p>-->What do you really care about? Is its price or quality, or you just following the general trend? You know what are you thinking in your heart!</p>
angelia110
|
sharing_09AT NOSPAMhotmail dot com
Saturday, October 24, 2009 3:15:38 PM (GTB Daylight Time, UTC+03:00)
why the ugg bailey<strong> <a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge sale</a> </strong>button boot is so popular? as we known,<strong><a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge boots</a></strong> have morphed together their two most popular styles. they started with the ever-popular <strong><a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge sand</a></strong> and then added a wooden <strong><a href="http://www.linkboots.com/ugg-classic-cardy-5819-c-26.html">classic cardy uggs grey</a></strong> from their best-selling, as seen on oprah, uggcardy. they are one pop-fusion<strong> <a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge black</a></strong>. when the new fall step into our life this year, <strong><a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge on sale</a></strong> are beginning search for an footwear going together with their jeans. now you are reaching to the every <strong><a href="http://www.linkboots.com/ugg-classic-cardy-5819-c-26.html">classic cardy ugg australia</a></strong> for the latest fashion trend. in past two or<A href="http://www.thegoodboots.com/specials.html" target="_blank"><strong> </strong></A>three years, the <strong><a href="http://www.linkboots.com/ugg-classic-cardy-5819-c-26.html">classic cardy uggs on sale</a></strong> kept women, men and kids <strong><a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge boot</a></strong> salewarm and cozy under its super-popular fashion. <strong><a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge chestnu</a></strong><a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">t</a> the new fall in 2009, we get<strong> <a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge uk</a></strong>. the <strong><a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">knightsbridge uggs</a></strong> become the first choice for ugg follower<strong> <a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge ugg boots</a> </strong>and getting hotter and hotter. the <strong><a href="http://www.linkboots.com/ugg-womens-knightsbridge-c-50.html">ugg knightsbridge uggs on sale</a> </strong>style c the bailey button has become a must have this winter. now<strong> <a href="http://www.linkboots.com/ugg-bailey-button-5803-c-30.html">ugg australia bailey button</a> </strong>there are 5 colors available in 5 colors including black, chestnut, grey, chocolate and sand on<strong> <a href="http://www.linkboots.com/ugg-bailey-button-5803-c-30.html">ugg australia bailey button boot</a></strong>. we provide enough stock for this fall and winter. you <A href="http://www.thegoodboots.com/ugg-classic-cardy-c-2.html" target="_blank"><strong>ugg shoes </strong></A>wil enjoy shopping anytime before this <strong><a href="http://www.linkboots.com/ugg-bailey-button-5803-c-30.html">ugg boots bailey button</a></strong>. anyway, the popular classic styles including <strong><a href="http://www.linkboots.com/ugg-bailey-button-5803-c-30.html">bailey button grey uggs</a></strong>, ugg boot short (5825) and<a href="http://www.linkboots.com/ugg-classic-cardy-5819-c-26.html"> <strong>classic cardy ugg boots</strong></a><strong></strong> are all your choices. tags ?
uggboots
|
linkbootsAT NOSPAMbazargo dot com
Tuesday, December 22, 2009 3:18:49 AM (GTB Standard Time, UTC+02:00)
20091222c1ygy I wear <a href="http://www.boonoutlet.com/ugg-genuine-womens-nightfall-boots-black-p-1251.html">UGG Nightfall Boots on sale</a>is considered a kind of a fashion trend, this trend has affected the whole world. If you have not tried, then it is regrettable. With the advent of winter, <a href="http://www.boonoutlet.com/ugg-new-arrival-suede-boots-5230-black-p-1279.html">UGG New Arrival Suede Boots </a>online become popular up a lot of people can not wait to experience the feeling of wearing ugg prices ugg some people appear to be high, ugg boots online above ugg style good, <a href="http://www.boonoutlet.com/ugg-boots-gray-carved-in-pattern-on-hot-sale-p-1226.html">UGG Gray classic tall</a> are always welcome to many people as it is high quality and fashion design.For myself,i like this
<a href="http://www.boonoutlet.com/ugg-authority-classic-mini-boot-black-for-women-p-1014.html">UGG Classic Mini Boot </a> very much,you can have it and show yourself now,it is not let you downUgg Napoule Sandal,the price is not expensive. To meet your needs, make haste to experience the feeling of the trend.
ugg
|
freeAT NOSPAMyahoo dot com
Name
E-mail
Home page
Remember Me
Comment (HTML not allowed)
Enter the code shown (prevents robots):
Live Comment Preview
Bilgi
BT Akademi
C#nedir?com
RSS/Subscribe
Archives
All dates
All Posts
Search
Latest Posts
Visual Studio 2010 Kullanıma Hazır
Sonunda ne olacak acaba?
INETA NEXT Türkiye Turu
Tech-ed 2009 Berlin Trilogy
Tech-ed 2009 Berlin Episode-II
Tech-ed 2009 Berlin Episode-I
WPF Web Semineri
Bir OOP & Design Patterns Eğitiminin Ardından
ASP.NET MVC 1.0 Semineri
Çok mu basit ?
Dinamik Assembly Yüklerken Bağımlılıkları Dikkate Almak Lazım
LINQ to SQL ne durumda ?
Güzel Bir Eğitimin Ardından
Congratulations, you've installed dasBlog with Web Deploy!
Kral Çıplak! mı?
Güzel Bir Etkinlik Daha Gerçekleşti
Nesefleri Bıraktık
HashSet<T> Hakkında
Dil yenilikleri ve Faydaları
INETA Professional Hit Etkinliğine Bekliyoruz.
C# Code Injection ( Bir Managed Exe ya da DLL'e Kod Ekleme)
SharepointTurkiye.org
C# 3.0 let keyword
(CodeFn) Registry ve Dosya Uzantısı Tanıtma
C# 3.0 - İsimsiz Tipleri ( Anonymous Types ) Çözmek
Test ;)
Gözden Kaçan BreakPoint Özellikleri
Yararlı Debug Attributeleri
Generics Singleton
VS.NET 2010 ve .NET Framework 4.0
Eğlenceli Yield
I'm a PC
(CodeFn) Recursive Anonymous Method
ServiceController
tablediff.exe
Visual Studio 2008 Service Pack 1 ve .NET Framework 3.5 Service Pack 1 Duyruldu
C# 3.0 ile Dosya İsimlerini Gruplayarak Listeleme
C# 3.0 Belirsiz Tipden Dizi
Takım Çalışmasında web.config Sorunsalı
BT Akademi 3 Yaşında
.NET Radyo Bölüm 3 ve 4
IHttpHandlerFactory ile Çalışma Zamanı HttpHandler Belirlenmesi
Assembly' leri
Düz
enle
mek
( ntcore's CFF Explorer)
Yararlı 3 Vs.net 2008 Kısayolu
Programatik Olarak GAC 'a Assembly Yüklemek
C# 3.0 Nesnelere Ilk Değer Verme ( Object Initializer )
Response.Filter : Çıktıyı Filitrelemek
Linq To Sql Immediately Load
MVP (Visual C# )
Faydalı Araçlar : Fiddler, LinqPad , FireBug
Categories
.NET (53)
Asp.net (25)
C# (29)
Code (34)
dasBlog (1)
Inceleme (57)
Internet (34)
Yasam (37)
Archives
April, 2010 (1)
December, 2009 (2)
November, 2009 (4)
October, 2009 (2)
July, 2009 (1)
June, 2009 (2)
April, 2009 (1)
March, 2009 (1)
January, 2009 (7)
December, 2008 (1)
November, 2008 (6)
October, 2008 (2)
September, 2008 (3)
August, 2008 (4)
July, 2008 (6)
June, 2008 (3)
May, 2008 (1)
April, 2008 (1)
March, 2008 (4)
February, 2008 (2)
January, 2008 (6)
December, 2007 (1)
November, 2007 (3)
October, 2007 (5)
September, 2007 (8)
August, 2007 (7)
July, 2007 (4)
June, 2007 (1)
May, 2007 (6)
April, 2007 (6)
March, 2007 (9)
February, 2007 (9)
January, 2007 (6)
December, 2006 (6)
November, 2006 (5)
October, 2006 (16)
September, 2006 (12)
August, 2006 (20)
July, 2006 (7)
June, 2006 (2)
September, 2005 (2)
August, 2005 (1)
BlogRoll
Categories
.NET
Asp.net
C#
Code
dasBlog
Inceleme
Internet
Yasam
Contact the Author
oguz(nokta)yagmur(at)btakademi(nokta)com