I have added some features to the very simple tool (which was born to launch only XML), they are simple but they can be useful.
Delete Data from Tables
ALL Sessions Killer
XMLPort Runner LOG
I was so proud with my previous blogpost as I was able to solve a somewhat complicated problem generically. And now there appears to be a platform solution for what I was trying to solve (or at least for a big part of it).
I remember to have provided feedback to Microsoft on exactly this topic: restore data generically with one statement. Not saying it’s because of me that it’s in the product, only saying it makes a lot of sense that there is a platform statement to just “restore what you can restore“.. .
If you have some old NAV releases and you want to copy data fast from db\company to another db\company (and you don’t want to use Dataport\XMLPort to map each fields ore use Rapid Start Services), you can use SQL “INSERT INTO” statements to transfer data.
As we all know that there is Document Shipped with every product DVD of Navision which list down the steps for Data Migration. In some new version it was not shipped in product and was released later in Microsoft Team Blog.
What we do is we follow the steps listed in the Document and do the data migration, but in certain cases we face issues for which we don’t have any reference in the document shipped from Microsoft.