Products
Ozeki 10
Apps
Chat
SMS Gateway
Quick Start Guide
SMS with Client Software
HTTP API
SMS from/to Database
MSSQL Express
MSSQL Express Installation
Create Database
Command prompt
Configure Database User
Test Message
Oracle SMS
MySQL SMS
PostgreSQL
SAP SQL Anywhere
Microsoft Access
PHP SMS API
Solutions
C# SMS API
VB.NET SMS API
SQL Logging
System Database
Robot Controller
Softphone
PBX
Connections
Installation guide
Terms and Definitions
HTTP API
SMS
Bulk Messenger
Cluster
Developer tools
Robots
Hardware
Installer
Technology
Company


Ozeki 10 - SMS Gateway server software
MSSQL Express Installation MSSQL Express Installation | Command prompt Command prompt

Send SMS from MSSQL Express (part 2/4)
Create Database Tables

In this video series you can see how to connect Ozeki SMS Gateway and MSSQL Express database server for SMS messaging. This video shows how to create the proper database table structure by using MSSQL Express through it's command line.

Video content
1. Connect to MSSQL Express
2. Copy CREATE TABLE statement
3. Run CREATE TABLE statement
Start the video

Please scroll down to copy the CREATE TABLE statements used in the video. If you have created the database in MSSQL Express, you can jump to the next video.

Connect to the Microsoft SQL Express database
Figure 1 - Connect to the Microsoft SQL Express database



create database ozeki
GO

use ozeki
GO

CREATE TABLE ozekimessagein (
 id int IDENTITY (1,1),
 sender varchar(30),
 receiver varchar(30),
 msg nvarchar(160),
 senttime varchar(100),
 receivedtime varchar(100),
 operator varchar(30),
 msgtype varchar(30),
 reference varchar(30),
);

CREATE TABLE ozekimessageout (
 id int IDENTITY (1,1),
 sender varchar(30),
 receiver varchar(30),
 msg nvarchar(160),
 senttime varchar(100),
 receivedtime varchar(100),
 operator varchar(100),
 msgtype varchar(30),
 reference varchar(30),
 status varchar(30),
 errormsg varchar(250)
);

GO

sp_addLogin 'ozekiuser', 'ozekipass'
GO

sp_addsrvrolemember 'ozekiuser', 'sysadmin'
GO

Figure 2 - CREATE TABLE statement

Copy CREATE TABLE statement from the folowing LINK
Figure 3 - Copy CREATE TABLE statement from Figure 2


Run CREATE TABLE statement on the database
Figure 4 - Run CREATE TABLE statement on the database



Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Products > Ozeki 10 > Apps > SMS Gateway > SMS from/to Database > MSSQL Express > Create Database
Legal | Privacy policy | Terms of use
Page: 5710 | Login | 3.93.74.227