Exporting & Importing certain tables

We have a database which services a number of websites. We want to move
individual tables for each website from the exisiting server to the new SQL
2005 Cluster as we modify the websites to point to the new location.
Is this possible or do I need to restore the whole database?
Thanks,
Neil Paddock.
SSSIS/DTS, BCP, Import/Export Wizard, BULKCOPY will all allow you to easily
move individual tables from one database/server to another. See BOL for
details.
TheSQLGuru
President
Indicium Resources, Inc.
"Neil Paddock" <NeilPaddock@.discussions.microsoft.com> wrote in message
news:AA18F359-6356-48EF-B458-32060A0552BE@.microsoft.com...
> We have a database which services a number of websites. We want to move
> individual tables for each website from the exisiting server to the new
> SQL
> 2005 Cluster as we modify the websites to point to the new location.
> Is this possible or do I need to restore the whole database?
> Thanks,
> Neil Paddock.
>
|||Thanks for the info.
I have attempted to copy a table from one database to another using
Import/Export Wizard but I'm receiving an error message:
Validating (Error)
Messages
Error 0xc0202049: Data Flow Task: Failure inserting into the read-only
column "Employee_id".
(SQL Server Import and Export Wizard)
Error 0xc0202045: Data Flow Task: Column metadata validation failed.
(SQL Server Import and Export Wizard)
Error 0xc004706b: Data Flow Task: "component "Destination -
employee_details" (130)" failed validation and returned validation status
"VS_ISBROKEN".
(SQL Server Import and Export Wizard)
Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)
Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)
It seems to be a validation error to do with the destination being read
only? How do I change this?
Thanks,
Neil Paddock.
"TheSQLGuru" wrote:

> SSSIS/DTS, BCP, Import/Export Wizard, BULKCOPY will all allow you to easily
> move individual tables from one database/server to another. See BOL for
> details.
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "Neil Paddock" <NeilPaddock@.discussions.microsoft.com> wrote in message
> news:AA18F359-6356-48EF-B458-32060A0552BE@.microsoft.com...
>
>