I need to get data out of SQL Server2005 tables, and into another system.
My vendors says:
"We don´t recommend that you go directly in the SQL and collect data, because it can result in corruption of data or you can lock tables while exporting."
Is that true?
According to Microsoft themselves the answer to the question is the following:
"ODBC access to Microsoft Navision is fully supported for Read operations although write operations need careful attention as the business logic is bypassed (for example triggers are not executed)."
Source: page 15 in http://www.navisionguider.dk/downloads/Nav_IntegrationGuide1.2.pdf
Anyone with experiences in using ODBC for read operations only? Does it disturb the write operations in any critical way? (is write operations made impossible, or is data destroyed)? Or is it just a performance issue? (slower writes, while you're exporting/reading tons of data)? I guess I could experience dirty reads (read outdated data), but write operations should still be possible for others?