Skip to content

Scripts with the goal to enable easy usage of some SQLServer operations.

License

Notifications You must be signed in to change notification settings

mesmacosta/cloudsql-sqlserver-tooling

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

cloudsql-sqlserver-tooling

Scripts with the goal to enable easy usage of some SQLServer operations.

INIT database

./init-db.sh

Creating Schemas and Tables in SQLServer

./connect-db.sh

Provide your password when prompted, then execute:

use "test-db";
CREATE SCHEMA MY_SCHEMA;
CREATE TABLE MY_SCHEMA.MY_TABLE (name INT, address TEXT);
exit

If you receive errors please run:

sudo pip install mssql-cli --ignore-installed six

To update the sql server driver used by gcloud.

Clean up SQLServer Schemas and Tables

./cleanup-db.sh

Delete the SQLServer database

./delete-db.sh