Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLIsTheDevil
Posting Yak Master
177 Posts |
 Posted - 2010-03-24 : 10:14:55
|
| Hello,Okay, I have two tables, each one on different databases (let's call them Table A and Table B). Both tables have almost the same schema, with the exception of one of them having no identity column. The column names are the same, but it will not auto-increment the ID. The reason I mention that is I want to copy data from Table A (has auto-insert turned on) to Table B (has auto-insert turned off). The problem is when I copied it over, the ID field values were different. I want the ID field values to be EXACTLY the same in both sets of tables, similar to a database backup. How can I do this without doing a database backup or anything fancy like that?Thank you. |
|
|
SQLIsTheDevil
Posting Yak Master
177 Posts |
Posted - 2010-03-24 : 10:17:59
|
| Actually, Nevermind. I see what I did wrong. Thank you. |
 |
|
|
|
|
|
How do I copy table and tempo. turn off identity?