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
-
Hello SB,
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.0 -
You can always backup the SQL database return it to FDB and rename then reBackup lastly restore to SQL, well It is not a good soliton but if you're hopeless...//EMK\\0
-
Actually the FDB suggestion is the best way to do the renaming.
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 :-)0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions