NAV DB data Migration to SQL SERVER DB

sriram_venkat

i have a client who is now working on NAV native DB which has grown into 250 GB size. Now he wants to start using SQL SERVER database for NAV

Is there anyway we can migrate all the NAV Native DB data into SQL SERVER Db?
Can it be automated process or It has to be done manually?

Thanks

Sriram

garak

viewtopic.php?f=23&t=30050

also search the forum for "migrate" sql native

Regards

navuser1

best use upgrade toolkit documentation for the Migration process...

navuser1

Or try these steps...
1.take a backup from Native.
2.Craete a Blank Db in SQL.
3. Restore the backup in this Db

garak

navuser1 wrote:

Or try these steps...
1.take a backup from Native.
2.Craete a Blank Db in SQL.
3. Restore the backup in this Db

sorry, thats not all.
@sriram_venkat follow the link and read there the steps

ta5

Just my 2 cts: This is not something you do in half a day. As many threads in this forum show, after having restored the backup on a sql server, you'll probably have to trouble shoot and optimize.

Thomas