> to MS SQL, (from old host to new host), especially when
> the old host doesn't provide any kind of web admin for the
> mysql!!!!
If you're using CFMX, you can get information about your tables
(names, columns, data types, etc.) from JDBC and then use that to
recreate the tables and automate inserts on the new server. The onTap
framework has some built-in database management features to get
metadata from databases which might be a decent starting point if you
don't want to hassle with learning how to work with JDBC in CF. The
onTap functions imho are a little more intuitive, since you can simply
specify
qColumns = request.tapi.db.columns(tablename)
and have a query containing all the column information for your table
instead of accessing JDBC directly (which is what these functions do),
getting a Java ResultSet and then having to manually convert that into
a query. All of which may be dozens to hundreds of lines of code.
The framework can be found at http://www.turnkey.to/ontap
s. isaac dealey 214.823.9345
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.sys-con.com/story/?storyid=44477&DE=1
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
