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...
> > 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.
> >
> >
>
>

Export to Excel with Mutiple Sheets

Hi,
I have encountered this problem of not being able to export my different sub
reports to individual work sheets within excel. I have tried to put Page
breaks after each table, as this is all the sub reports contain. Thus after
each table a page break is inserted. If I preview the Report, containing all
the sub reports, it shows the correct page breaks. However when I export this
to Excel it gives me the following:
Sheet 1 - Document Map
Sheet 2 - First Sub Report
Sheet 3 - All the remainder of the Sub Reports straight after each other all
in one sheet.
I need to have the Sub Reports all in seperate sheets. Can anyone help,
please'
Thanks,
NatNat, I am experiencing the exact same problem. Have you gotten any info/reply
from experts? I really need answers, too.
thanks
"Nat" wrote:
> Hi,
> I have encountered this problem of not being able to export my different sub
> reports to individual work sheets within excel. I have tried to put Page
> breaks after each table, as this is all the sub reports contain. Thus after
> each table a page break is inserted. If I preview the Report, containing all
> the sub reports, it shows the correct page breaks. However when I export this
> to Excel it gives me the following:
> Sheet 1 - Document Map
> Sheet 2 - First Sub Report
> Sheet 3 - All the remainder of the Sub Reports straight after each other all
> in one sheet.
> I need to have the Sub Reports all in seperate sheets. Can anyone help,
> please'
> Thanks,
> Nat