Hi,
While migrating data from postgresql to ms-sql-server I am getting
following error:
* EXCEPTION: could not make a copy of the database ('42000', "[42000]
[Microsoft][ODBC SQL Server Driver][SQL Server]Foreign key
'admission_clinic__constraint' references invalid table 'clinic'.") *
It is obvious that before referring to table '*clinic*' we need to first
create it. In our db.py, the order is correct and '*clinic*' table
definition is prior to the '*admission*' table but *cpdb* is attempting to
first create 'admission' table and hence failing.
Any suggestions how it can be fixed? How can we force *cpdb* to use the
same order of tables definition as defined in *db.py*?
Thanks & Regards,
AT
PS. I am using -f, -F, -y, -Y & -d switches with cpdb.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
