TS ODBC DataServer - 解决方案iV到MS SQL数据库 [英] TS ODBC DataServer - Solution iV to MS SQL Database

问题描述

如何从Thoroughbred Solution-IV ERP迁移到MS Dynamics NAV 2009



a ODBC多层驱动程序连接在解决方案 - IV结束时打开。



如何将数据迁移到MS SQL数据库？



在此先感谢....

Hi,


How to migrate from Thoroughbred Solution - IV ERP to MS Dynamics NAV 2009

a ODBC multi tier Driver connection is open at Solution - IV end.

How to migrate that data to MS SQL Database ?

Thanks in Advance....

推荐答案

如果你还没有这样做....

看起来你有办法连接到旧数据库（你提到了一个ODBC连接），然后你可以使用SSIS（Sql server集成服务）包来复制数据，映射字段等。 ..从一个数据库到另一个。你将不得不对它进行一些阅读，因为它应该在这里完整地解释一个完整的逐步解决方案，屏幕截图太长，无法在这里覆盖整个软件。



摘要将是......

1.设置SSIS包软件。您可以使用Visual Studio BI for 2005,2008 ...还不确定2012年，但SQL Server的版本很重要。 VS2005仅适用于SQL Server 2005，与VS2008到SQL2008一样。



2.在新的SSIS项目中，为旧数据库创建一个连接管理器，另一个连接到新的SQL服务器。



3.设置数据流并按字段将旧表映射到新表（如果字段名称和数据类型相似则有很多帮助！）



4.测试并运行它。



最好的方式我知道怎么做。比编写自己的应用程序更快。

If you haven't done this yet....
It looks like you have a way to connect to the old database (You mentioned an ODBC connection for it) then you can use SSIS (Sql server integration services) packages to copy data, map fields etc... from one database to another. You'll have to do some reading up on it because its more than should be explained in full here a complete step by step solution with screen shots be way too long to cover an entire piece of software here.

A summary would be...
1. Get your SSIS packages software set up. You can use Visual Studio BI for 2005, 2008...Not sure about 2012 yet, but the version of SQL Server is important. VS2005 only works with SQL server 2005, same with VS2008 to SQL2008.

2. In your new SSIS project, Create some connection managers one for your old database, another connection to the new sql server.

3. Setup dataflows and map the old tables to new tables field by field(if the field names and data types are similar it helps alot!)

4. test it and run it.

Best way I know how. Faster than writing your own app to do it.

这篇关于TS ODBC DataServer - 解决方案iV到MS SQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！