Migrating from Native database to SQL

kolaboy

I am about to migrate from Navision Native database to SQL Server.
Can Somebody tell me the procedure to take one by one in systematic steps form.

I have never migrated from Native to SQL
Assistants please.
Thanks

garak

do you have search the forum?

Quick:
1) Download the upgrade toolkit
2) Read the migration documentation
3) Import the Migrate.fob
4) Run the objects from the migrate
5) Make native Backup
6) Create an Database with finsql -Client on SQL Server (read manual)
7) Import native Backup
8) now you have an SQL Server Database
9) Question: Database Login / Windowslogin
Databse -> (create Database user on SQL Server)
10) Create your maint. plans


regards

kolaboy

Thanks for the quick reply.
I have seached the forum but not seen any.

Create your maint. plans

What do you mean by the above.

I want it on database login. Which manual are you refering to for the point below:

Create an Database with finsql -Client on SQL Server (read manual)

Do you mean restoring the backup or importing it?
thanks

kine

garak wrote:

do you have search the forum?

Quick:
1: Make native Backup
2. Create an Database with finsql -Client on SQL Server (read manual)
3. Import native Backup
4. now you have an SQL Server Database
5. Question: Database Login / Windowslogin
Databse -> (create Database user on SQL Server)
6. Create your maint. plans


regards

Not enough...

1) Download the upgrade toolkit
2) Read the migration documentation
3) Import the Migrate.fob
4) Run the objects from the migrate.fob to check and repair all date fields for incompatible dates (it can take hours on bigger database)
5) Make a backup
6) continue though steps from Garak...

garak

oh yes, i've forgotten kine's steps 8-[

kine

garak wrote:

oh yes, i've forgotten kine's steps 8-[

It is common mistake. You will find out that you something forgotten when you try to restore the backup and you will see the error about incompatible date... 8)

DenSter

So it's important to test this out once or twice on a spare machine. You need to know how long it will take the migrate.fob objects to run so you know what to expect for production.

Alex_Chow

One other thing I would recommend is to test out the upgrade in SQL environment first. Chances are, you're going to need some light tuning to boost performance.

Properly tuned SQL DB is LIGHTNING!!!