Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Problem exporting database to SQL Server
dashiad
Member Posts: 3
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!
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!
0
Comments
I dont want to alter the table design..I want to update the record so the stored date is a valid one..
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.