Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Clarion 5 - Converting TPS to SQL Server

Clarion 5 - Converting TPS to SQL Server

Clarion 5 - Converting TPS to SQL Server

I have numerous TPS files that I want to convert to Tables in a SQL Server 2008 Database. We have Clarion 5.0, and after much seaching, I was able to find and download TopScan v5.5 which has the Export option. I am able to create TXT files and manually Import them into SQL. However, the Table is automatically created with a generic Text format for each field.

So, I then found Data Management Center 3.01 (DMC) which looked promising. It's not the most user-friendly applcation, but after a while I was able to set up my SQL connection (after having to download the "SQL Server Native Client 10.0" and use it's "Clone Structure" feature where it reads the TPS file, determines field data types, creates the SQL Table and uploads the data (20 record limit with demo).

DMC also has a "Port to SQL" feature that really looks good. But I'm stuck on the first step. With Clarion 5.0, we have a DCT Dictionary file but the process wants a DCTX format. I used Clarion and figured out how to export the Dictionary to a TXD file but it didn't like it.

The on-screen help mentions "DMC does not work directly with your DCT or APP files. You must first use Clarion to Export these to DCTX and TXA files. When done, you'll use the new DCTX and TXA files created by DMC to Import into the new DCT and APP files.". Is there any way I can convert our DCT to a DCTX?

Understand that the intention is NOT to convert the apps from TPS to SQL. I only want it to automatically create each Table, Index, Relations and upload the data. I hope this makes sense. I'm certainly no Clarion expert!

RE: Clarion 5 - Converting TPS to SQL Server

Hey, there are utility templates you could try using to export the file structures from tps to Sql

hope this helps

RE: Clarion 5 - Converting TPS to SQL Server

Thanks, TuzMwaura, but I don't see anything on that web site. It doesn't look it has much content?

RE: Clarion 5 - Converting TPS to SQL Server


Have looked at this page on that site http://www.comformark.com.au/what-we-do/clarion-te...

There are various SQL utility templates that will help you.

There is also another free template set to convert your dct2sql from Roberto Artigas, you will find these and other utilities here

Hoe this helps

Ed Hannan

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close