hi,
1) use a tool such as squirrel SQL and create a data script of the old
table. execute it by replacing the table name.
2)
don't know how to handle it with the date field. but if you use a timestamp
field instead of a date field you could do something like that:
INSERT INTO tablename (id,key,title,category,year) VALUES (0, 0,
'movietitle', 'moviecategory', PARSEDATETIME('2012','yyyy', 'en', 'GMT'));
look at the parsedatetime function for more information:
http://www.h2database.com/html/functions.html#parsedatetime
On Tue, Jun 12, 2012 at 4:39 PM, vicenrico <[email protected]> wrote:
> Hello!.
> I'm a software developer who has a program to catalog movies.
> I have two questions that I would like you to ask me, please.
> My program is currently version 1.0.
> I have a table, for example:
>
> Table (long id, long key, String title, String category, Date year )
>
> I would like to import data from older versions, as could be, for instance:
>
> TableOld ((long id, long key, String title, String year)
>
> Of course, my tables have a lot of columns, but I think with these you can
> undertand what my problem is.
>
> My questions:
>
> I want to import old data (tableold) to my current database which is
> already open (with ist own tables already created).
>
> 1) What is the best way to import data from tableold( a *data.db file in
> my computer) to Table (that is currently opened). Should I use merge, or
> create linked tables?
> 2) In the "year" case, in my old db was a String , but I want to convert
> to Date when doing the import. Is there a good way to convert "on the fly",
> I mean, while importing?
>
> Thanks
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/h2-database/-/4YIJwRCXW74J.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
