I need to import all tables with constrainsts from Ms Access97 to Ms SQL7.
It have to be not simple copy (one to one) but copy with changing the
structure of tables and the relationship beetwen the tables. As I know the
DTS of Microsoft SQL7 has not of that service.
May be anybody know how to pump the datas from Ms Access to Ms SQL7 with the
transformation of structure of datas. May be the smart readymade components
of Delphi (or VB) have already existed for that case or something like it?
I will be very gratefull to you for your answer.
With respect, Yevhen