CRM Forum » Microsoft Dynamics CRM

Add user tables into <organization_name>_MSCRM database

(7 posts)
  1. UG Bot

    admin
    Joined: Jul '08
    Posts: 2,034

    Newsgroup subject: add new tables to ms crm database
    Archived from: microsoft.public.crm
    Author: romeo

    Is it possible to add user tables into <organization_name>_MSCRM database.
    I want to store some information to these tables.

    My concern is will it affect/create problem to my MS CRM system?

    --
    romeo!!

    Posted 1 year ago #
  2. UG Bot

    admin
    Joined: Jul '08
    Posts: 2,034

    Newsgroup subject: Re: add new tables to ms crm database
    Archived from: microsoft.public.crm
    Author: Aamir Bashir

    It is not supported to do that. The user tables appear in database
    when we create custom entities with the extension of New (or what is
    configured by the user).

    You need to choose some other way.

    ------

    Aamir

    Blog : http://mscrmsupport.wordpress.com/

    Posted 1 year ago #
  3. UG Bot

    admin
    Joined: Jul '08
    Posts: 2,034

    Newsgroup subject: Re: add new tables to ms crm database
    Archived from: microsoft.public.crm
    Author: romeo

    What can happen if I add a table named 'duplicates'? Will the CRM application
    stop working or else?
    --
    romeo!!

    Posted 1 year ago #
  4. UG Bot

    admin
    Joined: Jul '08
    Posts: 2,034

    Newsgroup subject: Re: add new tables to ms crm database
    Archived from: microsoft.public.crm
    Author: tjudgeiii

    I wouldn't think anything if CRM's native code isn't perrforming
    queries against this table anyway. Until you started writing code to
    perform queries on your new table, (joining etc...) then maybe you
    would encounter some problems.

    Correct me if I'm wrong.

    Posted 1 year ago #
  5. UG Bot

    admin
    Joined: Jul '08
    Posts: 2,034

    Newsgroup subject: Re: add new tables to ms crm database
    Archived from: microsoft.public.crm
    Author: romeo

    I am going to use these tables from a pre-callout only to store information.
    These tables will have no related to any existing tables in MSCRM database.
    Before creating tables I want to make sure that these would not create any
    problems in the crm system.

    Is it like MSCRM or Metabase database stores any information regarding how
    many tables are there in MSCRM database. If no then I think I can create
    these tables. What you guys suggest?

    --
    romeo!!

    Posted 1 year ago #
  6. UG Bot

    admin
    Joined: Jul '08
    Posts: 2,034

    Newsgroup subject: Re: add new tables to ms crm database
    Archived from: microsoft.public.crm
    Author: Jevgenij Martynenko

    Hi,

    I would strongly suggest you to create a new database on the same server and
    use it to store the data.
    Shouldn't be problem, and is the supported way of achieving your goal.
    The rule of the thumb with Microsoft CRM: stick to the supported way as much
    as possible.

    Regards,
    Jevgenij

    Posted 1 year ago #
  7. UG Bot

    admin
    Joined: Jul '08
    Posts: 2,034

    Newsgroup subject: Re: add new tables to ms crm database
    Archived from: microsoft.public.crm
    Author: Dossies

    Hello,

    I strongly agree with Jevgenij. Problems could occur when you need to
    upgrade to a new version or need to perform official microsoft updates to
    your mscrm database.

    Regards,
    Kevin Dosseray

    Posted 1 year ago #

RSS feed for this topic

Reply

You must log in to post.