Synchronise All Datas between Nav2009 and Navision 4 Sp2

PedroMoreira

Hi Everybody,

Does anyone know how to copy data from Nav2009 to a db Nav 4 sp2 ?

I've try with the sql managment studio's function Import/Export data, I made a package whitout the colums timestamp, but when I execute this package i've the this message :

Message
Executed as user: [USERNAME]. Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 17:48:01 Error: 2012-06-01 17:48:28.95 Code: 0xC0202009 Source: Data Flow Task 6 Destination 27 - Rubattel & Weyermann$Appliques [170] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E37 Description: "Invalid object name 'dbo.Rubattel & Weyermann$Appliques'.". End Error Error: 2012-06-01 17:48:28.95 Code: 0xC0202040 Source: Data Flow Task 6 Destination 27 - Rubattel & Weyermann$Appliques [170] Description: Failed to open a fastload rowset for "[dbo].[Rubattel & Weyermann$Appliques]". Check that the object exists in the database. End Error Error: 2012-06-01 17:48:28.96 Code: 0xC004706B Source: Data Flow Task 6 SSIS.Pipeline Description: "component "Destination 27 - Rubattel & Weyermann$Appliques" (170)" failed validation and returned validation status "VS_ISBROKEN". End Error Error: 2012-06-01 17:48:28.96 Code: 0xC004700C Source: Data Flow Task 6 SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2012-06-01 17:48:28.96 Code: 0xC0024107 Source: Data Flow Task 6 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 17:48:01 Finished: 17:48:29 Elapsed: 27.44 seconds. The package execution failed. The step failed.


For information both databases are in the same server (Windows server 2008 64bits with SQL server 2008 64bits)


Thanks in advance for the help.

Pedro Moreira

kriki

If the 2 DB's are on the same server, (or a linked server), you can try an INSERT-SELECT FROM.
But for that, your 2 DB's need to have the same codepage, otherwise you have to convert are the text-fields.
The other option is using a dataport/XMLport to export-import the data.