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 69 posts 363 karma points
    Jul 04, 2020 @ 00:20
    Daniel Rogers
    0

    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 93 posts 412 karma points
    Jul 04, 2020 @ 18:49
    iNETZO
    100

    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,

    iNETZO

Please Sign in or register to post replies

Write your reply to:

Draft