topic How I can shift non-spatial tables into enterperise geodatabase without changing primary key and foreignkeys in sql server? in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/how-i-can-shift-non-spatial-tables-into/m-p/826287#M4027 <HTML><HEAD></HEAD><BODY><P>Hello everyone, i have two database in sql server 2012. One is enzerprise geodatabase and another is a simple attribute datase. Now i need to shift all the tables of attribute db to geodatabase. I have tried in several ways without changing the Key fields, but i am facing some troubles regarding OBJECTID, Date data type and primary keys and foreign key are not generating. How I can shift all the tables data and schema together? </P><P></P><P>Already I have shifted tables but there are no pk and fk inside and I cannot avoiding making OBJECTID instead of ID fields (only if I just drag and drop table into geodatabase in arcgis- but those table has not any id will make a objectid). The other problem is no tables now has Date type. I know about datetime2 data type and now i am making newly inside geodatabase new tables, but is it the only solution?</P><P></P><P>Regards</P><P></P><P>Muqit</P></BODY></HTML> Mon, 25 Sep 2017 15:33:39 GMT Muqit_Zoarder 2017-09-25T15:33:39Z How I can shift non-spatial tables into enterperise geodatabase without changing primary key and foreignkeys in sql server? https://community.esri.com/t5/geodatabase-questions/how-i-can-shift-non-spatial-tables-into/m-p/826287#M4027 <HTML><HEAD></HEAD><BODY><P>Hello everyone, i have two database in sql server 2012. One is enzerprise geodatabase and another is a simple attribute datase. Now i need to shift all the tables of attribute db to geodatabase. I have tried in several ways without changing the Key fields, but i am facing some troubles regarding OBJECTID, Date data type and primary keys and foreign key are not generating. How I can shift all the tables data and schema together? </P><P></P><P>Already I have shifted tables but there are no pk and fk inside and I cannot avoiding making OBJECTID instead of ID fields (only if I just drag and drop table into geodatabase in arcgis- but those table has not any id will make a objectid). The other problem is no tables now has Date type. I know about datetime2 data type and now i am making newly inside geodatabase new tables, but is it the only solution?</P><P></P><P>Regards</P><P></P><P>Muqit</P></BODY></HTML> Mon, 25 Sep 2017 15:33:39 GMT https://community.esri.com/t5/geodatabase-questions/how-i-can-shift-non-spatial-tables-into/m-p/826287#M4027 Muqit_Zoarder 2017-09-25T15:33:39Z Re: How I can shift non-spatial tables into enterperise geodatabase without changing primary key and foreignkeys in sql server? https://community.esri.com/t5/geodatabase-questions/how-i-can-shift-non-spatial-tables-into/m-p/826288#M4028 <HTML><HEAD></HEAD><BODY><P>Try using 'Generate Scripts' followed by 'SQL Server Import and Export Wizard'...</P><P></P><P></P><P><A class="link-titled" href="http://williamsportwebdeveloper.com/cgi/wp/?p=153" title="http://williamsportwebdeveloper.com/cgi/wp/?p=153">SQL Server Data Import – How To Preserve Primary Keys and Identity Fields | Williamsport Web Developer Weblog</A>&nbsp;</P><P><A class="link-titled" href="https://stackoverflow.com/questions/10630888/how-to-import-tables-without-losing-indexes-and-keys-in-sql-server-2008" title="https://stackoverflow.com/questions/10630888/how-to-import-tables-without-losing-indexes-and-keys-in-sql-server-2008">How to import tables without losing indexes and keys in SQL Server 2008 - Stack Overflow</A>&nbsp;</P><P></P><P>This is actually a question for the Microsoft Forums more than an Esri forum...</P></BODY></HTML> Tue, 26 Sep 2017 09:36:29 GMT https://community.esri.com/t5/geodatabase-questions/how-i-can-shift-non-spatial-tables-into/m-p/826288#M4028 Asrujit_SenGupta 2017-09-26T09:36:29Z