sql server dts: import/export stored procedures and views in SQL Server -- sql server dts

import/export stored procedures and views in SQL Server

Invotion
1/7/2004 2:53:48 PM

If you are using the DTS Import/Export wizard, make sure
you choose to "Copy Objects and Data" instead of "Copy
Tables and Views".

Sincerely,
Invotion Engineering Team
Advanced Microsoft Hosting Solutions
http://www.Invotion.com

[quoted text, click to view]

Re: import/export stored procedures and views in SQL Server

Allan Mitchell
1/8/2004 7:31:40 AM

In Designer there is a Copy SQL Server Objects task which will do this for
you. Personally I would use a script to copy these objects out and reapply
them.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.