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.