Replicating database via ODBC

[dbeck]

We need to move a database from one ISP to another. The current ISP has given
us terminal access to the web server but not to the database server. We have
access to load cold fusion templates on the web server. Does anyone know of a
way, via queries in cold fusion, to list off the database schema and then copy
the data to another database server? We can define a cold fusion datasource to
the new target database server. So there should be a way to copy the data
over. Anyone know of some sample code or tags I could use? Other suggestions?
Just looking for some help and ideas here.

[kim il sung]

your database is what? ms sql server? access?
do you have admin rights (to read schema)?
kim

[kim il sung]

several options to copy data to different server
[url]http://databasejournal.com/features/mssql/article.php/1439831[/url]

kim