User Instances / AttachDBFile

[vivus]

will the new 4.0 beta support Syncing with user instances and attachDBFile?

is there an rss feed or email list when the new 4.0 is released and will it be compatible with the 2.0 framework?

Deepest Regards,
Michael

[Brian Donahue]

Hello,

All of the programs in SQL Bundle 4.0 are compatible with .NET Framework 2.0. They require Framework 1.1, which is the Framework version they're targeted at.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[Brian Donahue]

Attachfile seems to work, but it's officially unsupported by the software. To get it working, you can enter the name of a SQL Server 2005 into the server box, followed by the attachdbfilename command:

[jprice2269]

I create a string to hold the name of the database and the attach string property, and, even though I test to make sue the file exists, the register command still says it doesnt... Any ideas?

Public Sub SourceDatabase(ByVal serverName As String, ByVal databaseName As String, ByVal userName As String, ByVal password As String)
Dim _connectionProperties As Engine.ConnectionProperties

Dim _combinedServerName As String

m_db1 = New Engine.Database

If FileIO.FileSystem.FileExists(databaseName) Then
_combinedServerName = String.Concat(serverName, "; AttachDBFileName=", databaseName)
databaseName = "Source"
Else
_combinedServerName = serverName
End If

If String.IsNullOrEmpty(userName) Then
_connectionProperties = New Engine.ConnectionProperties(_combinedServerName, databaseName)
_connectionProperties.IntegratedSecurity = True
Else
_connectionProperties = New Engine.ConnectionProperties(serverName, databaseName, userName, password)
End If

m_db1.Register(_connectionProperties, m_engineOptions)
End Sub