Re: MS SQL Server vs MySQL

it feels the same when going the other way too (MS SQL Server -> 
MySQL)... the fact of the matter is you have to learn new things, not 
just assume your old knowledge will work on a different product by a 
different vendor just because they do *basically* the same thing.

if you have specific questions rather than general complaints, look for 
a MS SQL Server message board and ask (with details) there. I recommend 
http://www.sqlservercentral.com/


[email protected] wrote:
> 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
> 

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