Home Forums SQL Server 2005 SQL Server Express How to copy a Project from one stand-alone PC to another RE: How to copy a Project from one stand-alone PC to another

  • March 20, 2012 at 8:33 am

    #1461662

    gary.p.heath (3/20/2012)

    OK, thank you, that makes sense.

    No, my program is a Windows Form with multiple Tabs that allows the user to update the database (yearly maintenance) and then process the data on a regular (monthly-ish) basis, there is nothing like that screen of yours.

    So I need to copy the database itself onto the USB when I deploy the Project, and create a small Setup program of my own that will copy the database, create a backup, amend the Config file and allow the "string" in the program to pick up the parameters of the new user's machine from that config file ?

    I'd forgot the program of my own that will copy the database", and instead add documentation ("A SQL Server Instance of at least SQL Express is required") and instructions on how to restore the database.

    then additional instructions on how to change the connection string to point to their server.

    there are WAY to many variables in my opinion related to trying to create a program that will create the database...which comes right back down to the program needing to know where an exisitng database is (or installing SQL Express silently)

    is your conneciton string hardcoded into the application?

    Private Const SqlConnectionFormat As String =

    "data source={0};

    initial catalog={1};

    user id={2};

    password={3};

    Trusted_Connection=False;

    Application Name=Stormrage.ReportGrid.exe;"

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!