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

export blob to sql server 2005

  
   Database Help (Home) -> Paradox RSS
Next:  PHP Dataobject join question  
Author Message
theMuffinMan

External


Since: Nov 24, 2008
Posts: 2



(Msg. 1) Posted: Mon Nov 24, 2008 4:01 am
Post subject: export blob to sql server 2005
Archived from groups: comp>databases>paradox (more info?)
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

 >> Stay informed about: export blob to sql server 2005 
Back to top
Login to vote
theMuffinMan

External


Since: Nov 24, 2008
Posts: 2



(Msg. 2) Posted: Mon Nov 24, 2008 8:05 am
Post subject: Re: export blob to sql server 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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

 >> Stay informed about: export blob to sql server 2005 
Back to top
Login to vote
Anders

External


Since: Oct 15, 2008
Posts: 7



(Msg. 3) Posted: Mon Nov 24, 2008 9:26 am
Post subject: Re: export blob to sql server 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
> 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
 >> Stay informed about: export blob to sql server 2005 
Back to top
Login to vote
Anders

External


Since: Oct 15, 2008
Posts: 7



(Msg. 4) Posted: Tue Nov 25, 2008 7:25 am
Post subject: Re: export blob to sql server 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
> 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?


It's done from Paradox and it's a fairly simple process.

You define an alias pointing to the SQL server and the use a simple copy
table command from Paradox to the SQL server.

If I understand correctly you are located in Sweden. If you need help with
migrating data, you can contact me at: www.jonssondata.se



Mvh
Anders
 >> Stay informed about: export blob to sql server 2005 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
I can't to open table(s) on InterBase's server - I have a computer with OS WindowsXP Professional version 2002 with SP2 and I have next problem with Paradox 10 v.11.0.0.302. I can't to open a table(s) on InterBase's server, but I can to open a local table(s). Dialog window of Database Login for..

write to paradox via web - I have a client that uses software developed in delphi. It uses paradox database files. Can these be written to from the web? I am familiar with php/mysql...is there a similar capability with delphi/paradox?

which program? - Hi to all, I'm sorry 'cause I'm not sure this is the correct ng...so my apologies in advance if I'm in the wrong place. My customer show me a floppy disk with old files (about 1998-1999) and told me that there are her accounting data to back life. With...

forcing lck files location - Is there method to force lck files location. I create query on fly with Delphi but there is a problem with lock files. It tries to create it to system32 folder but because user does not have rights to that folder , creating query fails. So, how can I..

Network performance and hardware issues - Hi! Our clients have run our Paradox based apps in small network configurations with only about 10-15 runtime clients at max. Recently we have had inquiries from a bigger company that wants to run our app in an network of over 100 clients, is this..
   Database Help (Home) -> Paradox 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 ]