.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

MySQL to SQL Server Conversion Tools

Posted By:      Posted Date: August 29, 2010    Points: 0   Category :Sql Server
Anyone know of any FREE database conversion tools?

View Complete Post

More Related Resource Links

Extreme ASP.NET: Tools of the Trade: SQL Server Profiler and Query Analyzer


In my last column, I discussed Microsoft® Application Center Test and how it could be used to measure the performance of your Web application (see Extreme ASP. NET: Tools of the Trade: Application Center Test).

Rob Howard

MSDN Magazine August 2005

BizTalk Server 2000: Architecture and Tools for Trading Partner Integration


This article provides an overview of the concepts involved with implementing a trading partner integration system on BizTalk Server 2000 and details the document interchange server architecture and toolset. Additionally, an early look was taken at some business process integration features planned for the production release of the product that allow easy design, execution and sharing of new business processes with trading partners. The concepts and architecture presented allow companies to prepare internal line-of-business applications and trading partners for systems that improve customer service and reduce operating costs.

Aaron Skonnard and Bob Laskey

MSDN Magazine May 2000

how do I uninstall "Management Tools - Basic in SQL Server 2008 R2 (Express)

how do I uninstall "Management Tools - Basic in SQL Server 2008 R2?  The regular remove program does not have this option highlighted.    I am trying use some of the advance option and learn something more and now ssms is useless.         the discovery report tells me these are installed but I have no way of uninstalling.  .  I want to replace this with my developer edition that I purchased but have lots of trouble installing because of the express version.  Please help.  I'd really appreciate it. " Sql Server 2008     Management Tools - Basic 1033 Express Edition 10.50.1092.20 No Sql Server 2008     Client Tools Connectivity 1033 Express Edition 10.1.2531.0 No Sql Server 2008     Client Tools Backwards Compatibility 1033 Express Edition 10.1.2531.0 No Sql Server 2008     Client Tools SDK 1033 Express Edition 10.1.2531.0 No "

insert query from ms SQL server into a mysql linked server

INSERT into openquery(dbserver1MySQL,'select * from graham.lookup_in_table') select * from NavteqAPAC.dbo.Admin_Names   is giving me the following error! Please help me   OLE DB provider "MSDASQL" for linked server "dbserver1MySQL" returned message "[MySQL][ODBC 5.1 Driver][mysqld-5.1.49-community]Commands out of sync; you can't run this command now". Msg 7343, Level 16, State 2, Line 1 The OLE DB provider "MSDASQL" for linked server "dbserver1MySQL" could not INSERT INTO table "[MSDASQL]".

Recomended tools for SQL Server Programming.....

Hi all Iam Part in development team,I want give a session to Developer and tester on SQL Servers tools and utilities which can help develper and tester  give very good product as a whole. I preffer to give session on: Developers 1.Execution plans 2.Profiler Testers: 1. windows counters 2.Execution plans 3.Profiler Is it ok...I need give session on DMV as well for all Teams. Please some body recomend me so useful tools which I missed... Thanks in Advance  SNIVAS

ms access to sql server conversion tool

Hello all forum Members, I am new to Sql Server 2005. I have some sample databases created my me in ms access format. I don't know the db version i.e. 2000,2003. I don't have MS access installed on my machine, but there are some .pdb extension files that i want to convert. I want to convert these databases to Sql Server 2005 format successfully. Plase suggest me a tool for converting ms access to sql server 2005. Thanks in advance.

Can't Uninstall SQL Server 2005 Express Tools


I am attempting to install SQL Server 2008 Enterprise Trial and receive the follow error during installation.


"The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools."


I have used Add or Remove programs to remove all components of SQL Server 2005 Express.  I have even reinstalled the Workstation Tools of SQL Server 2005 just so I could indiviually remove those tools, and then completly removed the SQL 2005 installation.


I have used regedit to search for any instance of SQL Server 2005, there is none.



There is still an entry for SQL Server Mangement Express in my all programs listing.  However trying to launch that program fails with errors, so it is partial still installed.


Can anyone tell me how to wipe out these last bits of SQL Server 2005 Express Tools?  I have tried everything I have found searching this forum to no avail.



Can I run Sql server 2000 client tools and SQL server 2005 on teh same machine.



Could you please advise me on this issue.

I have installed sql server 2000 client tools, and complete set up of sql server 2005 on my system.

The enterprise manager on sql 2000, crashes and and window vanishes, when ever i try to create DTS package.

They doubt its becos i am runnning both instance of sql server on the same machine- So its having some compactability issues.?

Can we run SQL server 2000, 2005 and 2008 on same machine with different instance ?

I am using windows 7 and i3 processor.

Thanks in advance.



Install App that uses .NET Framework 4 and SQL Server 2008R2 Express (with Tools) - what .NET Framew


I am a little confused about how to install my application.  Written in C# using VS 2010 and targeted for the .NET 4 Framework.  It also uses a SQL Server 2008 R2 database.

