Post reply

How can i create a new db to run locally on my pc using sql server.

  • October 5, 2007 at 5:52 am

    #375148

    How can i create a new db to run locally on my pc using sql server.

    I need also to install a copy of this new db in another pc. Do i need the sql server installed in the other machine also? I am thinking to create an application in vb to play with the db. Every time i start the sql server i see the window telling to connect do database engine, may be i am wrong but with this window i can create just a db in the server? i couldn't create a db locally yet, anyone can help me?

  • October 5, 2007 at 7:32 am

    #739511

    If you want to have a local database you will need to install SQL Server. You can download SQL Server Express for free, but it is restricted. If you have MSDN, a developer version is much more pleasant to work with (and it has the same features as the Enterprise edition)

    To copy instances you could use backup/restore, detach/copy/attach, ...

    You cannot create a database in the connection window, but once you are connected to a server you can create databases using either the UI or SQL.

    A good source of information is Books Online, or BOL.

    To learn how to use Management Studio see http://msdn2.microsoft.com/en-us/library/ms166547.aspx

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • October 5, 2007 at 8:28 am

    #739551

    And to follow up Andras's post, Yes, you need SQL Server (or at least the client tools which connect back to the main server) installed on every machine that you intend to have this database running on.

    You can copy the database files over to a machine that doesn't have SQL Server on it, but you won't be able to do anything with them. They'll just sit there taking up space, looking pretty. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • October 5, 2007 at 8:52 am

    #739560

    Another alternative is SQL Server Compact Edition, which is just a file and then a .DLL you add to your application. The "server" essentially is just an inprocess thread for your application. Runs when you run the app.

    Otherwise, Express or other SQL editions are servers. They can run on a workstation, but they operate as a server service and you "connect" to them. You don't open the file. You send a connection request to an out of process service that is running.

Viewing 4 posts - 1 through 3 (of 3 total)

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