Re: What is sqldb.map?

[Thomas Fischer <tf...@apache.org>]

On Sat, 29 Apr 2006, Yang Sun wrote:

> Hi,
>
> I am a new user for Torque. It is really a great tool.
>
> Now, my task is to transfer a database on postgresql to mysql. And my plan
> is to:
> 1) dump the database structure with "ant jdbc" task.
> 2) dump the datadtd with "ant datadtd" task.
> 3) dump the data in the database with "ant dumpdata" task.
> 4) create the sql ddl for mysql database with "ant create-db" task.
> 5) create the sql file for inserting the existing data with "ant datasql"
> task.
>

"ant create-db" is the wrong task for 4). Use "ant sql" instead.

> It works well for the first 3 tasks. But for step 4 and step 5. I met
> problems.
>
> For step 4, it creates a sql file called create-db.sql. But it only contains
> two statements.
> /-----------------------------------------
> drop database if exists postgres;
> create database postgres;
> ------------------------------------------/
> I have not naming the new database postgres. I do not know where the
> database name "postgres" comes out. Could you give me some information on
> this issue?
>

it probably comes either from your schema.xml file (attribute "name" of 
element "database"), or (less likely) from your build.properties file.

> The other issue is for step 5. When I run "ant create-db", it always
> complain that the application cannot find the "sqldb.map". Could you tell me
> what the usage of that file and how to create it?
>

It is a map filename -> database name. If you run "ant sql" it is 
automatically created for the generated sql files. I thought it would be 
the same for "ant datasql", but I have no experience there. Maybe you can 
generate the file manually and give its location to the ant task (read 
the build-torque file on how to do that).

    Thomas

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org