Named instance question

Can instance names be aliased back to the the default instance? ie can
server/instancename resolve back to servername/? We are looking to migrate
over from using a named instance, to a default instance, but don't want to
have to go change all of the connection strings in many applications, to
that have named instances attached.
If so, can someone point me in the direction to do so?Only from the clients connecting to it. You can install MDAC 2.6 or later
and use the alias.
"Gary" <clgary@.yahoo.com> wrote in message
news:#j9tS57uEHA.1404@.TK2MSFTNGP11.phx.gbl...
> Can instance names be aliased back to the the default instance? ie can
> server/instancename resolve back to servername/? We are looking to migrate
> over from using a named instance, to a default instance, but don't want to
> have to go change all of the connection strings in many applications, to
> that have named instances attached.
> If so, can someone point me in the direction to do so?
>

MySQL to SQL Server 2005

Hi all,
I have to migrate a MySQL database to SQL Server 2005. What's the best
way to accomplish this? I found the msdn article about migrating MySQL
to SQL Server 2000, but nothing about SQL Server 2005.
I installed MyODBC on the server and made a DSN. I then tried the
Migration Wizard from SSMS (Management -> Legacy -> Data Transformation
Services), but in the Source dropdown list I can only select Microsoft
SQL Server, not MySQL.
Is there any information available on this issue or any hints or tips?
Thanks in advance.
Kind regards,
Ruben.> I have to migrate a MySQL database to SQL Server 2005. What's the best
> way to accomplish this? I found the msdn article about migrating MySQL
> to SQL Server 2000, but nothing about SQL Server 2005.
> I installed MyODBC on the server and made a DSN. I then tried the
> Migration Wizard from SSMS (Management -> Legacy -> Data Transformation
> Services), but in the Source dropdown list I can only select Microsoft
> SQL Server, not MySQL.
Hi!
I've never had to migrate data from any other database to MS SQL
Server, since most of the people I know started off with MS SQL Server
and moved to Oracle ;-)
I'm not sure, but the following is what I can suggest.
You can migrate data from any OLE DB data source using the Microsoft
Business Intelligence Development Studio. An OLE DB driver for MySQL is
available at http://luggle.com/~sean
In the Business Intelligence Development Studio, create an Integration
project and add an SSIS package. Add a Data Flow task to the package by
dragging it from the Toolbox. Then, double-click the Data Flow task to
open another window. Here, drag the OLE DB Data Source twice - one for
MySQL and one for SQL Server. Select the table to move, connect the
output of the MySQL OLE DB Data Source to the SQL Server Data Source.
N.I.T.I.N.|||Hi there NiTiN,
Thanks for your reply, it's much appreciated.
I tried the steps you suggested and it gets me pretty far: I added the
two OLE DB Data Sources in my project and then editted the MySQL one.
I select the MySQL OLE DB provider and fill out the authentication info.
It can connect and get the tables from the MySQL database, but then when
I select a table and hit the "Preview" button I get an exception:
"MySQL OLE DB Provider has not been activated"
And another one:
"Opening a rowset for "bookmarks" failed. Check that the object exists
in the database".
I think that it has something to do with the fact that it's MySQL
version 5 and the OLE DB Provider is pretty old, so it was probably
written for MySQL 3.x or 4.x.
I'll continue looking for some other MySQL OLE DB provider. Other tips
are welcome of course. Thanks again.
Kind regards,
Ruben.|||Update: I decided to just buy Full Convert to do the job for me, since
it's probably cheaper to do it that way. ;)
Thanks for the suggestion though.
Kind regards,
Ruben.|||Ruben van Engelenburg wrote:
> "MySQL OLE DB Provider has not been activated"
Good day,
I know you're moving to Full Convert, but just thought I'd suggest an
alternative for anyone else who decides to come across our thread
sometime in the future.
The MySQL OLE DB Provider has to be activated before use - there's a
link on the same page that leads to the activation page. I'm not sure
if it is limited in any way, but there is an option to get a free
activation. I know I should've mentioned this before, but I thought the
activation link on the web page was close enough to the download link
to attract some attention.
BTW, I just read about Full Convert and it looks like a neat product.
Perhaps I'll try it sometime while migrating between databases.
N.I.T.I.N.|||Hi NiTiN,
Thanks for the note. I sure should have seen that, I can't believe I
didn't. :)
Anyway, I did activate it now just to see if it actually works.
Indeed it did get rid of the activation error when I hit Preview on a
table, but I get a new error instead about the MySQL query syntax being
incorrect. I think it has something to do with the MySQL version, so it
might work with an older version of MySQL, just not with MySQL 5.
I can only confirm that Full Convert is a neat product. It sure saved me
a lot of time and the SQL Server version only costs 129 dollar.
The conversion from a MySQL database to SQL Server 2005 gave me four
errors in a total of about 200000 rows. They all had to do with
constraints, so I have to set those manually afterwards (not a big
deal). I can recommend it.
Thanks again for your helpful tips.
Kind reards,
Ruben.