In my installer I install .NET 4 Framework if not already present on the host machine.

For SQL Server 2008 R2 (with Tools) I understood I need Installer 4.5 and Powershell 1.0.  The install of install of 4.5 installer goes ok but requires a reboot.  The install of Powershell says it needs .NET Framework 2 SP2 - even tho' .NET 4 is installed.

I decide to ignore this and carry on so manually install SQL Server 2008 R2 Express (with Tools).  It unpacks and complains it needs .NET Framework 3.5 SP1!

My application has to deploy to a disconnected machine installed in the cab of a logging harvester so I can't rely on automatic wwindows updates.


To deploy my app with SQL Server 2008 R2 (with Tools) do I need ...

  • .NET Framework 2.0 SP2 and
  • .NET Framework 3.5 SP1 and
  • .NET Framework 4



I had presumed all I would would be .NET Framework 4 since it is "mostly" backwardly compatible.

Install time and complexity is HUGE is I need all three Frameworks.


Can someone please clarify for me?




Incremental data load from MySQL database to SQL server 2008 using SSIS


I am looking for best solution to perform incremental data load from MySQL database to SQL Server 2008.  I tried to follow instructions from articles on incremental data load in SSIS  using MD5 hashes but I failed to make connection in Lookup transformation editor between MySQL Id (4 byte unsigned integer) and Id in SQl Server 2008 table which is  bigint. i tried to add  data conversion and convert MySQl Id to string. It works fine when you map this field directly to OLEDB destination but in Lookup component it failed. 


Any input greatly appriciated.



Converting SQL Server Datetime to MySQL Datetime


I am trying to store a SQL Server datetime into MySQL datetime field, but MySQL stores the date value as all zeros.  I  use this function to trim the fractional part from the SQL Server datetime, but get the same result when trying to store it in MySQL.

Dim tDate As String = sqlDate.ToString()
        tDate = tDate.Substring(0, tDate.Length - 4)
        Return tDate


Installing SQL server 2005 client tools.

I searched on internet and documents, but could not find the steps to install only client utilities for SQL Server 2005. I need something like Query Analyzer and isql to connect to the database.
I selected client tools only after clicking setup.exe, but query analyzer and isql or Microsoft Server Management studio were not installed.
Any help will be useful.


How to fix "ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]MySQL server has gone awa


Hi Experts ,

I have hosted my web application into server . I got below error on and off but when i refresh the page , the error disappear . Im unable to figure out what is the problem because the error is normal happen after using the application about 10 to 20 mins . But when i run in localhost , there is no problem at all .  

I read lot of articles and testing on it but still failed .  Pls help . Im using asp.net C# and mysql .

Million Thanks ..




ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]MySQL server has gone away

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.Odbc.OdbcException: ERROR [08S01] [MySQL][ODBC 5.1 Driver][mysqld-5.1.46-community]MySQL server has gone away

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and lo

Conversion failed when converting datetime from character string. SQL Server @StartDate as datetime



Can you please help me on this?

When I try to pass my parameter it doesn't work. See below is my code :


declare @SQL Varchar(4000)

declare @CRM_FilteredAppointment nvarchar(2000)

declare @CRM_FilteredSystemUser nvarchar(2000)

declare @StartDate datetime

declare @EndDate datetime

set @CRM_FilteredSystemUser = 'Select * from FilteredSystemUser'

set @StartDate = '20080101'

set @EndDate = '20100101'

set @CRM_FilteredAppointment = 'SELECT activityid, participationtypemask 

FROM FilteredAppointment 

WHERE FilteredAppointment.eu_calltype = 2

AND FilteredAppointment.statecode = 1

AND FilteredAppointment.scheduledend >= DateAdd( month, -1, GetD

How much can affect the performance heavily loaded sql-server intensive use of such tools as SQL Ser


How much can affect the performance heavily loaded sql-server intensive use of such tools as SQL Server Profiler ?

5%   ?

15% ?

30% ?

Error - Installing SQL Server 2005 Client Tools



I am trying to install sql server 2005 client tools and I get the following error:


Error code 2356 : Could not locate cabinet in stream : sql.cab

How can I go about this


Looking for Client Query Analyzer (SQL Server 2008) or Equivalent Reporting Tools


I've recently upgraded from SQL Server 2000 to SQL Server 2008.  My accounting and marketing team is skilled and has been using SQL Query Analyzer for years to run smaller queries and build small Crystal Reports.  Unfortunately Query Analyzer is now bundled into the management studio.  That's a bit too much software for this level of power users.

Is there a client-side query analyzer for SQL Server 2008?  I'd rather use a Microsoft product than a 3rd party tool, but I suppose I could do that too.  Looking for something simple that will:

1.  Show users the database tables and/or views

2.  Run queries

Perhaps query analyzer isn't the way to go and my team needs a different reporting system.  If this is the way MS is heading, could you direct me towards a product or service that allows power users to get the information they need?  They will still need to look at raw data to build Crystal Reports though.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend