dbTalk Databases Forums  

How can i import objects by Query Analyser 'simulating this transaction as if it was made by DTS'?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss How can i import objects by Query Analyser 'simulating this transaction as if it was made by DTS'? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Marcelo Coimbra
 
Posts: n/a

Default How can i import objects by Query Analyser 'simulating this transaction as if it was made by DTS'? - 10-17-2003 , 03:24 PM






Hi, does anybody knows if is it possible to import objects (tables WITH
its relationships, primary keys, foreign keys) using only Query
Analyzer? And if it is possible, how can i do this transaction? Any
example would be very welcome!

Thanks!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: How can i import objects by Query Analyser 'simulating this transaction as if it was made by DTS'? - 10-18-2003 , 05:38 AM






Directly you can't. You would have to call out to a COM component like
SQLDMO to do this but it would be long winded and protracted.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Marcelo Coimbra" <mcoimbrac (AT) yahoo (DOT) com> wrote

Quote:
Hi, does anybody knows if is it possible to import objects (tables WITH
its relationships, primary keys, foreign keys) using only Query
Analyzer? And if it is possible, how can i do this transaction? Any
example would be very welcome!

Thanks!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.