SQL management studio alternative

  • Hello people,

    We use SQL studio management 2008,

    I wonder how to set up a test environment there I use the SQL management Db file, but instead of running SQL Management studio I need to set up the DB in my local computer to run Querys I use LinQPad (cause we haven't got any SQL Server licenses left)

    Could someone help me?

    or give me suggestion 🙂

    Thank you in advance

  • I carry LinqPad around on a thumb drive if i happen to wander to a desk without my favorite tools.

    you can install an unlimited number of SQL Server Management Studio without a license.

    the license pertains to the install of the services on a machine, and not the tools.

    SQL 2012 SSMS is available as a free, public download: SQLManagementStudio_x64_ENU.exe, for example. with a bit of searching, you can find the 2014 as well.

    http://www.microsoft.com/en-us/download/details.aspx?id=29062

    after you click download, you will see a checkbox for the tool set i mentioned above.

    you could consider whether an Express instance, locally, would satisfy your development needs , or if you cna connect to a central developer instance(much more common), otherwise, just spend ~$50 USD and buy a Developer version

    https://www.cdw.com/shop/products/Microsoft-SQL-Server-2014-Developer-Edition-box-pack/3337221.aspx

    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!

  • Hello again

    I didn't know that...

    I wonder is it hard to copy an existing SQL db to a new virtual machine if I install SQL server

    I believe the hard part for me it's the settings because I have no idea which our running machine use.

    Thank you in advance

  • elmnas (9/16/2015)


    Hello again

    I didn't know that...

    I wonder is it hard to copy an existing SQL db to a new virtual machine if I install SQL server

    I believe the hard part for me it's the settings because I have no idea which our running machine use.

    Thank you in advance

    The way I copy a database is to backup the database, copy the backup file to the destination server and restore it from the backup. You'll have to deal with any logins that don't exist on the destination, as well as any users for SQL logins, as they'll have different SIDs. Overall, it's a relatively simple process.

  • elmnas (9/16/2015)


    I wonder is it hard to copy an existing SQL db to a new virtual machine if I install SQL server

    For me, I would restore a recent Full Backups (and Log Backups if I need the absolute-latest data).

    Other option is to Detach, copy the MDF/LDF files to the new machine, then re-attach the original, and attach on the new machine (as a new database). The database is offline for as long as the copying takes, so this is not a good route for a database which is in use 🙂

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

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