I use the SQL DTS from within the SQL Server Enterprise Manager.
I don;t copy the whole database just selected tables and then schedule them. Some larger tables take a long time and I schedule them for off hours or once a week.
I have done full imports of the database however due to the length...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.