Run the query (SELECT * FROM tablename) to get all the data in Query Analyzer, then copy and paste the results from there into Excel. Then save as csv file type.
MSSQL
There are three general ways to invoke mysqldump:
shell>
mysqldump [options]db_name[tables]shell>
mysqldump [options] --databasesdb_name1[db_name2db_name3...]shell>
mysqldump [options] --all-databasesIn its simplest form, the mysqldump utility can be used like this:
mysqldump –-user [user name] –-password=[password] [database name] > [dump file]
this will include both the schema and data as well.
If you need only the schema use the -d or --no-data option
e.g. mysqldump -d -u root -pp@ssword mydatabase > mydatabase.sql
Reference: MySQL :: MySQL 5.0 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program
Update: You no longer need that if you use the MySQL Connector/Net 5.2 or later.
- Download the source code for the MySQL Connector/Net from www.mysql.com.
- Extract the contents of the zip file to a local directory.
- Open mysql.csproj project file in Visual Studio.
- Open the AssemblyInfo.cs file, and add the following code, in the using block, at the top of the file (if it is not already there):using System.Security;
- Add the following code to the assembly section of the file:[assembly: AllowPartiallyTrustedCallers]
- Recompile the dll.
You may now reference this dll from other projects. When you decide to publish your project to your hosting server, you need to upload this modified version of the dll to your bin directory.
A Step-by-Step Guide To Using MySQL with ASP.NET
MySQL 5 C# sample code using ObjectDataSources
3.1. Connecting to and Disconnecting from the Server 3.2. Entering Queries 3.3. Creating and Using a Database [+/-] 3.4. Getting Information About Databases and Tables 3.5. Using mysql in Batch Mode 3.6. Examples of Common Queries [+/-]
- 3.6.1. The Maximum Value for a Column
- 3.6.2. The Row Holding the Maximum of a Certain Column
- 3.6.3. Maximum of Column per Group
- 3.6.4. The Rows Holding the Group-wise Maximum of a Certain Field
- 3.6.5. Using User-Defined Variables
- 3.6.6. Using Foreign Keys
- 3.6.7. Searching on Two Keys
- 3.6.8. Calculating Visits Per Day
- 3.6.9. Using
AUTO_INCREMENT25.2.3. Connector/NET Examples and Usage Guide 25.2.4. Connector/NET Reference 25.2.5. Connector/NET Notes and Tips 25.2.6. Connector/NET Support
Installing MySQL Community Server on Windows
- Download from here: http://dev.mysql.com/downloads/
- Choose either the Essential or Complete.
- Run setup.exe and you will see something like this:
- Next you will see the MySQL ‘Server Configuration Wizard’:
- On Windows platforms, the MySQL server can be installed as a Windows service.
- Testing the MySQL installation. e.g. C:\>
"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqlshow" -u root -p mysql. For more information about mysqlshow, see Section 4.5.6, “mysqlshow — Display Database, Table, and Column Information”.- (Optional) - Securing the Initial MySQL Accounts
- Installing Connector/NET 1.0+ on Windows (Download 1.0, 5.1, 5.2(comes with VS2008 Plugin)) OR Installing Connector/NET 1.0+ using the Source
- MySQL GUI Tools Downloads. MySQL Administrator 1.2, MySQL Query Browser 1.2, MySQL Migration Toolkit 1.1
Via http://dev.mysql.com/doc/refman/5.0/en/installing-cs.html
SQL Server Management Studio Express Utility
In SSMS Tools Pack 1.0 you can find these features:
- Uppercase/Lowercase keywords:
Set all keywords to uppercase or lowercase letters. Custom keywords can be added.
- Run one script on multiple databases:
Run selected or full window text on selected databases on the currently connected server.
- Copy execution plan bitmaps to clipboard:
Copy selected or all execution plans to a bitmap that is saved on the clipboard.
- Search Results in Grid Mode and Execution Plans:
Find all occurrences of your search string in the execution plans or in the results in datagrid mode.
- Generate Insert statements for a single table, the whole database or current resultsets in grids:
Generate insert statement from your data.
- Query Execution History (Soft Source Control):
Save all executed queries to file or database and easily find them.
- Text document Regions and Debug sections:
Add Regions and Debug section in your scripts to ease development experience.
- Running custom scripts from Object explorer’s Context menu:
Speedy execution of custom scripts from Object Explorer’s context menus.
- CRUD (Create, Read, Update, Delete) stored procedure generation:
Generate Customizable CRUD stored procedures for all tables in your database.
Create a template that is shown when creating a new query window.
Blocking occurs when one connection to SQL Server locks one or more records, and a second connection to SQL Server requires a conflicting lock type on the record or records locked by the first connection. This causes the second connection to wait until the first connection releases its locks. By default, a connection will wait an unlimited amount of time for the blocking lock to go away. Blocking is not the same thing as a deadlock.
A certain amount of blocking is normal and unavoidable. Too much blocking can cause connections (representing applications and users) to wait extensive periods of time, hurting overall SQL Server performance. In the worst cases, blocking can escalate as more and more connections are waiting for locks to be released, creating extreme slowdowns. The goal should be to reduce blocking as much as possible.
Troubleshooting Blocking
The first step in troubleshooting a problem is figuring out the cause and type of problem. If you have several phone calls from users whose screens just freeze when they hit the CREATE RECORD button, chances are you have some blocking issues. Fortunately, there are some tools that can help you identify the root of the problem.
Your first line of defense should be the system stored procedures sp_lock, sp_who, and sp_who2. The sp_lock procedure lets you see the type of locks acquired by one, many, or all sessions connected to the server. The syntax is as follows:
Via http://www.informit.com/articles/article.aspx?p=26949&seqNum=1
How do I load text or csv file data into SQL Server?
If you need to load data into SQL Server (e.g. from log files, csv files, chat transcripts etc), then chances are, you’re going to be making good friends with the BULK INSERT command.
The command to bulk insert comma-delimite data would be:
BULK INSERT OrdersBulk
FROM ‘c:\file.csv’
WITH
(
FIELDTERMINATOR = ‘,’,
ROWTERMINATOR = ‘\n’
)If the csv file has a header row, try this:
BULK INSERT OrdersBulk
FROM ‘c:\file.csv’
WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = ‘,’,
ROWTERMINATOR = ‘\n’
)Finally, you can also specify how many errors you want to allow before considering that the BULK INSERT failed.
BULK INSERT OrdersBulk
FROM ‘c:\file.csv’
WITH
(
FIRSTROW = 2,
MAXERRORS = 0,
FIELDTERMINATOR = ‘,’,
ROWTERMINATOR = ‘\n’
)
