Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Renaming a company in Navision SQL
Sbhat
Member Posts: 301
Hi Folks,
I am trying to rename a company in Navision using SQL and i get a error message saying 'Microsoft SQL ODBC driver not installed', i have installed the ODBC driver. Any help is appreciated.
Regards
SB.
I am trying to rename a company in Navision using SQL and i get a error message saying 'Microsoft SQL ODBC driver not installed', i have installed the ODBC driver. Any help is appreciated.
Regards
SB.
0
Comments
Are you trying to rename a DB or a Company?
The Company to be renamed (outside Navision), you must change the data in the Company table and the names of the tables of that company. It is not that simple...
How are you trying to do it?
The ODBC error you get might means that you need to install MDAC (Microsoft Data Access Components) from the Navision Installation CD.
Arhontis
https://forum.mibuso.com/search
SQL Server stores the Navision tables with the syntax [Company Name]$[Navision Table Name]. This means that a rename will cause the SQL Server to create new tables, transfer all data and drop the old ones. This will take an enormously amount of time if your database is anything else than CRONUS.
So creating a backup, restoring is as an FDB, renaming, backing up and restoring on the SQL Server is the fastest way to do it - even if it doesn't sound so :-)