|
visakh16
Very Important crosS Applying yaK Herder
India
48076 Posts |
 Posted - 05/30/2012 : 15:44:38
|
quote:
Originally posted by jfm
Hi there,
I have 2 tables in one database and I want to copy them into another database.
Which is the query?
Thanks
multiple ways
1. Export Import wizard
2. Linked server
3. OPENROWSET
if you want to preserve constraints, indexes etc also script the tables out and run it in new database using generate scripts wizard
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
TABLE INTO DATABASE
