You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Import Progress Database into SQl server(or Access)
- Thread starter jung1975
- Start date
U
Unregistered
Guest
I currently use progress to read & write to SQL 2000 Database and use progresses SQL Server7 Enterprize Edition.
If there is a large amout of data you want to import, I would write a program that puts the information into a text file in CSV format. Then use the SQL Enterprize Manager to import the informating into whatever tables you want. The SQL Enterprize Manager is very easy to use.
Good Luck,
Wayne
If there is a large amout of data you want to import, I would write a program that puts the information into a text file in CSV format. Then use the SQL Enterprize Manager to import the informating into whatever tables you want. The SQL Enterprize Manager is very easy to use.
Good Luck,
Wayne
Hi;
i sugest you to use the DTS (Data Transormation Services) to import data from a Progress database to Sql Server Database; it's a kind of agents that can be programmes autoamticly to perform the import of data and they can perform also transormation on data such as name of fields or lenght or any kind of tansoformation . i think it's very usefull
i sugest you to use the DTS (Data Transormation Services) to import data from a Progress database to Sql Server Database; it's a kind of agents that can be programmes autoamticly to perform the import of data and they can perform also transormation on data such as name of fields or lenght or any kind of tansoformation . i think it's very usefull
Hi,
You may use the Progress SQL Server DataServer license in order to migrate the Progress database to MS SQL Server.
In 9.1C, you can also dump a table definition as CREATE TABLE statement and select the SQL-Flavor (PROGRESS, ORACLE or SQL Server) from the Data Administration tool.
However I think the Data Transformation Services tool is easier.
You'll need an ODBC driver in order to access the Progress db from SQL Server.
For migrating a Progress database to MS Access, you can also use the ActiveX automation (ex OLE).
One of the Kbase requires an ODBC driver to achieve it as well. There are 2 knowledge bases (19442 and 20840) on the Progress web site.
Hope this helps.
Fabrice
You may use the Progress SQL Server DataServer license in order to migrate the Progress database to MS SQL Server.
In 9.1C, you can also dump a table definition as CREATE TABLE statement and select the SQL-Flavor (PROGRESS, ORACLE or SQL Server) from the Data Administration tool.
However I think the Data Transformation Services tool is easier.
You'll need an ODBC driver in order to access the Progress db from SQL Server.
For migrating a Progress database to MS Access, you can also use the ActiveX automation (ex OLE).
One of the Kbase requires an ODBC driver to achieve it as well. There are 2 knowledge bases (19442 and 20840) on the Progress web site.
Hope this helps.
Fabrice
RichardThorp
New Member
I have some sample code posting directly into Access from progress using the 4GL.
It is slow though! And it gets really slow if you nest for eaches.
For example, a bit of code that does (for example)
for each customer:
for each order of customer:
run accessexport.p
end.
end.
Took 26 hours on our 150 MB database (obviously different table names).
However,
a for each customer:
run create_csv_of_recids.p
run accessexport.p.
end.
input from csv_of_recids.
set keyfield.
for each order where order.key = keyfield:
run accessexport.p.
end.
took 5 hours! Go figure.
Anyways, if you want the code, drop me a mail.
richardt@grampian-software.co.uk
It is slow though! And it gets really slow if you nest for eaches.
For example, a bit of code that does (for example)
for each customer:
for each order of customer:
run accessexport.p
end.
end.
Took 26 hours on our 150 MB database (obviously different table names).
However,
a for each customer:
run create_csv_of_recids.p
run accessexport.p.
end.
input from csv_of_recids.
set keyfield.
for each order where order.key = keyfield:
run accessexport.p.
end.
took 5 hours! Go figure.
Anyways, if you want the code, drop me a mail.
richardt@grampian-software.co.uk