Error script a SQL 2008 database that contains User Defined Table Types

I have a SQL 2008 database that contains User Defined Table Types. ScriptDB is aborting with the following output (no problem with SQL 2008 databases that don't contain UDTTs):     C:\APP_RDM_Scrip...

Id #19634 | Release: None | Updated: Feb 14, 2013 at 8:14 PM by JonLevin | Created: Jan 9, 2011 at 5:39 PM by JonLevin

ForeignKeys are always scripted as Drops

When scripting foreign keys, the code is   if (!_CreateOnly) { so.ScriptDrops = so.IncludeIfNotExists = true;...

Id #18848 | Release: None | Updated: Feb 14, 2013 at 8:14 PM by AndreasPaulsson | Created: Sep 28, 2010 at 7:48 PM by AndreasPaulsson

Exception when output to single file

I get an exception when I use the -filename option. This is when you want all script to go to the same file.   After looking though the code it seems that GetStreamWriter has an assumption. The cod...

Id #18797 | Release: None | Updated: Feb 14, 2013 at 8:14 PM by mikeymcc | Created: Sep 21, 2010 at 12:44 PM by mikeymcc

Prepend schema name to filenames

In order to script files with the same name but different schemata we need to create files with full names.   The following patch resolves exactly that.

Id #18603 | Release: None | Updated: Oct 16, 2013 at 8:42 AM by huestel | Created: Aug 27, 2010 at 11:49 AM by DenisValeev

exclude objects based on a wildcard

is there an option to exclude objects based on a wildcard? for instance, i have database where 75% of the database objects are dynamically created, and do not need to be scripted. i'd like to be ...

Id #13881 | Release: None | Updated: Feb 14, 2013 at 8:14 PM by electricsk8 | Created: Aug 14, 2009 at 12:50 PM by greinerk

Add scripting of full text catalog and indexes (completed).

It would be ince it ScriptDB also could script full text catalog and indexes.   And since I need it, I implemented it :-). See attached DatabaseScripter.cs.   /Andreas

Id #11580 | Release: None | Updated: Feb 14, 2013 at 8:14 PM by AndreasPaulsson | Created: Nov 7, 2008 at 8:12 AM by AndreasPaulsson

Make it possible to change name of database folder.

In one of my projects, the databases are named different with different prefixes in the different environments (integration, accpeptance, production), but I want to keep the scripts in SVN (that is...

Id #11427 | Release: None | Updated: Feb 14, 2013 at 8:14 PM by AndreasPaulsson | Created: Oct 9, 2008 at 8:03 AM by AndreasPaulsson

Stripped off schemas

While it does script the schemas - it needs to create a folder or leave the schema name in front of the table filename. Example:   Schema1.Table1 Schema2.Table1   These are 2 different tables, the ...

Id #10737 | Release: None | Updated: Feb 14, 2013 at 8:14 PM by cmatech | Created: Jul 23, 2008 at 4:59 AM by cmatech

invalid path

The working directory does not exist when bcp.exe is running for the first table. Main() is catches an invalid path exception and ScriptDb.exe fails to complete.

Id #10418 | Release: None | Updated: Feb 14, 2013 at 8:14 PM by monsieur_arrie | Created: Jul 3, 2008 at 9:22 AM by Bard

Dependencies

Great tool. I want to use it for database versioning. I tried the rebuild db bat script but it fails because of dependant objects not being created ahead of time.   Do you have any suggestions?  ...

Id #5167 | Release: None | Updated: Feb 14, 2013 at 8:14 PM by deany | Created: Aug 20, 2007 at 9:16 PM by mgantlett

  • 1-10 of 10 Work Items
    • Previous
    • 1
    • Next
    • Showing
    • 10
    • Work Items