TPS to SQL

stephen

unread,

Feb 20, 2003, 4:11:08 PM2/20/03

to

I have an app where I have been prototyping the look and feel of where the
app is to go. To date I have only used the TPS file type.

So I have a number of TPS files with data in that I would like to convert to
SQL.

How can I achieve this without corrupting the data and without having to go
to a SQL tool to redefine the tables and fields.

Yes, a newbies question.

Thanks
--
Stephen Dixon
S & W Consultants Ltd
Tauranga, NZ

Rocky Phelps

unread,

Feb 20, 2003, 4:27:54 PM2/20/03

to

Steve,

If you don't object to spending a few dollars, and would like to own probably the best-selling and most-used third-party
product, look at FM3 (FileManager 3) at www.capesoft.com. It will handle the TPS > SQL conversion (and LOTS more) for you
effortlessly.

Rocky

(Sorry, Dennis. If you have a better idea, let's hear it.)

"stephen" <ste...@swc.net.nz> wrote in message news:3e55...@news.softvelocity.com...

James Cooke

unread,

Feb 20, 2003, 4:51:39 PM2/20/03

to

This is a large step.
Define the tables by creating a script of the database using datamodeller
(no relations).
Then MSSQL's enterprise manager and use DTS (desktop services) to pump the
data from an ODBC/TPS datasource into your database.
I have done this before and after some practice you will find it is pretty
quick.
Next time develop directly on MSSQL. Easier, cleaner.
James

"stephen" <ste...@swc.net.nz> wrote in message
news:3e55...@news.softvelocity.com...

Geoff Bomford

unread,

Feb 20, 2003, 5:47:13 PM2/20/03

to

Apart from Rocky's suggestion, which I would also recommend for a first time
conversion or where you have to manage updates to an SQL database remotely,
there are some templates available at my website which explain the process
and might help. Plus there are some excellent articles on Clarion and SQL
at www.icetips.com and various other sites which you can probably find most
readily at www.tomruby.com.

Geoff Bomford
www.comformark.com.au
Computer services For Marketing

"stephen" <ste...@swc.net.nz> wrote in message
news:3e55...@news.softvelocity.com...

James Cooke

unread,

Feb 21, 2003, 12:16:49 AM2/21/03

to

also check out clarionfoundry.com

"James Cooke" <jamescooke_...@yahoo.com> wrote in message

Lesley Dean

unread,

Feb 21, 2003, 3:35:11 AM2/21/03

to

Hi Steven,

Yeah, as Rocky mentioned, File Manager 3 converts TPS to SQL effortlessly.
Aswell as creating the sql tables, and copying over your data, FM3 will then
continue to manage any file structure upgrades and management for you.
Currently only MSSQL, ORACLE, and MySQL are supported by FM3. This is a
growing list though. For more information:
http://www.capesoft.com/accessories/fm3sp.htm.

As James and Geoff also mentioned, there are some very good resources for
Clarion/SQL programming. You find that there are a few things to take into
consideration for optimum SQL performance. There are also File structure
differences to take into consideration, but most of these are handled for
you by FM3 and our Bulk Dictionary Editor.

Hope this helps. Please don't hesitate to ask any further questions.
--
--------------------------
Lesley Dean
CapeSoft
www.capesoft.com

"stephen" <ste...@swc.net.nz> wrote in message
news:3e55...@news.softvelocity.com...

Robert Johnson

unread,

Feb 21, 2003, 10:57:31 AM2/21/03

to

Look for a tool called Dct2Ssl. This is a great utility that will produce
scripts for most DB's from your Clarion Dictionary. Run the script and you
will have your SQL tables. Best of all, it's free.

Robert

"stephen" <ste...@swc.net.nz> wrote in message
news:3e55...@news.softvelocity.com...