mibuso.com

Microsoft Business Solutions online community
It is currently Thu May 23, 2013 4:05 pm

View unanswered posts | View active topics


Board index » Microsoft Dynamics NAV (formerly Microsoft Business Solutions-Navision) » Navision Financials

All times are UTC + 1 hour [ DST ]



Post new topic Reply to topic  Page 1 of 1
  [ 6 posts ] 
  What's this MUID? [MUID:URE8] Previous topic | Next topic 
Author Message
smeade
 Post subject: BIGINT
PostPosted: Mon Sep 28, 2009 9:16 pm 
Offline

Joined: Mon May 01, 2006 2:25 pm
Posts: 22
Location: Piney Flats, TN
Country: United States (us)
I am trying to restore a 2.01 backup into a blank 3.70 SQL database and get an error that says "datatype" BIGINT is not recognized. Anyone know the solution to this?
Top
 Profile  
 
ara3n
 Post subject: Re: BIGINT
PostPosted: Mon Sep 28, 2009 9:30 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8700
Location: 3rd rock from sun
Country: United States (us)
Where are you getting the error? On what object?

Try to import the objects first from the fbk first than restore the companies.

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/

Top
 Profile  
 
smeade
 Post subject: Re: BIGINT
PostPosted: Mon Sep 28, 2009 9:48 pm 
Offline

Joined: Mon May 01, 2006 2:25 pm
Posts: 22
Location: Piney Flats, TN
Country: United States (us)
The error points toward a table named Session.
Top
 Profile  
 
ara3n
 Post subject: Re: BIGINT
PostPosted: Mon Sep 28, 2009 9:54 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8700
Location: 3rd rock from sun
Country: United States (us)
session is a view on sql and not a table. Do they have a table named session?

I'm guessing you are migrating to SQL?

Can you import the objects first?

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/

Top
 Profile  
 
smeade
 Post subject: Re: BIGINT
PostPosted: Tue Sep 29, 2009 9:56 pm 
Offline

Joined: Mon May 01, 2006 2:25 pm
Posts: 22
Location: Piney Flats, TN
Country: United States (us)
No, There is no table that I can find in the database named Session.....
Top
 Profile  
 
ara3n
 Post subject: Re: BIGINT
PostPosted: Tue Sep 29, 2009 10:12 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Wed Dec 15, 2004 6:11 pm
Posts: 8700
Location: 3rd rock from sun
Country: United States (us)
It looks like you are restoring into sql 2005 with 3.7 exe.

3.7 is not supported on 2005. You need newer exe.

https://mbs.microsoft.com/knowledgebase ... RNXQWXLQLN

_________________
Rashed.

blog: http://mibuso.com/blogs/ara3n/

Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 6 posts ] 

Board index » Microsoft Dynamics NAV (formerly Microsoft Business Solutions-Navision) » Navision Financials

All times are UTC + 1 hour [ DST ]

Who is online

Users browsing this forum: No registered users and 0 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: