Share

Script SQL Database DDL

Code

Programming Languages: C#

License: GNU General Public License (GPL)

Repositories

browse code, statistics, last commit on 2007-04-21 cvs -d:pserver:anonymous@script-sql-db.cvs.sourceforge.net:/cvsroot/script-sql-db login

cvs -z3 -d:pserver:anonymous@script-sql-db.cvs.sourceforge.net:/cvsroot/script-sql-db co -P modulename

Show:

What's happening?

  • Comment: Very slow -

    C51ic3 ytiuvkwtetbs, [url=http://gyvbldgqgviy.com/]gyvbldgqgviy[/url], [link=http://bhdgqffwczfz.com/]bhdgqffwczfz[/link], http://ledegxnqyomf.com/.

    2008-12-28 10:58:17 UTC by nobody

  • Option to exclude tool generated comment

    As was mentioned here:http://sourceforge.net/forum/forum.php?thread_id=2056016&forum_id=659841 the ability to use this tool to compare the schema of two different copies of the same database is hampered by the comment added by the tool.

    2008-07-18 14:23:05 UTC by nobody

  • SqlServer.Management.Smo.UnsupportedFeatureExceptiion

    While scripting database on MS SQL 2005 Express server, call to db.FullTextCatalogs throws exception of type Microsoft.SqlServer.Management.Smo.UnsupportedFeatureException.

    2008-03-14 20:41:11 UTC by nobody

  • ScriptAllDBs Error

    ScriptAllDBs.exe tries to call the ScriptDB executable but it doesn't seem to pass over the parameters that ScriptDB is expecting. Specifically it doesn't pass over the connection string information. This causes ScriptDB to fail. Is there a newer version?.

    2007-09-28 21:44:48 UTC by nobody

  • Comment: Very slow -

    Eugene, I am going to close this request out, but I will keep your comments in mind for the future. Your usage results -- 10,000 objects in 180 minutes -- is very close to what I would expect [about an object per second]. Although this may seem slow to you, keep in mind that the intended use of ScriptDB.exe is one-time-per-database. After initial script generation the database should be put...

    2007-04-29 12:33:31 UTC by rvsutherland

  • Comment: Very slow -

    Eugene, I am going to close this request out, but I will keep your comments in mind for the future. Your usage results -- 10,000 objects in 180 minutes -- is very close to what I would expect [about an object per second]. Although this may seem slow to you, keep in mind that the intended use of ScriptDB.exe is one-time-per-database. After initial script generation the database should be put...

    2007-04-29 12:33:15 UTC by rvsutherland

  • Comment: Very slow -

    Hi Richard, Thanks for reply. I'm still using the 1st version of sqlscriptdb ->so it is maybe a reason of 3 hours scripting (from sql agent local job) vs. ~15min (~10K objects) when I used scptxfr.exe (from ..MSSQL\Upgrade\..) ---- I will try your new version and let you know a result Thanks for nice utility, EugeneZ.

    2007-04-24 17:30:32 UTC by eugenezh

  • Comment: Very slow -

    Eugene, Please define "slow" for me [i.e., # objects scripted, elapsed time]. In my case, it generates about 1 object per second. If you are seeing anything significantly slower than this, it is probably due to network latency [at least one user who connected via VPN experienced this]. Thanks. Richard.

    2007-04-24 14:35:47 UTC by rvsutherland

  • Very slow -

    Hi, It needs to logless code that may speed up the scripting process Thanks, Eugene.

    2007-04-24 13:54:55 UTC by eugenezh

  • Script SQL Database DDL

    rvsutherland committed patchset 15 of module ScriptDB to the Script SQL Database DDL CVS repository, changing 3 files.

    2007-04-21 13:14:19 UTC by rvsutherland

Our Numbers