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 at 7:14 PM by JonLevin | Created: Jan 9, 2011 at 4:39 PM by JonLevin
When scripting foreign keys, the code is
if (!_CreateOnly)
{
so.ScriptDrops = so.IncludeIfNotExists = true;...
Id #18848 | Release:
None
| Updated: Feb 14 at 7:14 PM by AndreasPaulsson | Created: Sep 28, 2010 at 6:48 PM by AndreasPaulsson
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 at 7:14 PM by mikeymcc | Created: Sep 21, 2010 at 11:44 AM by mikeymcc
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: Feb 14 at 7:14 PM by DenisValeev | Created: Aug 27, 2010 at 10:49 AM by DenisValeev
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 at 7:14 PM by electricsk8 | Created: Aug 14, 2009 at 11:50 AM by greinerk
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 at 7:14 PM by AndreasPaulsson | Created: Nov 7, 2008 at 7:12 AM by AndreasPaulsson
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 at 7:14 PM by AndreasPaulsson | Created: Oct 9, 2008 at 7:03 AM by AndreasPaulsson
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 at 7:14 PM by cmatech | Created: Jul 23, 2008 at 3:59 AM by cmatech
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 at 7:14 PM by monsieur_arrie | Created: Jul 3, 2008 at 8:22 AM by Bard
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 at 7:14 PM by deany | Created: Aug 20, 2007 at 8:16 PM by mgantlett