transfer Database object using MSSql

[ggman]

Hi:

I am using the GUI from the MS SQL Enterprise manager to transfer database objects from one server to another server. Does any one have the Script which I can schedule to run on a daily basis or as need which can be invoked from a dos prompt.


Thanks

 

[tlbroadbent]

If you have SQL 7 or later, you can create a DTS package and schedule it to run daily or as needed. There are other options depending on the version of SQL running on each server. If you provide a little more detail, I should be able to provide additional suggestions and perhaps show you an example script or point you toward one in the web. Terry

http://members.home.net/tlbroadbent/prog.htm

------------------------------------
Experience is the hardest kind of teacher. It gives you the test first, and the lesson afterward.

 

[dbmsguy]

you could use bcp!

bcp dbname..tablename bla bla bla.... the -S would be the source server and the bcp would be run on the target. you then only have to bcp in......

if you have pre or post steps you would then just run them via ISQL....

Paul

http://www.dbmsguy.com