NAV2013 Copy User Metadata table from one database to anothe

rsaritzky

Hi all,

Has anyone been able to successfully copy rows from a table in NAV2013 from one database to another using windows copy-and-paste? Here's the problem I've encountered.

When you "run" a table in NAV2013, it opens the table in an RTC window. Now, you highlight the rows you want to copy and click "Copy rows".

BUT, now you have to open the second database and run the same table. But when I open the DEV environment for the second database and run the same table, it doesn't open it in the second database it opens it in the FIRST database.

AND, if you first start the RTC session for the second database, then you lose the contents of the copy/paste buffer.

Any ideas? Rapidstart won't allow you to export the User Metadata table. I think it's because it contains a BLOB field. You can't save it first to Excel because BLOB's don't copy, so I'm thinking it's the same reason.

thegunzo

I would go for SQL copy between the tables.

I also created a Page that is able to export data from any table to XML and inport in another database. Here is a link to my blog about this for NAV 2009. I have updated this solution for both NAV 2013 and NAV 2013 R2.

http://www.dynamics.is/?p=205

On the other hand, I have been able to copy-paste between identical tables without problems.

rsaritzky

thegunzo wrote:

On the other hand, I have been able to copy-paste between identical tables without problems.

Have you been able to do this when one of the fields in the table is a BLOB?

thegunzo

Hi

I have not tried the copy-paste with BLOB field.

in the XML solusion the BLOB data is converted to base64 and added to the XML, so yes.

You can also look at this tool

http://www.dynamics.is/?p=1434