| Author |
generating database schema thru command line
|
|
| rkusenet 2005-04-27, 11:23 am |
| 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
| |
| Alejandro Mesa 2005-04-27, 11:23 am |
| EM does it using sql-dmo, take a look a this api.
http://msdn.microsoft.com/library/d...ef_m_g_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
>
| |
|
|
|
|
| Alejandro Mesa 2005-04-27, 8:23 pm |
| 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
>
| |
| mark baekdal 2005-04-28, 7:23 am |
| 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
>
| |
| Tibor Karaszi 2005-04-28, 7:23 am |
| > 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...[color=darkred]
> Tibor,
>
> Does SCPTXFR.EXE come with SQL Server 2000 also?
>
>
> AMB
>
> "rkusenet" wrote:
>
| |
| Alejandro Mesa 2005-04-28, 7:23 am |
| 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 message
> news:649EF740-EF67-4618-A363- B765823989DC@microso
ft.com...
>
>
>
|
|
|
|