Slightly OT: How much effort to convert database from TPS to MS SQL.

[Mike Grigsby]

I've got a web app (actually an entire company built around a web app) that is probably going to be acquired. It's a large, well known firm that's already having a little heartburn over it being written in Clarion to begin with, but I think I've got them okay about that.

I know the next issue is they will want to run this against MS SQL databases. Does anyone have any recommendations or experience in converting a database from TPS to MS SQL using FM3? This is a NetTalk Web Server app. I almost always use LONG's and STRINGS for all data. How much luck will I have in turning it over to MS SQL? Any advice ahead of time (besides making sure I've got a good backup!<G>)?

[Gregg Matteson]

Mike,

Have you used MSSQL with clarion at all?

I found this on the newsgroups and it works great.
http://www.dm8.fr/home_en.php Cost was like $ 106 US.
Try the demo , as I recall the demo is restricted to a small number of records. It made the process of converting very simple.

Regards,

Gregg Matteson

[Bruce]

Hi Mike,

In and of themselves Longs and Strings are no problem in MsSql.

However if another program (not clarion) was to want to share the data then tpically you can change the data type to something more "SQLy". For example changing Dates from LONG to DATE. Strings from String to Cstring (although this is less necessary). and so on.

And of course all this is pretty trivial with Fm3, and can be done down the road if you want to do it.

As far as converting from TPS to SQL - that's also trivial. Work through the docs, and maybe the example as well, and you'll find it's not as bad as it sounds.

Cheers
Bruce