Bug in Export from DB to Import to DB - by jladd

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 811851 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 12/17/2013 6:18:44 PM
Access Restriction Public

Description

Using the ExportDB to ImportDB fuction
TableC has :

ColumnCID, ColumnCName

AND
TableB has:

ColumnBID, ColumnCID, ColumnBName

Now this include if TableB has a foreign key constraint on ColumnCID which maps to TableC.ColumnCID.   

Now if you were to go threw the GUI and do this it will fail  cause its doing the export to import alphabetically based off table name rather than determining all the FK Relationships are and then doing the inserts. 
Sign in to post a comment.
Posted by Microsoft on 12/26/2013 at 2:22 PM
Once we get T-SQL scripts and step by step directions for us to reproduce this issue in our environment, we shall investigate this issue
Posted by Sethu Srinivasan on 12/23/2013 at 8:47 AM
Please send us T-SQL Scripts to created these table and constraints. if you can send us detailed instructions on hot to reproduce this issue, we can investigate this issue

Thanks
Sethu Srinivasan [MSFT]
SQL Server
Posted by Sethu Srinivasan on 12/18/2013 at 9:42 PM
Also can you please script out your tables and foreign key constraints and attach to this connect item, it would be very helpful for us to investigate this issue

Thanks
Sethu Srinivasan [MSFT]
SQL Server
Posted by Sethu Srinivasan on 12/18/2013 at 11:59 AM
Can you please add more details steps on how you did Export / Import?. Was it through SSMS?

Also, if you can attach screenshots, any additional information to this connect feedback, it would help us investigate this issue

Thanks
Sethu Srinivasan [MSFT]
SQL Server