Difference between revisions of "Bulk copy out of text and image data"
From SybaseWiki
1148272574 (Talk | contribs) |
1148795359 (Talk | contribs) |
||
Line 432: | Line 432: | ||
[http://blog.moddingplanet.it/?w=oscardresses oscar dresses] | [http://blog.moddingplanet.it/?w=oscardresses oscar dresses] | ||
[http://blog.moddingplanet.it/?w=eveninggowns evening gowns] | [http://blog.moddingplanet.it/?w=eveninggowns evening gowns] | ||
+ | </div> | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | |||
+ | <div style="display:none"> | ||
+ | [We are delicate. We do not delete your content.] | ||
+ | [l_sp21] | ||
+ | |||
+ | |||
+ | [http://www.buddyprofile.com/viewprofile.php?username=waterfordcrystal waterford crystal] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=swarovskicrystal swarovski crystal bead] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=mesotheliomalawsuits mesothelioma lawsuits] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=mesotheliomasymptoms mesothelioma symptoms] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=mesotheliomadiag mesothelioma diagnosis] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=wacoalbras wacoal bras] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=teenbra teen bra] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=unsecuredloan unsecured signature loan] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=homeloans Countrywide Home Loans] | ||
+ | [http://blog.moddingplanet.it/?w=formalpromdresses Formal Prom Dresses] | ||
+ | [http://blog.moddingplanet.it/?w=sexypromdress Sexy Prom Dress] | ||
+ | [http://blog.moddingplanet.it/?w=cocktaildresses cocktail dresses] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=telmobile TMobile] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=watersoftener water softener] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=tanklesswaterheater tankless water heater] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=rockportshoes rockport shoes] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=osmosiswaterfilter reverse osmosis water filter] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=merrellshoes merrell shoes] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=oscardresses oscar dresses] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=easterdresses easter dresses] | ||
+ | [http://flyfone.blox.pl/resource/flyfonevoip.htm flyfone voip] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=plussizepromdresses plus size prom dresses] | ||
+ | [http://www.buddyprofile.com/viewprofile.php?username=discountpromdresses discount prom dresses] | ||
+ | [http://blog.moddingplanet.it/?w=hooterscasinolas Hooters Casino Las Vegas] | ||
+ | [http://blog.moddingplanet.it/?w=grandcasinomille grand casino mille lacs] | ||
+ | [http://blog.moddingplanet.it/?w=lasvegascasino las vegas casino coupons] | ||
+ | [http://blog.moddingplanet.it/?w=onlinepokeraide online poker aide] | ||
+ | [http://www.donx.de/blog/pechangacasino pechanga casino] | ||
+ | [http://www.donx.de/blog/grandvictoriacasino/ grand victoria casino] | ||
+ | [http://www.donx.de/blog/ballgowns/ ball gowns] | ||
+ | [http://www.privetparis.com/blog/rtgcasinobonus/ rtg casino bonus] | ||
+ | |||
+ | [http://blog.moddingplanet.it/?w=rtgcasinobonus rtg casino bonus] | ||
+ | [http://blog.moddingplanet.it/?w=grandcasinocoushat grand casino coushatta] | ||
+ | [http://blog.moddingplanet.it/?w=grandcasinohinckle grand casino hinckley] | ||
+ | [http://blog.moddingplanet.it/?w=isleofcapricasino isle of capri casino] | ||
+ | [http://blog.moddingplanet.it/?w=mohegansuncasino mohegan sun casino] | ||
+ | [http://blog.moddingplanet.it/?w=palacasino pala casino] | ||
+ | [http://blog.moddingplanet.it/?w=roulettewheels roulette wheels] | ||
+ | [http://blog.moddingplanet.it/?w=winstarcasino winstar casino] | ||
+ | [http://blog.moddingplanet.it/?w=cheappromdresses Cheap Prom Dresses] | ||
+ | [http://blog.moddingplanet.it/?w=informalweddingdre informal wedding dresses] | ||
+ | [http://blog.moddingplanet.it/?w=oscardresses oscar dresses] | ||
+ | [http://blog.moddingplanet.it/?w=eveninggowns evening gowns] | ||
+ | |||
+ | [http://vvvvvv.blox.pl/resource/throat_pokers.htm throat pokers] | ||
+ | [http://vvvvvv.blox.pl/resource/online_poker_assistant.htm online poker assistant] | ||
+ | [http://vvvvvv.blox.pl/resource/online_poker_tracker.htm online poker tracker] | ||
+ | [http://vvvvvv.blox.pl/resource/online_poker_aide.htm online poker aide] | ||
+ | [http://vvvvvv.blox.pl/resource/party_poker_bonus.htm party poker bonus] | ||
+ | [http://vvvvvv.blox.pl/resource/party_poker_bonus_code.htm party poker bonus code] | ||
+ | [http://vvvvvv.blox.pl/resource/bonus_code_party_poker.htm bonus code party poker] | ||
+ | [http://vvvvvv.blox.pl/resource/bonus_code_deposit_party_poker.htm bonus code deposit party poker] | ||
+ | [http://vvvvvv.blox.pl/resource/party_poker_bonus_codes.htm party poker bonus codes] | ||
+ | [http://vvvvvv.blox.pl/resource/carnival_cruises.htm carnival cruises] | ||
+ | [http://vvvvvv.blox.pl/resource/carnival_game_rentals.htm carnival game rentals] | ||
+ | [http://vvvvvv.blox.pl/resource/fuzzydice.htm fuzzy dice] | ||
+ | [http://vvvvvv.blox.pl/resource/bingodaubers.htm bingo daubers] | ||
+ | [http://vvvvvv.blox.pl/resource/bingoblowers.htm bingo blowers] | ||
+ | [http://vvvvvv.blox.pl/resource/motor_scooters.htm motor scooters] | ||
+ | [http://vvvvvv.blox.pl/resource/mini_harley_chopper_scooter.htm mini harley chopper scooter] | ||
+ | [http://blog.moddingplanet.it/?w=fakerolex fake rolex] | ||
+ | |||
+ | [http://blog.moddingplanet.it/?w=bextravioxx bextra vioxx] | ||
+ | [http://blog.moddingplanet.it/?w=zocor zocor] | ||
+ | [http://blog.moddingplanet.it/?w=zithromax zithromax] | ||
+ | [http://blog.moddingplanet.it/?w=bextralawyernew bextra lawyer new hampshire] | ||
+ | [http://blog.moddingplanet.it/?w=akanesoma akane soma] | ||
+ | [http://blog.moddingplanet.it/?w=kyosoma kyo soma] | ||
+ | [http://blog.moddingplanet.it/?w=prozacnation prozac nation] | ||
+ | [http://blog.moddingplanet.it/?w=prozacwithdrawal prozac withdrawal] | ||
+ | [http://blog.moddingplanet.it/?w=simslots sim slots] | ||
+ | [http://blog.moddingplanet.it/?w=pachisloslotmachine pachislo slot machines] | ||
+ | [http://blog.moddingplanet.it/?w=programcherries program cherries wild slot machine] | ||
+ | [http://blog.moddingplanet.it/?w=slotcarracing slot car racing] | ||
+ | [http://blog.moddingplanet.it/?w=hoslotcars ho slot cars] | ||
+ | |||
+ | [http://blog.moddingplanet.it/?w=bingocages bingo cages] | ||
+ | [http://blog.moddingplanet.it/?w=bingodaubers bingo daubers] | ||
+ | [http://blog.moddingplanet.it/?w=bingoblowers bingo blowers] | ||
+ | [http://blog.moddingplanet.it/?w=bingobags bingo bags] | ||
+ | [http://blog.moddingplanet.it/?w=baccaratcrystal baccarat crystal] | ||
+ | [http://blog.moddingplanet.it/?w=nexium nexium] | ||
+ | [http://blog.moddingplanet.it/?w=onlinepaigowpoker online pai gow poker] | ||
+ | [http://blog.moddingplanet.it/?w=leighkeno leigh keno] | ||
+ | |||
+ | [http://www.privetparis.com/blog/tramadol50mg/ tramadol 50mg] | ||
+ | [http://www.privetparis.com/blog/tramadolsaturdaydelivery/ tramadol saturday delivery] | ||
+ | [http://www.privetparis.com/blog/tramadoler/ tramadol er] | ||
+ | [http://www.privetparis.com/blog/tramadolsales/ tramadol sales] | ||
+ | [http://www.privetparis.com/blog/tramadolhcl50mg/ tramadol hcl 50 mg] | ||
+ | [http://www.privetparis.com/blog/120tramadoll/ 120 tramadol] | ||
+ | [http://www.privetparis.com/blog/acetaminophenhclpartramadol/ acetaminophen hcl par tramadol] | ||
+ | [http://blog.moddingplanet.it/?w=plussizemother plus size mother of the bride dresses] | ||
+ | [http://blog.moddingplanet.it/?w=cheapflowergirl cheap flower girl dresses] | ||
+ | [http://blog.moddingplanet.it/?w=discountflowergirl discount flower girl dresses] | ||
+ | [http://blog.moddingplanet.it/?w=infantflowergirl infant flower girl dresses] | ||
+ | [http://blog.moddingplanet.it/?w=bridalflowergirl bridal flower girl dresses] | ||
</div> | </div> |
Revision as of 07:15, 28 May 2006
When you want to export a database with bcp, you need to check if there is any text or image data (blobs) in the database, check the maximum size of these blobs and use this to specify the value for the -T argument in bcp command. Here are some usefull queries.
To determine the tables and columns in the database that use text/image data:
select user_name(o.uid) as "owner", o.name as "table", c.name as "column" from sysobjects o, syscolumns c where o.type = "U" and o.id = c.id and c.type in (34,35) order by 1,2,3
Once you know which columns are used to store blobs, run the following query to select the maximum length of a blob in bytes:
select max(datalength(<column_name>)) from <table_name>
Here is a stored procedure to check a database. You need to use ASE 12.0 or later for this.
create proc sp_blobsize as set nocount on declare myCursor cursor for select user_name(o.uid),o.name,c.name from sysobjects o,syscolumns c where o.type = "U" and o.id = c.id and c.type in (34,35) order by 1,2,3 declare @user varchar(30),@table varchar(30),@column varchar(30),@cmd varchar(512),@first tinyint,@db varchar(30) select @first = 0,@db = db_name() print "This utility looks for text and image data in tables and" print "calculates the maximum size in bytes." print "Checking database %1!",@db print "" open myCursor if @@error != 0 return 1 fetch myCursor into @user, @table, @column while @@sqlstatus = 0 begin if @first = 0 begin print "Output is shown in the format owner.table.column - maximum size" print "" select @first = 1 end select @cmd = "declare @l int select @l=max(datalength(" + rtrim(@column) + ")) from " + rtrim(@user) + "." + rtrim(@table) + " print '%1!.%2!.%3! - %4!','" + @user + "','" + @table + "','" + @column + "',@l" exec (@cmd) if @@error != 0 break fetch myCursor into @user, @table, @column end close myCursor deallocate cursor myCursor if @first = 0 print "No text/image data found in this database." return 0 go