there's nothing built-in to SA to do this but it's certainly possible
to write something at the SQL layer. since sqlite doesn't really
support doing anything tricky, all you should have to do is
for each table
autoload table from sqlite
dup table in postgresql metadata, create()
for each row in select *
insert
then add to http://www.sqlalchemy.org/trac/wiki/UsageRecipes when you're done :)
On 3/5/07, Adam Peacock <[EMAIL PROTECTED]> wrote:
>
> Is there a tool for SA to copy from one database to another? I'm
> looking for a simple way to propogate my testing database (sqlite)
> from my production database (postgres), so that I can play with actual
> data during testing without worrying about what I'm going to mess up.
> Is there an automated way to do this?
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
