install free video download convertor

Name: install free video download convertor
Category: Download
Published: liatoddpigbu1981
Language: English



























Extract from Progress Database to 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;
Migrating an entire Progress DB to SQL Server Exporting entire tables from Progress to SQL Server Using Progress-specific tools, something to which I do not have access.
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.
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.
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;

Views: 1

Comments are closed for this blog post

© 2020   Created by PH the vintage.   Powered by

Badges  |  Report an Issue  |  Terms of Service