dbTalk Databases Forums  

export blob to sql server 2005

comp.databases.paradox comp.databases.paradox


Discuss export blob to sql server 2005 in the comp.databases.paradox forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
theMuffinMan
 
Posts: n/a

Default export blob to sql server 2005 - 11-24-2008 , 06:01 AM






Hi!
I want to export/convert at Paradox 9 database to SQL Server 2005.
Some tables in the paradox database has blob fields. I noticed that
there is a "per table" export data function. You can export to txt,
Excel, dBase etc.. I want to export to text files, but using text
files I can't export the blobs (am I right?).. Does anyone know some
other technique in which you can keep the blob data?

thanks!
Johan Edlund, Sweden

Reply With Quote
  #2  
Old   
Anders
 
Posts: n/a

Default Re: export blob to sql server 2005 - 11-24-2008 , 08:18 AM






Quote:
Does anyone know some
other technique in which you can keep the blob data?

If this is a one time operation you could could try a table copy from
Paradox to the SQL server. It might give you a start to work with.

Another approach is to use a tCursor to upload the data.

If the blob-fields are bigger than 1 mb you could run into problems.


Med vänliga hälsningar

Anders Jonsson




Reply With Quote
  #3  
Old   
Anders
 
Posts: n/a

Default Re: export blob to sql server 2005 - 11-24-2008 , 08:18 AM



Quote:
Does anyone know some
other technique in which you can keep the blob data?

If this is a one time operation you could could try a table copy from
Paradox to the SQL server. It might give you a start to work with.

Another approach is to use a tCursor to upload the data.

If the blob-fields are bigger than 1 mb you could run into problems.


Med vänliga hälsningar

Anders Jonsson




Reply With Quote
  #4  
Old   
Anders
 
Posts: n/a

Default Re: export blob to sql server 2005 - 11-24-2008 , 08:18 AM



Quote:
Does anyone know some
other technique in which you can keep the blob data?

If this is a one time operation you could could try a table copy from
Paradox to the SQL server. It might give you a start to work with.

Another approach is to use a tCursor to upload the data.

If the blob-fields are bigger than 1 mb you could run into problems.


Med vänliga hälsningar

Anders Jonsson




Reply With Quote
  #5  
Old   
Anders
 
Posts: n/a

Default Re: export blob to sql server 2005 - 11-24-2008 , 08:18 AM



Quote:
Does anyone know some
other technique in which you can keep the blob data?

If this is a one time operation you could could try a table copy from
Paradox to the SQL server. It might give you a start to work with.

Another approach is to use a tCursor to upload the data.

If the blob-fields are bigger than 1 mb you could run into problems.


Med vänliga hälsningar

Anders Jonsson




Reply With Quote
  #6  
Old   
Anders
 
Posts: n/a

Default Re: export blob to sql server 2005 - 11-24-2008 , 08:18 AM



Quote:
Does anyone know some
other technique in which you can keep the blob data?

If this is a one time operation you could could try a table copy from
Paradox to the SQL server. It might give you a start to work with.

Another approach is to use a tCursor to upload the data.

If the blob-fields are bigger than 1 mb you could run into problems.


Med vänliga hälsningar

Anders Jonsson




Reply With Quote
  #7  
Old   
Anders
 
Posts: n/a

Default Re: export blob to sql server 2005 - 11-24-2008 , 08:18 AM



Quote:
Does anyone know some
other technique in which you can keep the blob data?

If this is a one time operation you could could try a table copy from
Paradox to the SQL server. It might give you a start to work with.

Another approach is to use a tCursor to upload the data.

If the blob-fields are bigger than 1 mb you could run into problems.


Med vänliga hälsningar

Anders Jonsson




Reply With Quote
  #8  
Old   
Anders
 
Posts: n/a

Default Re: export blob to sql server 2005 - 11-24-2008 , 08:18 AM



Quote:
Does anyone know some
other technique in which you can keep the blob data?

If this is a one time operation you could could try a table copy from
Paradox to the SQL server. It might give you a start to work with.

Another approach is to use a tCursor to upload the data.

If the blob-fields are bigger than 1 mb you could run into problems.


Med vänliga hälsningar

Anders Jonsson




Reply With Quote
  #9  
Old   
theMuffinMan
 
Posts: n/a

Default Re: export blob to sql server 2005 - 11-24-2008 , 10:05 AM



Hi, thanks!
It's a one time operation. What does that mean a "table copy from
Paradox to the SQL Server"? Is that done from the Paradox program or
the SQL Server program?

/Johan

Reply With Quote
  #10  
Old   
theMuffinMan
 
Posts: n/a

Default Re: export blob to sql server 2005 - 11-24-2008 , 10:05 AM



Hi, thanks!
It's a one time operation. What does that mean a "table copy from
Paradox to the SQL Server"? Is that done from the Paradox program or
the SQL Server program?

/Johan

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.