Re: Creating/Populating DB
| From: | colbey at dreamwerx dot net | Date: | Wed, 18 Jun 2003 16:24:47 +0000 |
| Subject: | Re: Creating/Populating DB | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-28719@lists.php.net to get a copy of this message | ||
This should be as simple as a PHP script that opens a connection to the
destination server (with rights to do all actions you mentioned)..
Opens a text file with all the SQL commands you want to issue, and starts
firing them off at the server 1 by 1...
Once you create the database, you need to make sure:
- might have to grant rights to it
- change it to the current database for that connection, or disconnect
and reconnect to desired database.
On Tue, 17 Jun 2003, Gerard Samuel wrote:
> Im trying to make an install script that would run under MSSQL.
> I could make it either create a database or populate a database.
> I can't seem to do both.
> Has anyone been able to create and populate a MSSQL database via php in
> one shot??
>
> Thanks
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>