Defines a database object, and provides method to create and modify
databases through administrative database connections. First, define with
Database.__init__(), then create the database with Database.create().
|
__init__(self,
name,
volumes=[ ' G:\\ ' , ' H:\\ ' , ' I:\\ ' , ' J:\\ ' ] ,
dbDir=None,
primarySize=' 4 GB ' ,
logSize=' 1 GB ' ,
filegroups=[ ] ,
filegrowth=' 10% ' )
Defines a database object. |
source code
|
|
str
|
|
|
attach(self,
adminDb,
asName=None)
Re-attach the offline database that was previously detached. |
source code
|
|
|
create(self,
adminDb,
overWrite=False)
Creates this database on a specified server. |
source code
|
|
|
|
|
|
str
|
|
str
|
mirror(self,
adminDb)
Copy the database to the mirror server on the cluster. |
source code
|
|
|
release(self,
adminDb,
pubServer)
Copy the database to the given public server on the cluster. |
source code
|
|
|
setBulkLoadOptions(self,
adminDb)
Set MS SQL Server database options appropriate for bulk loading, over
the load database default options. |
source code
|
|
|
setDefaultOptions(self,
adminDb)
Set the MS SQL Server database options that are appropriate for a
load database over the MS SQL server default options. |
source code
|
|
|
setReleaseOptions(self,
adminDb)
Set MS SQL Server database options appropriate for a release db over
the default load database options. |
source code
|
|
|
|
str
|
_splitSize(self,
size,
divisions)
Splits a size into a number of divisions, converting between GB and
MB when necessary. |
source code
|
|
Inherited from object :
__delattr__ ,
__format__ ,
__getattribute__ ,
__hash__ ,
__new__ ,
__reduce__ ,
__reduce_ex__ ,
__repr__ ,
__setattr__ ,
__sizeof__ ,
__subclasshook__
|