Set identity in SQL2008 table column when data exist in table.
1.export data from local server to other server.
2.when select table from one server to other server.
3.Edit mapping option in window.
4.Click this button open window have option Edit SQL.
5.Click EDit SQLand change shema of table and then ok.
6.befor this select enable identity insert/Drop recreate option also.
1 comment :
thanks a lot for help.....
Post a Comment