MySQL to SQL Server 2005

Hi all,
I have to migrate a mysql database to SQL Server 2005. What's the best
way to accomplish this? I found the msdn article about migrating MySQL
to SQL Server 2000, but nothing about SQL Server 2005.
I installed MyODBC on the server and made a DSN. I then tried the
Migration Wizard from SSMS (Management -> Legacy -> Data Transformation
Services), but in the Source dropdown list I can only select Microsoft
SQL Server, not MySQL.
Is there any information available on this issue or any hints or tips?
Thanks in advance.
Kind regards,
Ruben.> I have to migrate a mysql database to SQL Server 2005. What's the best
> way to accomplish this? I found the msdn article about migrating MySQL
> to SQL Server 2000, but nothing about SQL Server 2005.
> I installed MyODBC on the server and made a DSN. I then tried the
> Migration Wizard from SSMS (Management -> Legacy -> Data Transformation
> Services), but in the Source dropdown list I can only select Microsoft
> SQL Server, not MySQL.
Hi!
I've never had to migrate data from any other database to MS SQL
Server, since most of the people I know started off with MS SQL Server
and moved to Oracle ;-)
I'm not sure, but the following is what I can suggest.
You can migrate data from any OLE DB data source using the Microsoft
Business Intelligence Development Studio. An OLE DB driver for mysql is
available at http://luggle.com/~sean
In the Business Intelligence Development Studio, create an Integration
project and add an SSIS package. Add a Data Flow task to the package by
dragging it from the Toolbox. Then, double-click the Data Flow task to
open another window. Here, drag the OLE DB Data Source twice - one for
MySQL and one for SQL Server. Select the table to move, connect the
output of the mysql OLE DB Data Source to the SQL Server Data Source.
N.I.T.I.N.|||Hi there NiTiN,
Thanks for your reply, it's much appreciated.
I tried the steps you suggested and it gets me pretty far: I added the
two OLE DB Data Sources in my project and then editted the mysql one.
I select the mysql OLE DB provider and fill out the authentication info.
It can connect and get the tables from the mysql database, but then when
I select a table and hit the "Preview" button I get an exception:
"MySQL OLE DB Provider has not been activated"
And another one:
"Opening a rowset for "bookmarks" failed. Check that the object exists
in the database".
I think that it has something to do with the fact that it's MySQL
version 5 and the OLE DB Provider is pretty old, so it was probably
written for mysql 3.x or 4.x.
I'll continue looking for some other mysql OLE DB provider. Other tips
are welcome of course. Thanks again.
Kind regards,
Ruben.|||Update: I decided to just buy Full Convert to do the job for me, since
it's probably cheaper to do it that way. ;)
Thanks for the suggestion though.
Kind regards,
Ruben.|||Ruben van Engelenburg wrote:
> "MySQL OLE DB Provider has not been activated"
Good day,
I know you're moving to Full Convert, but just thought I'd suggest an
alternative for anyone else who decides to come across our thread
sometime in the future.
The mysql OLE DB Provider has to be activated before use - there's a
link on the same page that leads to the activation page. I'm not sure
if it is limited in any way, but there is an option to get a free
activation. I know I should've mentioned this before, but I thought the
activation link on the web page was close enough to the download link
to attract some attention.
BTW, I just read about Full Convert and it looks like a neat product.
Perhaps I'll try it sometime while migrating between databases.
N.I.T.I.N.|||Hi NiTiN,
Thanks for the note. I sure should have seen that, I can't believe I
didn't.
Anyway, I did activate it now just to see if it actually works.
Indeed it did get rid of the activation error when I hit Preview on a
table, but I get a new error instead about the mysql query syntax being
incorrect. I think it has something to do with the mysql version, so it
might work with an older version of MySQL, just not with mysql 5.
I can only confirm that Full Convert is a neat product. It sure saved me
a lot of time and the SQL Server version only costs 129 dollar.
The conversion from a mysql database to SQL Server 2005 gave me four
errors in a total of about 200000 rows. They all had to do with
constraints, so I have to set those manually afterwards (not a big
deal). I can recommend it.
Thanks again for your helpful tips.
Kind reards,
Ruben.

mysql to SQL Server

Hi
I am looking to migrate mysql to SQL Server any good tool to do that
My DTS wizard doesn't give the option of mysql
Thank you,
SamuelI've used DTS against mysql - it's doable. Make sure you
have installed the drivers on your PC and the SQL Server
box. You can download mysql drivers from:
http://dev.mysql.com/downloads/
-Sue
On Mon, 22 May 2006 21:51:18 +0100, "Samuel Shulman"
<samuel.shulman@.ntlworld.com> wrote:

