How to split Navision tables amongst different SQL database

melbourne
melbourne Member Posts: 2
edited 2006-07-24 in NAV/Navision Classic Client
Hi,

I am looking for a document that defines how to split Navision tables amongst different SQL database files.

Regards

Comments

  • DenSter
    DenSter Member Posts: 8,307
    There's nothing you can do from within NAV to accomplish that. The only way you can do that is to use SQL Server tools. Beware though that when you design and save a table from within NAV, your settings for that table may be lost.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    For what I have heard it should be possible to do an alter table in SQL without having problems with tabledesign afterwards.

    I have not tested it yet and I would strongly recomend doing that before proceeding to apply this in a live database!
    Marije Brummel | Freelance Business Central Specialist
  • ara3n
    ara3n Member Posts: 9,258
    Yes, I've seen people unchecking "Not NULL" property on tables and after saving the table in Navision, the property stays in SQL.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n

Categories