We where also using the Merant's ODBC drivers and had many problems with this and it's very slow. I have made a export routine that is now running every night.
What it's doing is the following:
Export all the needed tables to a seperate csv file
Ftp the files to the MS SQL machine
Use SSIS...
Thank you for the help it's working now how we want it.
Now only one other question i have one table with a field in it that has 32k in it and in the field are quote's so when i import these in SQL 2005 with SSIS it can't handle the quote's. how to use an other text qualifier?
Thank you for the information and help. Here a what i want to do.
I have the following tables in the progres DB
Contact
Contract
Project
Offerte
And want Contract exported to a seperate export file so
Contact to Contact_xoc1010i.csv
Contract to Contract_xom4010i.csv
Project to...
Yes this helps me very much, now i want to do this voor for example 10 tables. Now I i copy the above code 10 times and change the table name. Is it possible to use a array where i put in the table name and the ftables output file and that i can use one time the above code?
I am missing now the line: Output to "/data/export/micos/ContractRegel_xas4711i.csv". and i want the count information in a seperate file.
and want to dump more tables, is it possible to make a var and put in there the tables that i want to export and also a var where the file names are in?
Hello here a newbie to Progress.
I dump every night the tables to a flat txt file with the following code:
and so i have more code for every table that i want to export to flatfile. But now i want after every export the records count and writen to a export.log file with the table name an...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.