471,318 Members | 2,026 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,318 software developers and data experts.

SQL Server scripting

hi

I wanted to know, is it possible to write .net code to generate
database script?

For example, I will give table name, .net code should generate
script from the database.

thanks
kalyan

Jul 21 '05 #1
2 1057
Sure. All you need to go is get the metadata what is in the sysX tables and
then generate your scripts accordingly.

"Kalyan" <Ka****@discussions.microsoft.com> wrote in message
news:27**********************************@microsof t.com...
hi

I wanted to know, is it possible to write .net code to generate
database script?

For example, I will give table name, .net code should generate
script from the database.

thanks
kalyan

Jul 21 '05 #2
Sysobjects and syscolumns are key tables. But I guess there's not automated
tool available in .net.

"Peter Rilling" wrote:
Sure. All you need to go is get the metadata what is in the sysX tables and
then generate your scripts accordingly.

"Kalyan" <Ka****@discussions.microsoft.com> wrote in message
news:27**********************************@microsof t.com...
hi

I wanted to know, is it possible to write .net code to generate
database script?

For example, I will give table name, .net code should generate
script from the database.

thanks
kalyan


Jul 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Hernán Castelo | last post: by
5 posts views Thread by Ankur | last post: by
8 posts views Thread by Nagarajan | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.