Copy Table + data from database A to database B
From: Cathy Finnegan (eliminates_spam_caeriel1_at_cablespeed.com)
Date: 02/25/04
- Next message: Aashish: "Filter data in sql reporting services"
- Previous message: Geoff N. Hiten: "Re: MAPI client for SQL Mail and SNMP Integration"
- Next in thread: Rand Boyd [MSFT]: "RE: Copy Table + data from database A to database B"
- Reply: Rand Boyd [MSFT]: "RE: Copy Table + data from database A to database B"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 25 Feb 2004 15:53:14 -0500
Hi:
I'm really new to this DBA stuff and I need an explanation for what just happened.
I just used the copy wizard to copy Table A from database A to database B.
All the data and the table structure were successfully created in database B with one exception: the first column had
the IDENTITY (1,1) attribute set in database A. But after the copy to database B the IDENTITY attribute was missing!!!
Fortunately, I'm one of those inveterate "testers" so I discovered the problem before it made it into Production.
Eventually, I had to generate a script for the table to create that table in database B with the IDENTITY in place and
then import the data.
Anyone have any idea what the problem is and how to solve it?? I don't like the idea of having to generate a script for
each table that I need to move and then import the data!!!! The copy wizard is a gem if it works as advertised!
Using SQL Server 7.0.
cathy
- Next message: Aashish: "Filter data in sql reporting services"
- Previous message: Geoff N. Hiten: "Re: MAPI client for SQL Mail and SNMP Integration"
- Next in thread: Rand Boyd [MSFT]: "RE: Copy Table + data from database A to database B"
- Reply: Rand Boyd [MSFT]: "RE: Copy Table + data from database A to database B"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
