Re: Scripting a SQL database

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Robbe Morris [C# MVP] (info_at_turnkeytools.com)
Date: 02/19/05 

Date: Sat, 19 Feb 2005 18:42:44 -0500

Yes and yes.

You just use the connection.execute mysqlscriptstring

You've just got to connect to the database with an account
that has enough priviledge to run your script. 

-- 
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.mastervb.net/home/ng/forumvbcode/post10017013.aspx
http://www.eggheadcafe.com/articles/adonet_source_code_generator.asp
"Roland Hall" <nobody@nonononono.us> wrote in message 
news:%23J5RkctFFHA.3368@TK2MSFTNGP10.phx.gbl...
> 1. With Enterprise Manager what is required to have the script create the
> database, the SQL user and
> set their password?
> 2. Now that I have created the scripts, how do I execute them on a 
> different
> SQL server and can it be done from ASP?
>
>

Relevant Pages

  • Re: Scripting a SQL database
    ... You've just got to connect to the database with an account ... that has enough priviledge to run your script. ... With Enterprise Manager what is required to have the script create the ...
    (microsoft.public.inetserver.asp.db)
  • Scripting a SQL database
    ... With Enterprise Manager what is required to have the script create the ...
    (microsoft.public.sqlserver.server)
  • Scripting a SQL database
    ... With Enterprise Manager what is required to have the script create the ...
    (microsoft.public.inetserver.asp.db)
  • [NEWS] IBM Informix Web DataBlade Local Root by Design
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... that ease development of "intelligent", interactive, Web-enabled database ... person who has access to change the Perl script. ...
    (Securiteam)
  • RE: Need some MySQL query help...
    ... attempting to run the script: ... passed to the database. ... passwd entry to the current database entry. ...
    (perl.dbi.users)