Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

  • Daniel Rogers 134 posts 712 karma points
    Jul 04, 2020 @ 00:20
    Daniel Rogers

    Umbraco 8 adding a database table

    I have a new project where I have created some custom tables using a migration plan. This is all working fine on my local machine but when I exported it to a live system instead of using the dbo schema all the other tables have used it put it in a schema named as the login name.

  • iNETZO 133 posts 496 karma points c-trib
    Jul 04, 2020 @ 18:49

    Hi Daniel,

    You have 2 opitions (where i'm aware of): prefix the tablename in your migrationplan with "dbo.tablename" or change the default schema for your SQL databaseuser (in my opion the best option, also when upgrading Umbraco in the future). In SQL Management Studio you can do this under "Security", "Logins", "User Mappings"

    enter image description here

    Best regards,


Please Sign in or register to post replies

Write your reply to: