The Instructure Community will enter a read-only state on November 22, 2025 as we prepare to migrate to our new Community platform in early December. Read our blog post for more info about this change.
Hello,
With the deployment of the 1.3.0 client, I've decided to TRY and migrate from Postgres into my native SQL Server environment.
I have successfully initialized ~88 tables, but I know that's not enough. I'm seeing an issue within the Assignments table that probably exists in other tables.
The script that's creating the Assignments table isn't creating the column "submission_types" and manually adding the column doesn't have any effect.
I have reviewed the CREATE TABLE script generated by the client and that column definitely isn't there. The reference table is being created, but the constraint is not.
Has anyone else successfully deployed this into SQL Server? Has anyone else found similar issues?
I do have a ticket into Support on this.
Thanks,
Jim Sorenson
Community helpTo interact with Panda Bot, our automated chatbot, you need to sign up or log in:
Sign inTo interact with Panda Bot, our automated chatbot, you need to sign up or log in:
Sign in