| Newsgroups |
gmane.comp.db.mysql.windows |
| Message-ID |
<[email protected]> |
Actually I just went out and bought an Oreilly book on T-Sql which is MS
SQL specific. It details all the little things that MS does so I should
be OK now.
-John C.
-----Original Message-----
From: Stephen Cook [mailto:[email protected]]
Sent: Friday, March 03, 2006 7:18 PM
To: Cook, John
Cc: [email protected]; [email protected]
Subject: 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]
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/[email protected]