Hi,
I am working on a project to script all database objects.The code
below works fine on my machine( windows XP ) and all the creates all
the db objects.
But I get an error message when I run it on a server( windows server
2003).
The first part of the code where I am executing sp_dboption and
getting all the options set for the database is working fine and it
creates the required script , but the piece of code using the SQLDMO
to get the database objects is where I am getting the error.
Thanks
Srini
Code Listing :-
public class ScriptAndCreateDataBases
{
public void ConnectAndScriptDatabases( SQLServer2Class server )
{
server.LoginSecure = true;
server.Connect( server.Name , "sa" , "" ) ;
- - - -
foreach (Database2 d in databases )
{
ConnectAndGetOptions( server , d.Name, options);
ScriptDBObjects dbobj = new ScriptDBObjects();
dbobj.Initialize(server, d);
}
- - - -
public class ScriptDBObjects
{
private SQLServer2Class m_sqlserver;
public void Initialize(SQLServer2Class ssc , Database2 db )
{
m_sqlserver = new SQLServer2Class() ;
m_sqlserver = ssc ;
---
}
private void ScriptDatabase(Database2 db , SQLServer2Class server
{
case Db_Types.Defaults:
s_transfer.CopyAllDefaults = true;
GenerateScript(s_transfer, workingFolder, db );
}
private void GenerateScript(TransferClass tc, string folder, Database2
db )
{
--erroring out db.ScriptTransfer(tc,
SQLDMO_XFRSCRIPTMODE_TYPE.SQLDMOXfrFile_SingleFile PerObject, folder);
}