navision .fbk -->MsSQL
in [Navision]
|
Prev: How to open all files (eg *.xml) in batch in a folder ???
Next: Internal error 1 in Module 5, Internal error 2 in Module 7
From: naktinukas on 10 May 2005 06:18 how to import .fbk file into MsSQL. i have 5gb navision backup file (050509.fbk) and i want to transfer\restore\import it into a new db on MsSQL 2000 server... As i am new in navision, could anybody quide me throught? any (URL, book title, etc) information source are welcome too :) thanx
From: Mestre on 10 May 2005 18:38 Hi, It could be very simple. You start Navision with option for SQL, create a new database, Option for SQL, then restore the backup. I could not so easy, when data that you have could have some conficlts with SQL datatypes, especialy on dates, most of the times when someone makes a mistake a put in a date field 10-05-205 instead of 10-05-2005, in SQL this date 10-05-205 don't exist. "naktinukas" <naktinukas(a)discussions.microsoft.com> wrote in message news:CACC879C-8CEE-4441-B54F-1DCBDAC9C63F(a)microsoft.com... > how to import .fbk file into MsSQL. > > i have 5gb navision backup file (050509.fbk) and i want to > transfer\restore\import it into a new db on MsSQL 2000 server... > > As i am new in navision, could anybody quide me throught? > > any (URL, book title, etc) information source are welcome too :) > > thanx
From: naktinukas on 11 May 2005 02:51 OK thanx i'll try that... but it seems this process will take a long time as db is 5gb so i'll wate till weekend :) "Mestre" wrote: > Hi, > > It could be very simple. > > You start Navision with option for SQL, create a new database, Option for > SQL, then restore the backup. > > I could not so easy, when data that you have could have some conficlts with > SQL datatypes, especialy on dates, most of the times when someone makes a > mistake a put in a date field 10-05-205 instead of 10-05-2005, in SQL this > date 10-05-205 don't exist. > > > > "naktinukas" <naktinukas(a)discussions.microsoft.com> wrote in message > news:CACC879C-8CEE-4441-B54F-1DCBDAC9C63F(a)microsoft.com... > > how to import .fbk file into MsSQL. > > > > i have 5gb navision backup file (050509.fbk) and i want to > > transfer\restore\import it into a new db on MsSQL 2000 server... > > > > As i am new in navision, could anybody quide me throught? > > > > any (URL, book title, etc) information source are welcome too :) > > > > thanx > > >
From: Mestre on 11 May 2005 06:06 It depends on hardware that you have "naktinukas" <naktinukas(a)discussions.microsoft.com> wrote in message news:881FA584-09D8-4BE1-A0B7-48292A975A7E(a)microsoft.com... > OK thanx i'll try that... but it seems this process will take a long time > as > db is 5gb > so i'll wate till weekend :) > > > "Mestre" wrote: > >> Hi, >> >> It could be very simple. >> >> You start Navision with option for SQL, create a new database, Option for >> SQL, then restore the backup. >> >> I could not so easy, when data that you have could have some conficlts >> with >> SQL datatypes, especialy on dates, most of the times when someone makes a >> mistake a put in a date field 10-05-205 instead of 10-05-2005, in SQL >> this >> date 10-05-205 don't exist. >> >> >> >> "naktinukas" <naktinukas(a)discussions.microsoft.com> wrote in message >> news:CACC879C-8CEE-4441-B54F-1DCBDAC9C63F(a)microsoft.com... >> > how to import .fbk file into MsSQL. >> > >> > i have 5gb navision backup file (050509.fbk) and i want to >> > transfer\restore\import it into a new db on MsSQL 2000 server... >> > >> > As i am new in navision, could anybody quide me throught? >> > >> > any (URL, book title, etc) information source are welcome too :) >> > >> > thanx >> >> >>
From: naktinukas on 11 May 2005 06:26
pIV 2.8 HT + 1gbRAM+hdd 160GB sata 8 mb cache "Mestre" wrote: > It depends on hardware that you have > > > "naktinukas" <naktinukas(a)discussions.microsoft.com> wrote in message > news:881FA584-09D8-4BE1-A0B7-48292A975A7E(a)microsoft.com... > > OK thanx i'll try that... but it seems this process will take a long time > > as > > db is 5gb > > so i'll wate till weekend :) > > > > > > "Mestre" wrote: > > > >> Hi, > >> > >> It could be very simple. > >> > >> You start Navision with option for SQL, create a new database, Option for > >> SQL, then restore the backup. > >> > >> I could not so easy, when data that you have could have some conficlts > >> with > >> SQL datatypes, especialy on dates, most of the times when someone makes a > >> mistake a put in a date field 10-05-205 instead of 10-05-2005, in SQL > >> this > >> date 10-05-205 don't exist. > >> > >> > >> > >> "naktinukas" <naktinukas(a)discussions.microsoft.com> wrote in message > >> news:CACC879C-8CEE-4441-B54F-1DCBDAC9C63F(a)microsoft.com... > >> > how to import .fbk file into MsSQL. > >> > > >> > i have 5gb navision backup file (050509.fbk) and i want to > >> > transfer\restore\import it into a new db on MsSQL 2000 server... > >> > > >> > As i am new in navision, could anybody quide me throught? > >> > > >> > any (URL, book title, etc) information source are welcome too :) > >> > > >> > thanx > >> > >> > >> > > > |