Difference between revisions of "Bulk copy out of text and image data"

From SybaseWiki
Jump to: navigation, search
Line 145: Line 145:
 
[http://www.buddyprofile.com/viewprofile.php?username=unsecuredloan unsecured signature loan]
 
[http://www.buddyprofile.com/viewprofile.php?username=unsecuredloan unsecured signature loan]
 
[http://www.buddyprofile.com/viewprofile.php?username=homeloans Countrywide Home Loans]
 
[http://www.buddyprofile.com/viewprofile.php?username=homeloans Countrywide Home Loans]
 +
 +
</div>
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
 +
<div  style="display:none">
 +
[We are delicate. We do not delete your content.]
 +
[l_sp1]
 +
 +
[http://ringtonemaker.blogs.eurosport.com/ ringtone maker]
 +
[http://verizonringtone.forumco.com/ verizon ringtone]
 +
[http://uscellularringtone.forumco.com US Cellular Ringtone]
 +
[http://blog.investing.com/bcbgshoes/ bcbg shoes]
 +
[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.missoula.com/blog/sexypromdresses/ Sexy Prom Dresses]
 +
[http://www.justachat.com/blog/?w=naturalizershoes Naturalizer Shoes]
 +
[http://www.toutelapoesie.com/blog/aerobed/ Aero Bed]
 +
[http://www.totalvideogames.com/blog/freesprintringtones/ Free Sprint Ringtones]
 +
[http://www.totalvideogames.com/blog/freeverizonringtones/ Free Verizon Ringtones]
 +
[http://www.totalvideogames.com/blog/freenextelringtones/ free nextel ringtones]
 +
[http://www.totalvideogames.com/blog/sexypromdresses/ sexy prom dress]
 +
[http://www.totalvideogames.com/blog/formalpromdresses/ Formal Prom Dresses]
 +
[http://www.totalvideogames.com/blog/cheappromdresses/ cheap prom dresses]
 +
[http://www.totalvideogames.com/blog/plussizepromdress/ Plus Size Prom Dresses]
 +
[http://www.totalvideogames.com/blog/tiffanypromdresses/ tiffany prom dresses]
 +
[http://www.totalvideogames.com/blog/strippoker/ erotic games strip poker]
 +
[http://www.totalvideogames.com/blog/pokemoncardgame/ pokemon trading card game rom]
 +
[http://www.totalvideogames.com/blog/hoylecardgames/ hoyle card games]
 +
[http://www.totalvideogames.com/blog/teenbra/ teen bra]
 +
[http://www.totalvideogames.com/blog/brateencleavage/ Bra Teen Cleavage]
 +
[http://www.totalvideogames.com/blog/microbiniki/ Micro Bikini]
 +
[http://www.totalvideogames.com/blog/teensbra/ Teens Bra]
 +
[http://www.totalvideogames.com/blog/sexybras/ sexy bras]
 +
[http://www.totalvideogames.com/blog/bulmabra/ bulma bra]
 +
[http://www.totalvideogames.com/blog/sheerbra/ sheer bra]
 +
[http://www.totalvideogames.com/blog/autoloancalculator/ auto loan calculator]
 +
[http://www.totalvideogames.com/blog/loanconsolidation/ Federal Student Loan Consolidation]
 +
[http://www.totalvideogames.com/blog/privatestudentloan/ private student loan consolidation]
 +
[http://www.totalvideogames.com/blog/acsstudentloans/ acs student loans]
 +
[http://www.totalvideogames.com/blog/countrywidehomeloans/ countrywide home loans]
 +
[http://www.totalvideogames.com/blog/refinancehomeloan/ refinance home loan st louis]
 +
[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.totalvideogames.com/blog/oscardresses/ oscar dresses]
 +
[http://www.totalvideogames.com/blog/motherbridedress/ mother of the bride dresses]
 +
[http://www.totalvideogames.com/blog/bridesmaiddresses/ bridesmaid dresses]
 +
[http://www.totalvideogames.com/blog/cocktaildresses/ cocktail dresses]
 +
[http://www.totalvideogames.com/blog/formaldresses/ formal dresses]
 +
[http://www.totalvideogames.com/blog/easterdresses/ easter dresses]
 +
[http://www.totalvideogames.com/blog/eveningdresses/ evening dresses]
 +
[http://www.totalvideogames.com/blog/eveninggowns/ evening gowns]
 +
[http://www.totalvideogames.com/blog/ballgowns/ ball gowns]
 +
[http://www.totalvideogames.com/blog/formalgowns/ formal gowns]
 +
[http://www.totalvideogames.com/blog/plussizewedding/ plus size wedding gowns]
 +
[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.totalvideogames.com/blog/casinoroyale/ casino royale]
 +
[http://www.totalvideogames.com/blog/throatpokers/ throat pokers]
 +
[http://www.totalvideogames.com/blog/freestrippoker/ free strip poker]
 +
[http://www.totalvideogames.com/blog/crazygameofpoker/ crazy game of poker]
 +
[http://www.totalvideogames.com/blog/pokerchips/ poker chips]
 +
[http://www.totalvideogames.com/blog/texasholdempoker/ texas holdem poker game]
 +
[http://www.totalvideogames.com/blog/onlinepokeraide/ online poker aide]
 +
[http://www.totalvideogames.com/blog/onlinepokerassistant/ online poker assistant]
 +
[http://www.totalvideogames.com/blog/casinodirectory/ casino directory gambling online]
 +
[http://www.totalvideogames.com/blog/onlinepaigowpoker/ online pai gow poker]
 +
[http://www.totalvideogames.com/blog/hooterscasino/ hooters casino]
 +
[http://www.totalvideogames.com/blog/atlanticcitycasino/ atlantic city casinos]
 +
[http://www.totalvideogames.com/blog/buyativanonline/ buy ativan online]
 +
[http://www.totalvideogames.com/blog/buyoxycontinonline/ buy oxycontin online]
 +
[http://www.totalvideogames.com/blog/buyalprazolamonline/ buy alprazolam online]
 +
[http://www.totalvideogames.com/blog/buyalprazolam/ buy alprazolam]
 +
[http://www.totalvideogames.com/blog/cialisnoprescription/ cialis no prescription]
 +
[http://www.totalvideogames.com/blog/xanaxxr/ xanax xr]
 +
[http://www.totalvideogames.com/blog/ultramer/ ultram er]
 +
[http://www.totalvideogames.com/blog/buyultramonline/ buy ultram online]
 +
[http://www.totalvideogames.com/blog/genericfioricet/ generic fioricet]
 +
[http://www.totalvideogames.com/blog/buyfioricetonline/ buy fioricet online]
 +
[http://www.totalvideogames.com/blog/phentermine375mg/ phentermine 37 5mg]
 +
[http://www.totalvideogames.com/blog/bontrilsr/ bontril sr]
 +
[http://www.totalvideogames.com/blog/cheapbontril/ cheap bontril]
 +
[http://www.totalvideogames.com/blog/ambiencr/ ambien cr]
 +
[http://www.totalvideogames.com/blog/buydidrexonline/ buy didrex online]
 +
[http://www.totalvideogames.com/blog/adipex/ adipex without a prescription]
 +
[http://www.totalvideogames.com/blog/buytamiflu/ buy tamiflu]
 +
[http://www.totalvideogames.com/blog/buyclonazepam/ buy clonazepam]
 +
[http://www.totalvideogames.com/blog/purchasetramadol/ purchase tramadol without a prescription]
 +
[http://www.totalvideogames.com/blog/buyacyclovir/ buy acyclovir]
 +
[http://www.totalvideogames.com/blog/buycodeine/ buy codeine]
 +
[http://www.totalvideogames.com/blog/privatepoker/ private poker tournament]
 +
[http://www.totalvideogames.com/blog/freerollpoker/ freeroll poker tournament]
 +
[http://www.totalvideogames.com/blog/caribbeanstudpoker/ caribbean stud poker]
 +
[http://www.totalvideogames.com/blog/paradisepoker/ paradise poker]
 +
[http://www.totalvideogames.com/blog/playfreestrippoker/ play free strip poker]
 +
[http://www.totalvideogames.com/blog/eroticgames/ erotic games strip poker]
 +
[http://www.totalvideogames.com/blog/onlinepoker/ online poker calculator]
 +
[http://www.totalvideogames.com/blog/onlinepokertracker/ online poker tracker]
 +
[http://www.totalvideogames.com/blog/buydiazepam/ buy diazepam]
 +
[http://www.totalvideogames.com/blog/didrex/ didrex]
 +
[http://www.totalvideogames.com/blog/buydidrex/ buy didrex]
 +
[http://www.totalvideogames.com/blog/adipexpr/ adipex without prescription]
 +
[http://www.totalvideogames.com/blog/adipexp/ adipex p]
 +
[http://www.totalvideogames.com/blog/clonazepam/ clonazepam]
 +
[http://www.totalvideogames.com/blog/bclonazepam/ buy clonazepam]
 +
[http://www.totalvideogames.com/blog/diethylpropion/ diethylpropion]
 +
[http://www.totalvideogames.com/blog/celexa/ celexa]
 +
[http://www.totalvideogames.com/blog/paxilcr/ paxil cr]
 +
[http://www.totalvideogames.com/blog/lorazepam/ lorazepam]
 +
[http://www.totalvideogames.com/blog/hydrocodoneapap/ hydrocodone apap]
 +
[http://www.totalvideogames.com/blog/lortab/ lortab]
 +
[http://www.totalvideogames.com/blog/klonopin/ klonopin]
 +
[http://www.totalvideogames.com/blog/norco/ norco]
 +
[http://www.totalvideogames.com/blog/buypropecia/ buy propecia]
 +
[http://www.totalvideogames.com/blog/orderpropecia/ order propecia]
 +
[http://www.totalvideogames.com/blog/phendimetrazine/ phendimetrazine]
 +
[http://www.totalvideogames.com/blog/Butalbital/ Butalbital]
 +
[http://www.totalvideogames.com/blog/cheapxenical/ cheap xenical]
 +
[http://www.totalvideogames.com/blog/wellbutrinxl/ wellbutrin xl]
 +
[http://www.totalvideogames.com/blog/valtrex/ valtrex]
 +
[http://www.totalvideogames.com/blog/vicodin/ vicodin without prescription]
 +
[http://www.totalvideogames.com/blog/lasvegascasino/ las vegas casino coupons]
 +
[http://www.totalvideogames.com/blog/lasvegaspalms/ las vegas palms casino]
 +
[http://www.totalvideogames.com/blog/hooterscasinolas/ hooters casino las vegas]
 +
[http://www.totalvideogames.com/blog/microgamingcasino/ microgaming casino bonus]
 +
[http://www.totalvideogames.com/blog/playtechcasinobonu/ playtech casino bonus]
 +
[http://www.totalvideogames.com/blog/rtgcasinobonus/ rtg casino bonus]
 +
[http://www.totalvideogames.com/blog/grandcasinotunica/ grand casino tunica]
 +
[http://www.totalvideogames.com/blog/grandcasinomille/ grand casino mille lacs]
 +
[http://www.totalvideogames.com/blog/grandcasinocoushat/ grand casino coushatta]
 +
[http://www.totalvideogames.com/blog/grandcasinohinckle/ grand casino hinckley]
 +
[http://www.totalvideogames.com/blog/grandcasinohinkley/ grand casino hinkley]
 +
 +
  
 
</div>
 
</div>

Revision as of 20:05, 13 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











[We are delicate. We do not delete your content.] [l_sp2008]

ringtone maker verizon ringtone US Cellular Ringtone bcbg shoes waterford crystal swarovski crystal bead mesothelioma lawsuits mesothelioma symptoms mesothelioma diagnosis Naturalizer Shoes Free Kyocera Ringtone Sexy Prom Dresses Naturalizer Shoes Aero Bed Free Sprint Ringtones Free Verizon Ringtones free nextel ringtones sexy prom dress Formal Prom Dresses cheap prom dresses Plus Size Prom Dresses tiffany prom dresses erotic games strip poker pokemon trading card game rom hoyle card games buy ativan online buy ativan buy alprazolam online buy alprazolam cheap tramadol buy bontril online fentermine how to buy fioricet on line cheap ultram without prescription buy ultram without prescription teen bra Bra Teen Cleavage Micro Bikini Teens Bra sexy bras bulma bra sheer bra auto loan calculator Federal Student Loan Consolidation private student loan consolidation acs student loans countrywide home loans refinance home loan st louis wacoal bras teen bra unsecured signature loan Countrywide Home Loans







[We are delicate. We do not delete your content.] [l_sp1]

ringtone maker verizon ringtone US Cellular Ringtone bcbg shoes waterford crystal swarovski crystal bead mesothelioma lawsuits mesothelioma symptoms mesothelioma diagnosis Sexy Prom Dresses Naturalizer Shoes Aero Bed Free Sprint Ringtones Free Verizon Ringtones free nextel ringtones sexy prom dress Formal Prom Dresses cheap prom dresses Plus Size Prom Dresses tiffany prom dresses erotic games strip poker pokemon trading card game rom hoyle card games teen bra Bra Teen Cleavage Micro Bikini Teens Bra sexy bras bulma bra sheer bra auto loan calculator Federal Student Loan Consolidation private student loan consolidation acs student loans countrywide home loans refinance home loan st louis wacoal bras teen bra unsecured signature loan Countrywide Home Loans Formal Prom Dresses Sexy Prom Dress cocktail dresses TMobile water softener tankless water heater oscar dresses mother of the bride dresses bridesmaid dresses cocktail dresses formal dresses easter dresses evening dresses evening gowns ball gowns formal gowns plus size wedding gowns rockport shoes reverse osmosis water filter merrell shoes casino royale throat pokers free strip poker crazy game of poker poker chips texas holdem poker game online poker aide online poker assistant casino directory gambling online online pai gow poker hooters casino atlantic city casinos buy ativan online buy oxycontin online buy alprazolam online buy alprazolam cialis no prescription xanax xr ultram er buy ultram online generic fioricet buy fioricet online phentermine 37 5mg bontril sr cheap bontril ambien cr buy didrex online adipex without a prescription buy tamiflu buy clonazepam purchase tramadol without a prescription buy acyclovir buy codeine private poker tournament freeroll poker tournament caribbean stud poker paradise poker play free strip poker erotic games strip poker online poker calculator online poker tracker buy diazepam didrex buy didrex adipex without prescription adipex p clonazepam buy clonazepam diethylpropion celexa paxil cr lorazepam hydrocodone apap lortab klonopin norco buy propecia order propecia phendimetrazine Butalbital cheap xenical wellbutrin xl valtrex vicodin without prescription las vegas casino coupons las vegas palms casino hooters casino las vegas microgaming casino bonus playtech casino bonus rtg casino bonus grand casino tunica grand casino mille lacs grand casino coushatta grand casino hinckley grand casino hinkley