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