generating database schema thru command line

In informix there is a tool called dbschema which can generate a sql file
to create a database fully. I am aware that in the Enterprise Manager one
can do it easily. However i need the same functionality via command line
so that we can plug the command in the build tool.

TIA

EM does it using sql-dmo, take a look a this api.

http://msdn.microsoft.com/library/d...r />
_11rm.asp


AMB

"rkusenet" wrote:

> In informix there is a tool called dbschema which can generate a sql file
> to create a database fully. I am aware that in the Enterprise Manager one
> can do it easily. However i need the same functionality via command line
> so that we can plug the command in the build tool.
>
> TIA
>

You can also invoke the functionality of the EM wizards using SQL-NS API.
Look for SQL-NS constant  SQLNS_CmdID_GENERATE
_SCRIPTS and SQL-NS method
ExecuteCommandByID.

http://msdn.microsoft.com/library/d...8z5
.asp


AMB


"Alejandro Mesa" wrote:

> EM does it using sql-dmo, take a look a this api.
>
> http://msdn.microsoft.com/library/d.../>
_g_11rm.asp
>
>
> AMB
>
> "rkusenet" wrote:
> 

I've listed some options here:
http://www.karaszi.com/SQLServer/ i...ript
.asp

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/


"rkusenet" <usenet.rk@gmail.com> wrote in message  news:3d9nmvF6rhk35U1
@individual.net...[co
lor=darkred]
> In informix there is a tool called dbschema which can generate a sql file 
to create a database
> fully. I am aware that in the Enterprise Manager one can do it easily. How
ever i need the same
> functionality via command line
> so that we can plug the command in the build tool.
>
> TIA[/color]

Tibor,

Does SCPTXFR.EXE come with SQL Server 2000 also?


AMB

"rkusenet" wrote:

> In informix there is a tool called dbschema which can generate a sql file
> to create a database fully. I am aware that in the Enterprise Manager one
> can do it easily. However i need the same functionality via command line
> so that we can plug the command in the build tool.
>
> TIA
>

you talked about doing a build, I'm wondering if this is part of your daily
or at least scheduled build process?

You may want to save yourself all the time and effort of re-inventing the
wheel...

http://www.dbghost.com

Build, compare, deploy.

"rkusenet" wrote:

> In informix there is a tool called dbschema which can generate a sql file
> to create a database fully. I am aware that in the Enterprise Manager one
> can do it easily. However i need the same functionality via command line
> so that we can plug the command in the build tool.
>
> TIA
>

> Does SCPTXFR.EXE come with SQL Server 2000 also?

Seems so. In the upgrade directory :-).
C:\Program Files\Microsoft SQL  Server\MSSQL\Upgrade

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/


"Alejandro Mesa" < AlejandroMesa@discus
sions.microsoft.com> wrote in message
news:649EF740-EF67-4618-A363- B765823989DC@microso
ft.com...
> Tibor,
>
> Does SCPTXFR.EXE come with SQL Server 2000 also?
>
>
> AMB
>
> "rkusenet" wrote:
> 

Thanks!!!

"Tibor Karaszi" wrote:
 
>
> Seems so. In the upgrade directory :-).
> C:\Program Files\Microsoft SQL  Server\MSSQL\Upgrade

> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> "Alejandro Mesa" < AlejandroMesa@discus
sions.microsoft.com> wrote in messag
e
> news:649EF740-EF67-4618-A363- B765823989DC@microso
ft.com... 
>
>
>