我正在寻找从Progress数据库(v10.2b)中提取的最佳方法(或几种不错的方法供您选择).最终目标将是SQL Server(v2008).我说最终目标"是因为我不必一定要直接从SQL Server内部连接到Progress,即我不反对从Progress提取到文本文件,然后将其导入SQL Server.
I'm looking for the best approach (or a couple of good ones to choose from) for extracting from a Progress database (v10.2b). The eventual target will be SQL Server (v2008). I say "eventual target", because I don't necessarily have to connect directly to Progress from within SQL Server, i.e. I'm not averse to extracting from Progress to a text file, and then importing that into SQL Server.
我对方法的研究提出了与我的方法不匹配的方案;
My research on approaches came up with scenarios that don't match mine;
- 将整个进度数据库迁移到SQL Server
- 将整个表从Progress导出到SQL Server
- 使用特定于进度的工具,而我没有访问权限
我能够使用ODBC连接到Progress,并且已经在Visual Studio(v2010)中编写了一些查询.我还对Progress数据库做了一些自定义编程,构建了一个简单的Web界面来证明一些事情.
I am able to connect to Progress using ODBC, and have written some queries from within Visual Studio (v2010). I've also done a bit of custom programming against the Progress database, building a simple web interface to prove out a few things.
因此,我的要求是使用ODBC,并建立一个例程,该例程每天每天运行一个特定的查询.然后,该查询的结果将被导入到SQL Server数据库中.预先感谢您的帮助.
So, my requirement is to use ODBC, and build a routine that runs a specific query on a daily basis daily. The results of this query will then be imported into a SQL Server database. Thanks in advance for your help.
更新 经过一些额外的研究,我确实发现我正在寻找链接服务器.使用SQL Server Express的其他人员的一些注意事项;
Update After some additional research, I did find that a Linked Server is what I'm looking for. Some notes for others working with SQL Server Express;
- 如果要使用的是SQL Server Express,则可能无法在桌面上或DTS的开始"菜单中看到程序.我发现DTSWizard.exe嵌套在我的SQL Server程序文件中(对我来说,是C:\ Program Files(x86)\ Microsoft SQL Server \ 100 \ DTS \ Binn),并且能够简单地创建快捷方式.
- 此外,由于我使用的是SQL Server的SQL Express版本,因此无法保存创建的程序包.因此,在创建软件包并运行一次之后,我只需重新运行该软件包,并保存我的SQL以便将来使用.
可以使用OLE连接到进度数据库吗?如果是这样,您可以使用 SQL Server链接服务器绕过对解压缩到一个文件,然后将其加载到SQL Server中.或者,您可以提取到Excel,然后从Excel导入到SQL Server.
Can you connect to the Progress DB using OLE? If so, you could use SQL Server Linked Server to bypass the need for extracting to a file which would then be loaded into SQL Server. Alternately, you could extract to Excel and then import from Excel to SQL Server.
更多推荐
从进度数据库提取到SQL Server
发布评论