Conversion of Database

tularam
tularam Member Posts: 97
edited 2013-03-04 in NAV Three Tier
Hi all,
I accept this is silly question but i just want to know if there is any tips and tricks to connect Existing SQL Database form NAV?
I have a hugh database developed in MSSql which takes hugh time for data migration those data are quiet confidential and we have to migrate those data in very short time. If there is any such tricks to make this work?

Thanks

Answers

  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    Please explain what you mean by "we have to migrate those data".
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • tularam
    tularam Member Posts: 97
    We have to migrate existing data of MS-SQL(Existing system's) database to Dynamics NAV 2009. Finally using SSIS tool for Data migration. But I still do not know whether there is any way to connect a previous existing Ms-SQL database form NAV or not.
  • bbrown
    bbrown Member Posts: 3,268
    I take it that "existing system" is not NAV. If that's the case, be sure you properly validate data to NAV standards. Things like no lowercase in CODE fields come to mind. SSIS will allow stuff like this, that won't be acceptable in NAV.
    There are no bugs - only undocumented features.
  • Chinmoy
    Chinmoy Member Posts: 359
    To answer your first question.. NAV client cannot connect to any external database.

Categories