>Hi
>I am looking to migrate mysql to SQL Server any good tool to do that
>My DTS wizard doesn't give the option of mysql
>Thank you,
>Samuel
>|||I saw both your replies, thank you just what I needed
"Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
news:e3yQ5FefGHA.2416@.TK2MSFTNGP03.phx.gbl...
> Hi
> I am looking to migrate mysql to SQL Server any good tool to do that
> My DTS wizard doesn't give the option of mysql
> Thank you,
> Samuel
>
>

mysql to SQL Server

Hi
I am looking to migrate mysql to SQL Server any good tool to do that
My DTS wizard doesn't give the option of mysql
Thank you,
SamuelI've used DTS against MySQL - it's doable. Make sure you
have installed the drivers on your PC and the SQL Server
box. You can download MySql drivers from:
http://dev.mysql.com/downloads/
-Sue
On Mon, 22 May 2006 21:51:18 +0100, "Samuel Shulman"
<samuel.shulman@.ntlworld.com> wrote:
>Hi
>I am looking to migrate mysql to SQL Server any good tool to do that
>My DTS wizard doesn't give the option of mysql
>Thank you,
>Samuel
>|||I saw both your replies, thank you just what I needed
"Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
news:e3yQ5FefGHA.2416@.TK2MSFTNGP03.phx.gbl...
> Hi
> I am looking to migrate mysql to SQL Server any good tool to do that
> My DTS wizard doesn't give the option of mysql
> Thank you,
> Samuel
>
>

MySQL -> MS SQL

Hi there, I'm trying to migrate from MySQL to SQL Server 2000. I found
a white paper on the Microsoft web site that explains how to do this:
http://www.microsoft.com/technet/pro...oy/mysql.mspx.
The MySQL 3.51 ODBC driver was installed. In the ODBC controls if we
hit "Test" the connection checks out okay. I ran the Import and Export
Data tool. When the MySQL db is selected as the data and I try to
connect, a confusing error pops:
"A serious error occurred when connecting to the provider."
The connection seems to work because if we enter the wrong username and
password we get an "Access denied for user" message.
Using the mysqldump utility, we created a *.SQL file of our tables.
Then we tried to use the Query Analyzer tool to import the data. When
the .SQL file is opened, we get another error: "File.sql contains long
line over 64k limit".
Any suggestions as to what we could do to make this work?
If we try to re-import the data back into MySQL using mysql -uuser
-ppassword dbname < file.sql it works fine.
Thanks!
Consider using the BCP utility to bulk import the data, not only is it
faster than Query Analyzer, it can support far more data...
Steve
"Bill Smith" <bsmith@.nospam.com> wrote in message
news:O9xE8mCBFHA.1524@.TK2MSFTNGP09.phx.gbl...
> Hi there, I'm trying to migrate from MySQL to SQL Server 2000. I found
> a white paper on the Microsoft web site that explains how to do this:
> http://www.microsoft.com/technet/pro...oy/mysql.mspx.
> The MySQL 3.51 ODBC driver was installed. In the ODBC controls if we
> hit "Test" the connection checks out okay. I ran the Import and Export
> Data tool. When the MySQL db is selected as the data and I try to
> connect, a confusing error pops:
> "A serious error occurred when connecting to the provider."
> The connection seems to work because if we enter the wrong username and
> password we get an "Access denied for user" message.
> Using the mysqldump utility, we created a *.SQL file of our tables.
> Then we tried to use the Query Analyzer tool to import the data. When
> the .SQL file is opened, we get another error: "File.sql contains long
> line over 64k limit".
> Any suggestions as to what we could do to make this work?
> If we try to re-import the data back into MySQL using mysql -uuser
> -ppassword dbname < file.sql it works fine.
> Thanks!
|||Hi,
in order to import data from mysql you'll need the followind:
- DSN to MYSQL Server using MyODBC-3.51.06 drivers
- Linked Server to the DSN
the following script:
--sp_tables_ex 'linked_server_name'
use [dababase]
dbcc traceon (8765)
if object_id ([table to import]) is not null drop table dbo.[table to
import]
select * into dbo.[table to import] from openquery ([linked_server_name],
'select * from [table to import] )
- after importing all mysql tables you create additional keys, etc...
Tudor
"Steve Thompson" <stevethompson@.nomail.please> wrote in message
news:%2319us4KBFHA.3140@.TK2MSFTNGP15.phx.gbl...
> Consider using the BCP utility to bulk import the data, not only is it
> faster than Query Analyzer, it can support far more data...
> Steve
> "Bill Smith" <bsmith@.nospam.com> wrote in message
> news:O9xE8mCBFHA.1524@.TK2MSFTNGP09.phx.gbl...
>