Forums Últimos mensajes - Powered by IBM
 

Ayuda al instalar una aplicacion en linux >> sql server

15/10/2005 - 14:54 por Miguel | Informe spam
Hola,

No tengo idea de como funciona SQL Server, estoy intentando instalar una
aplicación en linux que requiere un servidor de bbdd y he optado por un sql
server 2000 standard. La aplicación es webcalendar y el archivo que explica
como se instala me indica lo siguiente :
Database Setup
There are three steps in setting up the database:

1.. Creating the database
2.. Creating the user
3.. Creating the required tables
Follow the steps outlined below for the database you are using. When
complete, a single user account will be created with the login "admin" and
password "admin", which you are encouraged to use to create your own
account.

Note: In the examples below, text in bold represents text that you must type
in.

Security: The default values for database, login, and password (intranet,
webcalendar, and webcal01) are for demonstration purposes only and should
never be used in a production environment.

MySQL
The following will create a database named "intranet".

mysqladmin create intranetNext, create the database user account that will
be used to access the database.

mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO webcalendar@localhost
IDENTIFIED BY 'webcal01' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> QUITIf you will be accessing MySQL from a different machine than the
one running the web server, repeat the command above and replace 'localhost'
with the hostname of the other machine.

Create the calendar tables using the supplied tables-mysql.sql file:

mysql intranet < tables-mysql.sqlIn the above example, "intranet" is the
name of your database.

Note: If you are using phpMyAdmin to manage your MySQL database, follow the
instructions in Appendix A.

Oracle
The following will create a tablespace named "webcalendar". From the command
line, startup sqlplus and issue the following command:

sqlplus
SQL> CREATE TABLESPACE webcalendar
DATAFILE 'webcalendar.dat' SIZE 10M
AUTOEXTEND ON NEXT 10M MAXSIZE 40M;Next, create the database user account
that will be used to access the database.

sqlplus
SQL> CREATE USER webcalendar IDENTIFIED BY webcal01
DEFAULT TABLESPACE webcalendar;
SQL> GRANT dba TO webcalendar;
SQL> quitCreate the calendar tables using the supplied tables-oracle.sql
file:

sqlplus webcalendar/webcal01
SQL> @tables-oracle;
SQL> quitPostgreSQL
The following will create a database named "webcalendar". From the command
line, startup psql and issue the following command:

create database webcalendar;
\c webcalendar
\i tables-postgres.sql
\qInterbase
The following will create a database named "WEBCAL.gdb". From the command
line, startup usql and issue the following command:

CREATE DATABASE 'WEBCAL.gdb';Create the calendar tables using the supplied
tables-ibase.sql file:

isql
connect /path/WEBCAL.gdb;
input path/table-ibase.sql;ODBC
Setup will depend on which database you are using. When it comes time to
create the tables, the tables-postgres.sql file should work for most
databases.

MSSQL
Create a database, intranet, and add a user, webcalendar, to access this
database. The user should be granted public, db_datareader, and
db_datawriter privileges. Open SQL Query Analyzer then open the file
tables-postgres.sql. Make sure you have identified intranet as the target
database and Execute the contents of the sql file.



alguien me puede ayudar a solucionar mi pobrema e indicarme que
instrucciones en transac sql tengo que realizar

gracias de antemano



Saludos

Miguel

MCSE
 

Leer las respuestas

#1 Maxi \(MVP SQL\)
15/10/2005 - 19:23 | Informe spam
Hola miguel, todo eso lo puedes hacer desde el Admin corporativo


-
MS-MVP SQL SERVER
"Miguel" escribió en el mensaje
news:
Hola,

No tengo idea de como funciona SQL Server, estoy intentando instalar una
aplicación en linux que requiere un servidor de bbdd y he optado por un
sql
server 2000 standard. La aplicación es webcalendar y el archivo que
explica
como se instala me indica lo siguiente :
Database Setup
There are three steps in setting up the database:

1.. Creating the database
2.. Creating the user
3.. Creating the required tables
Follow the steps outlined below for the database you are using. When
complete, a single user account will be created with the login "admin" and
password "admin", which you are encouraged to use to create your own
account.

Note: In the examples below, text in bold represents text that you must
type in.

Security: The default values for database, login, and password (intranet,
webcalendar, and webcal01) are for demonstration purposes only and should
never be used in a production environment.

MySQL
The following will create a database named "intranet".

mysqladmin create intranetNext, create the database user account that will
be used to access the database.

mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO
IDENTIFIED BY 'webcal01' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> QUITIf you will be accessing MySQL from a different machine than
the one running the web server, repeat the command above and replace
'localhost' with the hostname of the other machine.

Create the calendar tables using the supplied tables-mysql.sql file:

mysql intranet < tables-mysql.sqlIn the above example, "intranet" is the
name of your database.

Note: If you are using phpMyAdmin to manage your MySQL database, follow
the instructions in Appendix A.

Oracle
The following will create a tablespace named "webcalendar". From the
command line, startup sqlplus and issue the following command:

sqlplus
SQL> CREATE TABLESPACE webcalendar
DATAFILE 'webcalendar.dat' SIZE 10M
AUTOEXTEND ON NEXT 10M MAXSIZE 40M;Next, create the database user account
that will be used to access the database.

sqlplus
SQL> CREATE USER webcalendar IDENTIFIED BY webcal01
DEFAULT TABLESPACE webcalendar;
SQL> GRANT dba TO webcalendar;
SQL> quitCreate the calendar tables using the supplied tables-oracle.sql
file:

sqlplus webcalendar/webcal01
SQL> @tables-oracle;
SQL> quitPostgreSQL
The following will create a database named "webcalendar". From the command
line, startup psql and issue the following command:

create database webcalendar;
\c webcalendar
\i tables-postgres.sql
\qInterbase
The following will create a database named "WEBCAL.gdb". From the command
line, startup usql and issue the following command:

CREATE DATABASE 'WEBCAL.gdb';Create the calendar tables using the supplied
tables-ibase.sql file:

isql
connect /path/WEBCAL.gdb;
input path/table-ibase.sql;ODBC
Setup will depend on which database you are using. When it comes time to
create the tables, the tables-postgres.sql file should work for most
databases.

MSSQL
Create a database, intranet, and add a user, webcalendar, to access this
database. The user should be granted public, db_datareader, and
db_datawriter privileges. Open SQL Query Analyzer then open the file
tables-postgres.sql. Make sure you have identified intranet as the target
database and Execute the contents of the sql file.



alguien me puede ayudar a solucionar mi pobrema e indicarme que
instrucciones en transac sql tengo que realizar

gracias de antemano



Saludos

Miguel

MCSE

Preguntas similares