When I try to migrate sqlite to mssql and execute the command
python web2py.py -S ITAsset -M -P
(ITAsset is the name of application)
I see this error
ProgrammingError: ('42000', u"[42000] [Microsoft][ODBC SQL Server
Driver][SQL Server]Introducing FOREIGN KEY constraint
'auth_user_created_by__constraint' on table 'auth_user' may cause cycles or
multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION,
or modify other FOREIGN KEY constraints. (1785) (SQLExecDirectW); [42000]
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint
or index. See previous errors. (1750)")
auth_user is the standard web2py table. So What can I do to permit to this
command to create all the tables?
Thank you
--
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/e8df773b-de4e-4996-96e0-40bce2c7aa44o%40googlegroups.com.
