Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Data Import from Foxpro Dos Base Ver.to SQL Server

Author  Topic 

Aamir
Starting Member

14 Posts

Posted - 2004-07-01 : 03:19:49

I have to make a trasformation from Foxpro to SQL Server in the current project i am working on. The version of foxpro is dos based. How and where should i start to perform this task. As i am new in the field of software developement. i will be highly appreciated for a quick response.
References and help materials will be appreciated...
Thnx

SoftGuru

JasonGoff
Posting Yak Master

158 Posts

Posted - 2004-07-01 : 06:41:02
Foxpro from memory (ANCIENT memory :-) ) has DB3 format files. Check out DTS - Data Transformation Services. You should be able to do everything you need using that.
Go to Top of Page

Aamir
Starting Member

14 Posts

Posted - 2004-07-01 : 07:07:41
Thanks,
I have read teh DTS section. It says for creating package kind of thing. I can't understand it. As i have to do this transfer of data from vb interface... an automated process..

so what is ur opinion.

SoftGuru
Go to Top of Page

JasonGoff
Posting Yak Master

158 Posts

Posted - 2004-07-01 : 07:30:19
You can automate DTS from within VB using SQLs Distributed Management Objects (DMO). I really recommend you try to get to grips with DTS as it's an ideal tool for moving data into and out of SQL Server databases into other formats.
Check out http://www.sqldts.com/default.aspx?258 for information on DTS.

DTS Tutorials..
http://www.devguru.com/features/tutorials/DTS/DTS1.html
http://www.sqldts.com/default.aspx?278
Go to Top of Page

Aamir
Starting Member

14 Posts

Posted - 2004-07-02 : 01:16:48
Thanks Jason,
I will look to it. Lets see .... By the way thanks for assistance


SoftGuru
Go to Top of Page
   

- Advertisement -