RE: MS SQL Server vs MySQL

Yep SQL Books online...

-----Original Message-----
From: [email protected] [mailto:[email protected]] 
Sent: Friday, March 03, 2006 9:50 AM
To: [email protected]; [email protected]
Subject: RE: MS SQL Server vs MySQL

I tried bcp too.  It behaved just like the wizard did: hard to use,
cryptic error messages if any, etc.

*sigh*  This sounds like all my previous experience with "real" software
tools.  They assume you already know what you are doing and don't really
want to explain it to you if you don't.

-----Original Message-----
From: K. Brian Kelley [mailto:[email protected]] 
Sent: Thursday, March 02, 2006 10:33 PM
To: [email protected]
Subject: Re: MS SQL Server vs MySQL


Quoting [email protected]:

> The problem I'm having is just getting MS SQL to do what I want, when 
> MySQL does it without a problem.  For example, I tried to import data 
> from a delimited file into MS SQL server.  What a pain it was!  Even 
> with their "wizard" it was harder than using a mySQL command line 
> cause the wizard didn't work as expected.

Take a look at bcp. There is also the BULK INSERT command. Both of 
those can be
run without using the data import/export wizard, which, by the way, is
Data Transformation Services, an add-on to SQL Server. It gets beefed up
as SQL Server Integration Services in SQL Server 2005.

>
> Once I finally got data into a table, I wanted to move it to another, 
> like this:
>
> Insert into newtable select field1, field12, ... Field6 from oldtable;
>

I'm assuming you used SELECT INTO. You can specify a NULL value,
however, you must still give the column name using an alias. An example
would be:

USE Northwind
GO

SELECT OrderID, CustomerID, EmployeeID, NULL [NullableColumn] INTO
OrderTransfer FROM Orders

-- 
K. Brian Kelley,  [email protected]
Enterprise Systems Architect/DBA, AgFirst Farm Credit Bank
Author: Start to Finish Guide to SQL Server Performance Monitoring
Contributing Author: Best of SQLServerCentral.com Series Regular
Columnist (Security): SQLServerCentral.com and SQL Server Standard
Magazine Member, SANS GIAC Advisory Board http://www.truthsolutions.com/



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/[email protected]


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/[email protected]



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]