How to copy tables from other db

[alangomez2]

deleted

[#HB]

You can set IDENTITY_INSERT off, copy, then set it back on.

[NorseGodTyr]

Originally Posted by alangomez2

Two tables

*Shard
*Shard1

Table _RefGame_World

I cant copy the table from Shard1 to Shard

There is a problem with the Constraint Pk key

So what i can do??

If i deleted the primary key then i cant recreate it

If i dont delete it i cant copy the tables

Any hints?

With my Shard ()

With a clean Shard db (Shard1)



So the problem is that, with my shard jump from 94 to 96 and with a clean db not, why?

Red is the Table
SELECT * INTO SRO_VT_SHARD.dbo._RefObjItem from SRO_VT_SHARD1.dbo._RefObjItem

[alangomez2]

Originally Posted by #HB

You can set IDENTITY_INSERT off, copy, then set it back on.

Dude i fixed it, but i tried that and, cant cuz the key clustered

Originally Posted by NorseGodTyr

Red is the Table
SELECT * INTO SRO_VT_SHARD.dbo._RefObjItem from SRO_VT_SHARD1.dbo._RefObjItem

That's for sure not working since the identity and also the key, i tried this method b4

[hoangphan7]

INSERT INTO Shard.._Table Select * from Shard1.._Table

[alangomez2]

Originally Posted by hoangphan7

INSERT INTO Shard.._Table Select * from Shard1.._Table

You should read first, i've fixed but your method won't work since there is needed to set identity insert on and also the table has a pk key