• Migrate MySQL database to SQL Server

    My MySQL database is already full of data but I need to migrate it all over to SQL Server 2008. Is there a particular script / code I need to do this? I don't want to download any third-party software. Thanks!

    ITKE440,470 pointsBadges:
  • SQL Server: Remove foreign key

    On my SQL Server, I have to remove the foreign key from one of my tables so I can insert different values. What SQL query should I use for this? Thank you very much for your help.

    ITKE440,470 pointsBadges:
  • Restoring SQL Server 2008 database backup over my network

    Does anyone know how I can restore a SQL Server 2008 database backup over my network? Do I have to copy the file locally to the SQL Server? Thanks for the help.

    ITKE440,470 pointsBadges:
  • Compare two table schemas in SQL Server database

    Throughout my week, I have to do random checks between a SQL Server development and release database. Usually - this is a manual process but it's quite slow now. Would I be able to compare my different table schemas automatically? Thank you very much.

    ITKE440,470 pointsBadges:
  • Backup SQL Server 2008 database using C#

    How can I backup my SQL Server database (2008 edition) using C#? Is there a specific code I have to write? Can I use SQLConnection? Appreciate the help.

    ITKE440,470 pointsBadges:
  • Count empty tables in SQL Server database

    In SQL Server, would there be a way for me to count the tables with no rows? Can I use a T-SQL statement? Thank you very much.

    ITKE440,470 pointsBadges:
  • Automate SQL Azure database backup with SQL script

    We're generating millions of SQL scripts per day so we can backup our SQL Azure database. But instead of manually, we need to do it automatically. What's the process to do this? Thank you.

    ITKE440,470 pointsBadges:
  • Copy and rename SQL Server 2008 database

    We currently have a SQL Server 2008 database that needs to be copied and renamed as a new database. We're not too worried about losing data - it's a new database. Basically - we want to keep the same structure as the old database / set a new name to it. What's the best way to do this?

    ITKE440,470 pointsBadges:
  • Best format to store images in SQL Server database

    For my SQL Server database, what's the best format to store images? Would binary be the best bet? Thanks so much.

    ITKE440,470 pointsBadges:
  • Rename SQL database table

    For my SQL database, I have to rename one of my columns. What's the process to do that? Will a specific query work for this? I just have to change the name.

    ITKE440,470 pointsBadges:
  • How to get number of fields in SQL Server database

    Would I be able to get the number of fields in my SQL Server database with some sort of SQL statement? I'm talking about all the entries in my database. Thank you.

    ITKE440,470 pointsBadges:
  • Change data path for existing SQL Server database

    My SQL Server has between 15-20 databases running on it. Now, because I'm running out of space, I'm looking to move my data path to another drive. How can I go about doing this? What SQL command should I use?

    ITKE440,470 pointsBadges:
  • Benchmark a SQL Server query

    Would there be a way I can benchmark a specific SQL Server query? I don't want to 3rd party tool either. Would SQL Profiler work for this?

    ITKE440,470 pointsBadges:
  • Do Businesses still need SQL Server?

    With all the upgrades to MySQL, has SQLServer needed to step up its game or do you think business still needs SQLServer?

    ITKE440,470 pointsBadges:
  • Compare three SQL Server columns

    I have 3 tables table1 has the column id1 with three values in it '1','2','3' and table2 has column id2 with three values '3','4','5' and table3 has column id3 with three values '5','6','7'. How do I join all the three tables, and I also want the null value to be displayed. Please go through the...

    harish978920 pointsBadges:
  • What are the basic parameters needed to assist an automation tool?

    My concern is what are the basic key parameters to be considered for assisting an automation tool. In my company we are automating database (MySQL - Queries) part using 1st approach: Using stored procedures. 2nd approach: Using Excel VBA Macros.  For that we need to assist some basic parameters...

    VijayVardhan5 pointsBadges:
  • INSERT two SQL tables into new table

    I have two SQL tables and they're both pretty large. But now I have to combine all of their column names into a new table and, for some reason, I don't have permission to click on each table and choose CREATE to SCRIPT. So how can I go about doing this? Basically, how can I use INSERT both tables...

    ITKE440,470 pointsBadges:
  • Calculate overall sum of SQL Server database sizes

    In my SQL Server, I need to find out how much space my databases are using. I tried using sys.databases but it's giving me separate results and I have to put that into Microsoft Excel and do the math there. Can I do this using T-SQL? Thanks so much.

    ITKE440,470 pointsBadges:
  • Merge two SQL Server databases

    I have two SQL Server databases and they have the same schema. But both may have issues with the primary key in some tables (so I want to get rid of the duplicate rows). How can I merge these two databases? Appreciate any help available.

    ITKE440,470 pointsBadges:
  • Close existing connections on SQL Server database

    I'm trying to close all of my existing connections to SQL Server - I have to do a complete restore for my database. Here's what I tried so far: alter database YourDb set single_user with rollback immediate But I keep getting this message: Connection was not closed. What should I do?

    ITKE440,470 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.