Loading

How to copy data of one table from one server to another server using sql script..

dev 0

14y2.5k

How to copy data of one table from one server to another server using sql script..
As i want to make a sproc for daily run,bcz i dont want to go through the right click import/export functinality.

-sql server 2008

Plz help me.

Thanks. .

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Akkiraju Ivaturi14y ago
Create SSIS package. If you need any help give your specification and we should be able to help you out.
Hemant Srivastava14y ago
You may go with Import/Export option (as you said) and save that SSIS package for later use. Just Run that saved package whenever you need OR Create a job which run your saved SSIS package periodically.