Problem exporting database to SQL Server

dashiad
dashiad Member Posts: 3
edited 2005-11-29 in Navision Attain
Hello,
I'm new to Navision, so excuse me if i'm asking something obvious..
I'm trying to export a Navision database to SQL Server.But, there's a problem with certain records of certain tables: There are dates in a format SQL Server wont accept. (There are years in the form "0803")
If i try to modify the record (using C/ODBC), i get a problem with permissions.I dont have permissions to modify records in the table.
My database user has "super" permissions.I've read about that permission doesnt gran access to objects with an ID < 50000.Which permission do i need then?

Thank you for your help!

Comments

  • sharks
    sharks Member Posts: 22
    your will be able design only what you've bought. this all depense on your license. to design certain tables though you will need a developers or cinsultants license which if i'm not mistaken you get when you pass the exams.
  • dashiad
    dashiad Member Posts: 3
    Sorry, i think i didnt explained it right...
    I dont want to alter the table design..I want to update the record so the stored date is a valid one..
  • sharks
    sharks Member Posts: 22
    OK, now I understand what you need. Do not feel bad, everyone that has upgraded to SQL from native has asked exactly the same question.
    First you need the Navision CD. On the CD you will find the folder "upgtk" in the root directory. This is where you will find Upgrade Toolkit. In the "upgtk/Doc" folder you will find the documentation.
    The procedure to use in order to fix the date data of all tables starts at step 5 on page 103 of the documentation pdf . Just follow the procedure and you should be ok. Personally I suggest reading the manual and doing some more steps mentioned in the documentation (prior and after fixing date). Reading it will help you understand what exactly you are about to do and how to do it as well as fix some errors. There are some reasons that probably lead you to migrating to SQL in the first place so the manual will help you create a healthy and solid database to offer your customer and therefore provide some visible changes/benefits to justify the migration.

Categories