I have two databases (DB1 & DB2) which are exactly the same, they are both linked to Navision for different testing environments. Now my question is I have imported a table from DB1 to DB2 (same structure and data), but when I open the copied table from Navision (with DB2 linked), I got an error message "The XXX table has no ROWVERSION column in the SQL Server table description". Any ideas how to fix this issue !? Thanks.
0
Comments
When you exported the table object did you save it as FOB or TXT?
If you had done it by TXT try FOB. I have seen too many a time when I received errors when importing an unmodified TXT export. (Leading me to believe there is a possibility to import a TXT with no errors yet experience issues when referencing the imported Object)
--- edit ---
Then again, anything you add/modify/whatever using SQL and/or 3rd party programs, is all transparent to Navision, no? Perhaps you should remove the table structure from DB2 (the copied one from DB1 via SQL) and just export the table object from (Navision) DB1/Company -> DB2/Company. That way Navision takes control over the process.
If this is the case, open Navision -> DB1 -> Company (Ctrl-O) -> Object Designer (Shift-F12)
Click the Table button within the Object Designer, find your table, select it by clicking once then: File -> Export -> "Save as type: Navision Object Format (*.fob)"
Save it to a location you can easily remember/find. Close the current Database (Or just select to Open a Database) Connect to DB2 -> Company (Ctrl-O) -> Object Designer (Shift-F12)
File -> Import -> Locate the FOB file and Open.
Hmm... yeah I'm quite a newbie when it comes to SQL. You'll have to wait for one of the SQL savvy users to see your post. I'm sure they'll be able to help
(Actually I couldn't even find very much information on RowVersion errors :-s)