ananda.murugesan (12/31/2012)
Source database - data is available for all tables...Generate Script source database and create newdatabase with another name and all other structure and PK, FK ,Identity every thing same as existing source database.
During export to new database base through export wizard -
One error was resolved(meta data validation) -> enable Identity insert,
Second error - above one(which is posted first), For the resolve this issues need to disable FK on table?
Yes you can Drop the FK constraint an do it. But, since the table had an FK, I am assuming that there was some parent child relationship between the PK Table and the FK Table. Since some foreign data would be inserted into the FK Table which is not present in the PK Table, if you drop the FK Constraint, then you might not be able to recreate the FK Constraint.
Instead of dropping the constraint and inserting the data I would rather find out the items that are causing the error on insertion.