Note: This is the migration API reference for FAKE 5. The new (modularized) API documentation can be found here. If the API is already migrated you can check here if exists in a module. More information regarding the migration can be found here

OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

SqlServer

Nested types and modules

TypeDescription
ServerInfo
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

Functions and values

Function or valueDescription
Attach serverInfo attachOptions files
Signature: serverInfo:ServerInfo -> attachOptions:AttachOptions -> files:seq<string> -> ServerInfo
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

Attach a database
CreateDb(serverInfo)
Signature: serverInfo:ServerInfo -> ServerInfo
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

Creates a new db on the given server
Detach(serverInfo)
Signature: serverInfo:ServerInfo -> ServerInfo
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

Detaches a database
Disconnect(serverInfo)
Signature: serverInfo:ServerInfo -> unit
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

Closes the connection to the server
DropAndCreateDatabase(connectionString)
Signature: connectionString:string -> unit
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

Drops and creates the database (dropped if db exists. created nonetheless)
DropDb(serverInfo)
Signature: serverInfo:ServerInfo -> ServerInfo
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

Drops the given InitialCatalog from the server (if it exists)
existDBOnServer serverInfo dbName
Signature: serverInfo:ServerInfo -> dbName:string -> bool
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module and `dbExistsOnServer` instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module and `dbExistsOnServer` instead.

Checks whether the given Database exists on the server
getDatabase(serverInfo)
Signature: serverInfo:ServerInfo -> Database
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

Gets the initial catalog as database instance
getDatabaseNamesFromServer(serverInfo)
Signature: serverInfo:ServerInfo -> seq<string>
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

gets the DatabaseNames from the server
getDatabasesFromServer(serverInfo)
Signature: serverInfo:ServerInfo -> seq<Database>
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

gets the DatabaseNames from the server
getDBName(serverInfo)
Signature: serverInfo:ServerInfo -> string
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

Gets the initial catalog name
getServerInfo(connectionString)
Signature: connectionString:string -> ServerInfo
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

Gets a connection to the SQL server and an instance to the ConnectionStringBuilder
getServerName(serverInfo)
Signature: serverInfo:ServerInfo -> string
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

Gets the name of the server
intitialCatalogExistsOnServer(...)
Signature: serverInfo:ServerInfo -> bool
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

Checks whether the given InitialCatalog exists on the server
KillAllProcesses(serverInfo)
Signature: serverInfo:ServerInfo -> ServerInfo
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

Kills all processes with the given server info
ReplaceDatabaseFiles(...)
Signature: connectionString:string -> targetDir:string -> files:seq<string> -> attachOptions:AttachOptions -> unit
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

Replaces the database files
ReplaceDatabaseFilesWithCache(...)
Signature: connectionString:string -> targetDir:string -> cacheDir:string -> files:seq<string> -> attachOptions:AttachOptions -> unit
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

Replaces the database files from a cache. If the files in the cache are not up to date, they will be refreshed.
runScript serverInfo sqlFile
Signature: serverInfo:ServerInfo -> sqlFile:string -> unit
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

Runs a sql script on the server.
RunScripts connectionString scripts
Signature: connectionString:string -> scripts:seq<string> -> unit
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

Runs the given sql scripts on the server.
RunScriptsFromDirectory(...)
Signature: connectionString:string -> scriptDirectory:string -> unit
Attributes:
[<Obsolete("FAKE0001 Use the Fake.Sql module instead.")>]
OBSOLETE

FAKE0001 Use the Fake.Sql module instead.

Runs all sql scripts from the given directory on the server.