Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K 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
- 325 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 994 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
Migration from one SQL Server to a new...
Brannmark
Member Posts: 9
I need to migrate a client over from thier old SQL Server 2005 to a completly new server also with SQL server 2005.
Tried to use SQL server for the migration but got locked out of the database. I used the backup tool in SQL server and did a restore of the backup in the new sql server. When I tried to login into Navision the user didnt work on certain object even though I hade SUPER permission. Also verifed that the users in the new sql server hade the same permissions as in the old one. The odd thing is that some items worked, but others didnt..
Seams like Navision is doing something in the master databases that doesnt get into the backup.
So what is the best steps to migrate a client over to a new sql server?
I thought I would try this way:
1. Created a new database thru the Navision client on the new sql server.
2. Make a backup thru navision of the database from the old sql server.
3. Restore the backup in the new database / sql server.
Anyone done this before?
Tried to use SQL server for the migration but got locked out of the database. I used the backup tool in SQL server and did a restore of the backup in the new sql server. When I tried to login into Navision the user didnt work on certain object even though I hade SUPER permission. Also verifed that the users in the new sql server hade the same permissions as in the old one. The odd thing is that some items worked, but others didnt..
Seams like Navision is doing something in the master databases that doesnt get into the backup.
So what is the best steps to migrate a client over to a new sql server?
I thought I would try this way:
1. Created a new database thru the Navision client on the new sql server.
2. Make a backup thru navision of the database from the old sql server.
3. Restore the backup in the new database / sql server.
Anyone done this before?
0
Comments
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Going to try the way I describe now. Anyone got any better suggetions than my planned method?
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
http://support.microsoft.com/kb/246133
We've used this as well (recently), and worked like a charm.
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog