July 9, 2002 at 7:57 am
Hi list,
here is my problem. I have a SQLServer (2000) inside my Lan. On the other site (outside my Lan) there is another SQLServer, they have no direct connection. So now I want to tranfer some tables daily from inside to outside. The tranfers is realized via mail, inside and outside there are some processes which look for new mail and start some other proceses. My problem is now, that inside my tables can change in structure (adding a column). So what I like to do is to create a DTS-package which generates a SQL for table creation. This script will be saved on a inside location, my transfer processes will copy it to outside and a DTS-package on my outside server will drop existing table and recreate it with new structure.
I haven't found a way to create such a SQL script in a package.
TIA
Volker
July 9, 2002 at 8:05 am
Should be able to do it using DMO.
Andy
July 9, 2002 at 9:04 am
Hi Andy,
thanks for fast reply, but isn't there a'n easier way to do this in DTS?
Volker
July 9, 2002 at 9:17 am
July 9, 2002 at 9:27 am
OK, thanks for your help, if i have a solution I will inform you.
Maybe someone else has a solution.
Volker
July 9, 2002 at 12:51 pm
You could query information_shema views and roll your own script.
Steve Jones
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply