Friday, March 9, 2012

generate SQL Script

Hello,
Is possible to generate SQL script which included all schemas and data as
well...
I use "Generate SQL Script" can only generate table schema, store proc,..
but no data inside..
but i believe that it should have a method bcoz some partner will send these
script to me to import db/table
any ideas... Thanks in advanced.http://www.karaszi.com/SQLServer/info_generate_script.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"beachboy" <stanley@.javacatz.com> wrote in message news:%23IW$5HthGHA.1864@.TK2MSFTNGP02.phx.gbl...
> Hello,
> Is possible to generate SQL script which included all schemas and data as
> well...
> I use "Generate SQL Script" can only generate table schema, store proc,..
> but no data inside..
> but i believe that it should have a method bcoz some partner will send these
> script to me to import db/table
> any ideas... Thanks in advanced.
>|||Thank you for your reply.
Is must to use third-party application? Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> ?
news:%23jRpxJthGHA.3756@.TK2MSFTNGP02.phx.gbl ?...
> http://www.karaszi.com/SQLServer/info_generate_script.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "beachboy" <stanley@.javacatz.com> wrote in message
news:%23IW$5HthGHA.1864@.TK2MSFTNGP02.phx.gbl...
> > Hello,
> >
> > Is possible to generate SQL script which included all schemas and data
as
> > well...
> >
> > I use "Generate SQL Script" can only generate table schema, store
proc,..
> > but no data inside..
> > but i believe that it should have a method bcoz some partner will send
these
> > script to me to import db/table
> >
> > any ideas... Thanks in advanced.
> >
> >|||> Is must to use third-party application?
Yes, there's no built-in support for generating ddl and data.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"beachboy" <stanley@.javacatz.com> wrote in message news:%233u%23LOthGHA.4504@.TK2MSFTNGP03.phx.gbl...
> Thank you for your reply.
> Is must to use third-party application? Thanks.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> ?
> news:%23jRpxJthGHA.3756@.TK2MSFTNGP02.phx.gbl ?...
>> http://www.karaszi.com/SQLServer/info_generate_script.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "beachboy" <stanley@.javacatz.com> wrote in message
> news:%23IW$5HthGHA.1864@.TK2MSFTNGP02.phx.gbl...
>> > Hello,
>> >
>> > Is possible to generate SQL script which included all schemas and data
> as
>> > well...
>> >
>> > I use "Generate SQL Script" can only generate table schema, store
> proc,..
>> > but no data inside..
>> > but i believe that it should have a method bcoz some partner will send
> these
>> > script to me to import db/table
>> >
>> > any ideas... Thanks in advanced.
>> >
>> >
>

No comments:

Post a Comment