The client requires .NET 2.0, but does not require SQL Server on the client -- neither SQL 2000 nor SQL 2005. It will script out databases from either/both SQL versions located locally or remotely. The user must have db_owner [or sysadmin] privileges for the database being scripted.
Hope this helps.
Richard
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have .NET 2.0 and SQL 2000 installed, but I get this:
C:\>scriptdb
Unhandled Exception: System.IO.FileNotFoundException: Could not load file or ass
embly 'Microsoft.SqlServer.ConnectionInfo, Version=9.0.242.0, Culture=neutral, P
ublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot fi
nd the file specified.
File name: 'Microsoft.SqlServer.ConnectionInfo, Version=9.0.242.0, Culture=neutr
al, PublicKeyToken=89845dcd8080cc91'
at ScriptDB.ScriptDB.Main(String[] args)
=== Pre-bind state information ===
LOG: User = DOMAIN\user (changed fo rthis posting...)
LOG: DisplayName = Microsoft.SqlServer.ConnectionInfo, Version=9.0.242.0, Cultur
e=neutral, PublicKeyToken=89845dcd8080cc91
(Fully-specified)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/80/Tools/BINN/
LOG: Initial PrivatePath = NULL
Calling assembly : ScriptDB, Version=1.1.0.0, Culture=neutral, PublicKeyToken=nu
ll.
===
LOG: This bind starts in default load context.
LOG: No application configuration file found.
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2
.0.50727\config\machine.config.
LOG: Post-policy reference: Microsoft.SqlServer.ConnectionInfo, Version=9.0.242.
0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Serve
r/80/Tools/BINN/Microsoft.SqlServer.ConnectionInfo.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Serve
r/80/Tools/BINN/Microsoft.SqlServer.ConnectionInfo/Microsoft.SqlServer.Connectio
nInfo.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Serve
r/80/Tools/BINN/Microsoft.SqlServer.ConnectionInfo.EXE.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Serve
r/80/Tools/BINN/Microsoft.SqlServer.ConnectionInfo/Microsoft.SqlServer.Connectio
nInfo.EXE.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
We're experiencing the same problem here with SQL2000 SP4, even when installing "Microsoft .NET Framework Version 2.0 Redistributable Package (x86)". Tried this from 5 different database boxes - 2 were SQL 2005, 3 were SQL 2000 SP4. I got this error on every SQL 2000 box, but no issues at all with both of the SQL 2005 boxes.
Your thoughts / ideas would be appreciated. Finding this tool so simple and yet so useful, cheers for the work you've done to get this to where it is, including the new ability to script all dbs. :)
Nathan
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Sorry, I just updated the release notes today but forgot to add the revision to this thread. See below
and respond here whether this fixes your problem.
Thanks.
Richard
Requires .NET 2.0. If you have installed the SQL Server 2005
client tools, you have all that is needed. If you have not,
do the following:
Got it working on SQL2000. Just a note that in addition to "Microsoft SQL Server Native Client" and
"Microsoft SQL Server 2005 Management Objects Collection", "MSXML 6.0" was also required and can be found at:
"A tool which scripts out SQL Server 2000/2005 database objects"
Should this work with just SQL 2000 installed?
Thanks!
The client requires .NET 2.0, but does not require SQL Server on the client -- neither SQL 2000 nor SQL 2005. It will script out databases from either/both SQL versions located locally or remotely. The user must have db_owner [or sysadmin] privileges for the database being scripted.
Hope this helps.
Richard
I have .NET 2.0 and SQL 2000 installed, but I get this:
C:\>scriptdb
Unhandled Exception: System.IO.FileNotFoundException: Could not load file or ass
embly 'Microsoft.SqlServer.ConnectionInfo, Version=9.0.242.0, Culture=neutral, P
ublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot fi
nd the file specified.
File name: 'Microsoft.SqlServer.ConnectionInfo, Version=9.0.242.0, Culture=neutr
al, PublicKeyToken=89845dcd8080cc91'
at ScriptDB.ScriptDB.Main(String[] args)
=== Pre-bind state information ===
LOG: User = DOMAIN\user (changed fo rthis posting...)
LOG: DisplayName = Microsoft.SqlServer.ConnectionInfo, Version=9.0.242.0, Cultur
e=neutral, PublicKeyToken=89845dcd8080cc91
(Fully-specified)
LOG: Appbase = file:///C:/Program Files/Microsoft SQL Server/80/Tools/BINN/
LOG: Initial PrivatePath = NULL
Calling assembly : ScriptDB, Version=1.1.0.0, Culture=neutral, PublicKeyToken=nu
ll.
===
LOG: This bind starts in default load context.
LOG: No application configuration file found.
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2
.0.50727\config\machine.config.
LOG: Post-policy reference: Microsoft.SqlServer.ConnectionInfo, Version=9.0.242.
0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Serve
r/80/Tools/BINN/Microsoft.SqlServer.ConnectionInfo.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Serve
r/80/Tools/BINN/Microsoft.SqlServer.ConnectionInfo/Microsoft.SqlServer.Connectio
nInfo.DLL.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Serve
r/80/Tools/BINN/Microsoft.SqlServer.ConnectionInfo.EXE.
LOG: Attempting download of new URL file:///C:/Program Files/Microsoft SQL Serve
r/80/Tools/BINN/Microsoft.SqlServer.ConnectionInfo/Microsoft.SqlServer.Connectio
nInfo.EXE.
This says that you are missing "C:/Program Files/Microsoft SQL Server/80/Tools/BINN/Microsoft.SqlServer.ConnectionInfo.DLL".
Do you have the "Microsoft .NET Framework Version 2.0 Redistributable Package (x86)"? See:
http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&DisplayLang=en
Let me know if this solves the issue.
Thanks.
Richard
Hi Richard,
We're experiencing the same problem here with SQL2000 SP4, even when installing "Microsoft .NET Framework Version 2.0 Redistributable Package (x86)". Tried this from 5 different database boxes - 2 were SQL 2005, 3 were SQL 2000 SP4. I got this error on every SQL 2000 box, but no issues at all with both of the SQL 2005 boxes.
Your thoughts / ideas would be appreciated. Finding this tool so simple and yet so useful, cheers for the work you've done to get this to where it is, including the new ability to script all dbs. :)
Nathan
Sorry, I just updated the release notes today but forgot to add the revision to this thread. See below
and respond here whether this fixes your problem.
Thanks.
Richard
Requires .NET 2.0. If you have installed the SQL Server 2005
client tools, you have all that is needed. If you have not,
do the following:
1. Download and install the "Microsoft .NET Framework Version
2.0 Redistributable Package (x86)" from this site:
http://www.microsoft.com/downloads/details.aspx?FamilyID=0856EACB-4362-4B0D-8EDD-AAB15C5E04F5&displaylang=en
2. Go to the following site, scroll down and download and
install both the "Microsoft SQL Server Native Client" and
"Microsoft SQL Server 2005 Management Objects Collection"
http://www.microsoft.com/downloads/details.aspx?familyid=50B97994-8453-4998-8226-FA42EC403D17&displaylang=en
Thanks Richard!
Got it working on SQL2000. Just a note that in addition to "Microsoft SQL Server Native Client" and
"Microsoft SQL Server 2005 Management Objects Collection", "MSXML 6.0" was also required and can be found at:
http://www.microsoft.com/downloads/details.aspx?familyid=50B97994-8453-4998-8226-FA42EC403D17&displaylang=en
Nathan
Wonderful!!
I have updated the Release Notes to reflect the "MSXML 6.0" as being needed as well.
Much thanks.
Richard