Updating SQL Server 2000 1

[dpk136]

I have a client that i'm developing a e-commerce site for. They have Progress 9.1 and SQL Server 2000...i'm running ASP. What i need is the progress data to update the SQL Server tables. The only problem is that i'm only allowed to get data from the Progress database, i'm not allowed to develop in Progress or write any more data within it. Would a DTS be sufficient to overcome this.

Another problem that i have is getting the structures to match up. Is there any way in Progress to export the SQL statements that are used to recreate the tables. Is the only way to look at the data dictionary and do it all by hand?


David Kuhn
------------------

http://www.davidpkuhn.com

 

[longhair]

dpk136,
how are you getting the data from progress?
regards,
longhair

 

[dpk136]

right now on the website we are using progress as the backend. this site was strictly a read only reporting site. Now they would like it to allow customers to update information. However, they do not want the Progress database touched other than information read out of it. I'm using the Merant ODBC Driver. I was thinking of getting the data using DTS in SQL Server 2000.

David Kuhn
------------------

http://www.davidpkuhn.com

 

[longhair]

dpk136,
so you want to get the data out of progress into sql2000 and then allow updates / changes only to sql2000? doesn't make much sense to me - their 'true' backend won't have the correct data, but that's niether here not there.
i belive that the odbc driver is very slow, at least it was the last time we looked at using it. you could look at having them send you flat files & importing them.
as for your schema, you can have them look into the progress 'SQL data server' tab (and its subfunctions like 'create dataserver schema') and/or the 'PRO/SQL' tab (and its subfunctions like 'dump as create table statement'). both of these are available from the 'data dictionary' tab under the 'tools' tab in the progress explorer.
also take a look at the archives section wof

http://www.peg.com.

this should get you on your way.
regards,

longhair

 

[dpk136]

Thanks longhair. Will DTS work though...i mean, we are not talking about tons of records, it will be a maybe 50000 records

David Kuhn
------------------

http://www.davidpkuhn.com

 

[longhair]

dpk126,
i think it will, but have not experience with it. best bet is to do a search on the peg archives.

regards,
longhair

 

[dpk136]

ok...thanks again.

David Kuhn
------------------

http://www.davidpkuhn.com