RE: Copy Table + data from database A to database B
From: Rand Boyd [MSFT] (rboyd_at_onlinemicrosoft.com)
Date: 02/25/04
- Next message: Adam Machanic: "Re: Query training -- Complex queries"
- Previous message: Paul S Randal [MS]: "Re: checkalloc running out of locks"
- In reply to: Cathy Finnegan: "Copy Table + data from database A to database B"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 25 Feb 2004 22:04:20 GMT
The copy table option only copies the data. If you want to copy all the
attributes you should use the Copy objects and data between SQL Server
databases.
The copy table option was designe to allow data transfers between
heterogenous data sources.
Rand
This posting is provided "as is" with no warranties and confers no rights.
- Next message: Adam Machanic: "Re: Query training -- Complex queries"
- Previous message: Paul S Randal [MS]: "Re: checkalloc running out of locks"
- In reply to: Cathy Finnegan: "Copy Table + data from database A to database B"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|