How To include sql scripts in package & Deployment of VB.NET 2005

• • Reply

  13 years ago

  by yr

  syr

  , United States

  Joined 13 years ago

   How To include  sql scripts in package & Deployment of VB.NET 2005

  appreciate for your help.

  Report abuse
• • Reply

  13 years ago

  by TimL

  Tim Leung

  Berkshire, United Kingdom

  Joined 13 years ago

  You can create a Custom Action to do this. Here's an example of creating a database and table from MSDN.  

  http://msdn2.microsoft.com/en-us/library/49b92ztk(VS.80).aspx

  Report abuse
• • Reply

  13 years ago

  by yr

  syr

  , United States

  Joined 13 years ago

  Thanks for providing the good link which i am able to create the installation setups when i was testing with deployement process i am not able to see the server name

  how to customize the Server name during the installation process.

   

   

   

  Report abuse
• • Reply

  13 years ago

  by yr

  syr

  , United States

  Joined 13 years ago

  Provided link is O.k to my requirment  

  but below code we can change database name ,How to set Server name ,User id and Password

  Private Sub ExecuteSql(ByVal DatabaseName As String, ByVal Sql As String)
          Dim Command As New SqlClient.SqlCommand(Sql, masterConnection)
  
          ' Initialize the connection, open it, and set it to the "master" database
          masterConnection.ConnectionString = My.Settings.masterConnectionString
          Command.Connection.Open()
          Command.Connection.ChangeDatabase(DatabaseName)
          Try
              Command.ExecuteNonQuery()
          Finally
              ' Closing the connection should be done in a Finally block
              Command.Connection.Close()
          End Try
      End Sub
  Its very urgent  to me.

   

  Report abuse