RE: Copy Table + data from database A to database B

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rand Boyd [MSFT] (rboyd_at_onlinemicrosoft.com)
Date: 02/25/04


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.



Relevant Pages

  • Re: Install Windows Patch via GPO
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.windows.group_policy)
  • Re: Trust windows 2k to windows 2k3
    ... This posting is provided "AS-IS" with no warranties or guarantees and ... confers no rights. ... only reply to Newsgroups ...
    (microsoft.public.windows.server.active_directory)
  • Re: Trust windows 2k to windows 2k3
    ... This posting is provided "AS-IS" with no warranties or guarantees and confers no rights. ... only reply to Newsgroups ...
    (microsoft.public.windows.server.active_directory)
  • Re: Installing a 360 Media Center Extender
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.windows.mediacenter)
  • Re: Trust windows 2k to windows 2k3
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... only reply to Newsgroups ...
    (microsoft.public.windows.server.active_directory)