1
Vote

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_ScriptD...

Id #19634 | Release: None | Updated: Jan 9 2011 at 4:39 PM by JonLevin | Created: Jan 9 2011 at 4:39 PM by JonLevin

1
Vote

ForeignKeys are always scripted as Drops

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

Id #18848 | Release: None | Updated: Sep 28 2010 at 9:33 PM by AndreasPaulsson | Created: Sep 28 2010 at 6:48 PM by AndreasPaulsson

1
Vote

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 code...

Id #18797 | Release: None | Updated: Sep 21 2010 at 11:44 AM by mikeymcc | Created: Sep 21 2010 at 11:44 AM by mikeymcc

1
Vote

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: Aug 27 2010 at 10:57 AM by DenisValeev | Created: Aug 27 2010 at 10:49 AM by DenisValeev

1
Vote

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: Aug 14 2009 at 3:08 PM by electricsk8 | Created: Aug 14 2009 at 11:50 AM by greinerk

1
Vote

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: Nov 7 2008 at 7:12 AM by AndreasPaulsson | Created: Nov 7 2008 at 7:12 AM by AndreasPaulsson

1
Vote

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: Oct 9 2008 at 7:03 AM by AndreasPaulsson | Created: Oct 9 2008 at 7:03 AM by AndreasPaulsson

1
Vote

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 sc...

Id #10737 | Release: None | Updated: Jul 23 2008 at 4:29 AM by cmatech | Created: Jul 23 2008 at 3:59 AM by cmatech

3
Vote

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: Nov 24 2008 at 5:23 PM by monsieur_arrie | Created: Jul 3 2008 at 8:22 AM by Bard

2
Vote

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? T...

Id #5167 | Release: None | Updated: Nov 7 2008 at 7:10 AM by AndreasPaulsson | Created: Aug 20 2007 at 8:16 PM by mgantlett

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