"gurvar" <gurvar@discussions.microsoft.com> wrote in message
news:64E8765C-681C-4EB9-B547-AF98571CD3B3@microsoft.com...
> Hi
>
> I have a old database A which need to be exported,
> made changes like including some columns/delete columns etc
> and imported again (basically changing MetaDB) as database B.
>
> Question is what will happen to the Auto number generated fields?
>
> Database A has Auto fields ID starting at 134,135,156 etc
> After changing it to Database B and I enter a new records
> will it be assigned an ID such as 1,2,3 etc?
>
> Really appreciate any feed back.
>
> Thanks.
>

"Hilary Cotter" wrote:

> Yes it will, unless you use identity_insert on database b. If you use bcp to
> push your data you can use the -E switch which will preserve the identity
> values.
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
>
>
> "gurvar" <gurvar@discussions.microsoft.com> wrote in message
> news:64E8765C-681C-4EB9-B547-AF98571CD3B3@microsoft.com...
> > Hi
> >
> > I have a old database A which need to be exported,
> > made changes like including some columns/delete columns etc
> > and imported again (basically changing MetaDB) as database B.
> >
> > Question is what will happen to the Auto number generated fields?
> >
> > Database A has Auto fields ID starting at 134,135,156 etc
> > After changing it to Database B and I enter a new records
> > will it be assigned an ID such as 1,2,3 etc?
> >
> > Really appreciate any feed back.
> >
> > Thanks.
> >
>
>