# Generate DDL Extract for SQL2K8 databases **URL:** \ **Category:** Toad for SQL Server\ **Created:** [July 15, 2013, 6:57am UTC](https://forums.toadworld.com/t/generate-ddl-extract-for-sql2k8-databases/25762 "2013-07-15T06:57:23Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![joe\_blakistone](https://avatars.discourse-cdn.com/v4/letter/j/b9e5f3/32.png) [@joe\_blakistone](https://forums.toadworld.com/u/joe_blakistone)\ **Post date:** [July 15, 2013, 6:57am UTC](https://forums.toadworld.com/t/generate-ddl-extract-for-sql2k8-databases/25762/1 "2013-07-15T06:57:23Z")
I am trying to generate the complete schema DDL for a set of SQL2K8 databases using TOAD for SQL Server 6.0.0.323. I have all the options checked to export everything. Some are successful, however some are not. The ones that are not fail with the error “Can’t find current parent for object!”. I can’t find any additional information other than that generic error message Has anyone experienced this issue? Any recommendations on what I can do to resolve this? ---
**Author:** ![Alexander.Maximov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alexander.maximov/32/114_2.png) [@Alexander.Maximov](https://forums.toadworld.com/u/Alexander.Maximov)\ **Post date:** [July 15, 2013, 9:27am UTC](https://forums.toadworld.com/t/generate-ddl-extract-for-sql2k8-databases/25762/2 "2013-07-15T09:27:11Z")
Hi, can you please send us Schema Compare snapshot file so we can take a look? You can create it from corresponding context menu item on a database. You can send it to me directly - see email in profile. ---
**Author:** ![Alexander.Maximov](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/alexander.maximov/32/114_2.png) [@Alexander.Maximov](https://forums.toadworld.com/u/Alexander.Maximov)\ **Post date:** [July 17, 2013, 2:34am UTC](https://forums.toadworld.com/t/generate-ddl-extract-for-sql2k8-databases/25762/3 "2013-07-17T02:34:22Z")
Thanks a lot for the snapshot! We identified and fixed the issue. Fix will be available in the next 6.1 beta build. The reason was in Synonyms - for right now you can remove them from the scope to be able generate script for the rest items. ---
**Author:** ![joe\_blakistone](https://avatars.discourse-cdn.com/v4/letter/j/b9e5f3/32.png) [@joe\_blakistone](https://forums.toadworld.com/u/joe_blakistone)\ **Post date:** [July 17, 2013, 4:30am UTC](https://forums.toadworld.com/t/generate-ddl-extract-for-sql2k8-databases/25762/4 "2013-07-17T04:30:30Z")
Awesome. Thank you very much! **From:** Alexander.Maximov [[mailto:bounce-AlexanderMaximov@toadworld.com](mailto:bounce-AlexanderMaximov@toadworld.com)] **Sent:** Wednesday, July 17, 2013 5:35 AM **To:** [toadss@toadworld.com](mailto:toadss@toadworld.com) **Subject:** RE: [Toad for SQL Server - Discussion Forum] Generate DDL Extract for SQL2K8 databases **[RE: Generate DDL Extract for SQL2K8 databases](http://gyk.r.mailjet.com/redirect/v4y0hyy13k7yh2m9m3n6b4/www.toadworld.com/products/toad-for-sql-server/f/14/p/19839/39989.aspx#39989)** Reply by Alexander.Maximov Thanks a lot for the snapshot! We identified and fixed the issue. Fix will be available in the next 6.1 beta build. The reason was in Synonyms - for right now you can remove them from the scope to be able generate script for the rest items. To reply, please reply-all to this email. [Stop receiving emails](http://gyk.r.mailjet.com/redirect/zox7h7swqb9zjk15w37fxm/www.toadworld.com/products/toad-for-sql-server/f/14/t/19839.aspx?subscribe=false) on this subject. Or [Unsubscribe from Toad for SQL Server - General](http://gyk.r.mailjet.com/redirect/hxg3hg3szxoy3rhwlkn0j2/www.toadworld.com/products/toad-for-sql-server/f/14.aspx?subscribe=false) notifications altogether. Toad for SQL Server - Discussion Forum [Flag](http://gyk.r.mailjet.com/redirect/h8fnh01dc5ltqcctfdxnkn/www.toadworld.com/products/toad-for-sql-server/f/14/p/19839/39989.aspx?AbuseContentId=44ced02c-593e-49a3-acdb-2f7b8a71128b&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. ![](http://gyk.r.mailjet.com/dc6f70ca/46WuxH.gif) ---
**Author:** ![Cindy.Sang](https://avatars.discourse-cdn.com/v4/letter/c/edb3f5/32.png) [@Cindy.Sang](https://forums.toadworld.com/u/Cindy.Sang)\ **Post date:** [September 12, 2013, 2:25am UTC](https://forums.toadworld.com/t/generate-ddl-extract-for-sql2k8-databases/25762/5 "2013-09-12T02:25:06Z")
Hi, Could you please send us Schema Compare snapshot again? we have fixed this issue, but need to do validation before post new version, unfortunately, previous file you sent to us is not available for some reason, please send to me again if it is convenient: [cindy.sang@quest.com](mailto:cindy.sang@quest.com), thanks for your support ---
**Author:** ![joe\_blakistone](https://avatars.discourse-cdn.com/v4/letter/j/b9e5f3/32.png) [@joe\_blakistone](https://forums.toadworld.com/u/joe_blakistone)\ **Post date:** [September 12, 2013, 5:52am UTC](https://forums.toadworld.com/t/generate-ddl-extract-for-sql2k8-databases/25762/6 "2013-09-12T05:52:21Z")
I have sent it to your internal email address, thank you very much. ---
**Author:** ![Cindy.Sang](https://avatars.discourse-cdn.com/v4/letter/c/edb3f5/32.png) [@Cindy.Sang](https://forums.toadworld.com/u/Cindy.Sang)\ **Post date:** [September 12, 2013, 11:31pm UTC](https://forums.toadworld.com/t/generate-ddl-extract-for-sql2k8-databases/25762/7 "2013-09-12T23:31:44Z")
I have received it, thank you very much