Post reply

Insert Data with Powershell into a database which is mirrored

  • January 16, 2012 at 7:21 am

    #255058

    I want to make a script which insert data into the database of the principal server. Does somebody have experience to do that with Invoke-SQLCMD or with SMO ? How must the connection string look like ?

  • January 16, 2012 at 7:38 am

    #1434076

    Connection string will be a standard connection string for SQL Server. Try ConnectionStrings.com[/url] for help if you need it.

    Have a search via you favourite search engine...or even search SQLServerCentral.com[/url] for a starter.

    Then when you have tried to help yourself come back here when you are a little stuck on something and I will respond (as many others are likely to do).

    Maybe it's not my place to say this but I don't know of anyone who sits waiting for a question to answer...we are all fully occupied but are prepared to help (not do).

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply