Hello,
You could accomplish this with a third party tool such Redgate’s Data Compare:-
1) Script the DB Objects.
2) Create an empty DB from this script.
3) Compare the original DB to the new empty one and use the tool’s wizard to build a script to synchronise the data.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group