Query On SQL Server And MySQL Databases
Aug 21, 2007
I humbly ask for anyone's help...
I have two different databases - one in MySQL (eV12) and the other in SQL Server (Brutus). I am using DBVisualizer to perform queries. In the eV12 db, I have 3 tables to search on. In Brutus db, I have 2 tables to search on.
the problem is, I was asked to compare data from one table in eV12 to Brutus database. Is there a way to search using and SQL statement techniques?
I appreciate your expert opinions.
Regards,
Dor Marchan
student - OCC, Michigan
View 1 Replies
ADVERTISEMENT
Jul 20, 2005
I also posted similarly in mailing.database.mysqlI have created a rather large (60 table database) website dealio in PHP thatworks with MS SQL Server, Oracle, MySQL and presumably any other data base Iadd tothe wrapper functions that I created. All the development was done inOracle, but now its time to create that large datastructure again inMySQL -- now I've built this all in notepad for Oracle (twice) and built itin SQL Server using the SQL Server import tools (pretty nice) -- is thereanything that I can do that to get this datastructure and maybe even thedata into MySQL using Oracle/MS SQL Server tools ?James
View 2 Replies
View Related
Nov 4, 2005
Hi,
I would liked to know the SQL Server equivalent for the below MySQL query :
SELECT
a.col1,
a.col2,
max(a.col1)
FROM test a,
test1 b
WHERE a.col2 = b.col2
GROUP BY a.col1
Thanks,
MiraJ
View 1 Replies
View Related
Feb 12, 2007
Good Morning
Has anyone successfully used cherry's oledb provider for MYSQL to create a linked server from MS SQLserver 2005 to a Linux red hat platform running MYSQL.
I can not get it to work.
I've created a UDL which tests fine. it looks like this
[oledb]
; Everything after this line is an OLE DB initstring
Provider=OleMySql.MySqlSource.1;Persist Security Info=False;User ID=testuser;
Data Source=databridge;Location="";Mode=Read;Trace="""""""""""""""""""""""""""""";
Initial Catalog=riverford_rhdx_20060822
Can any on help me convert this to corrrect syntax for sql stored procedure
sp_addlinkedserver
I've tried this below but it does not work I just get an error saying it can not create an instance of OleMySql.MySqlSource.
I used SQL server management studio to create the linked server then just scripted this out below.
I seem to be missing the user ID, but don't know where to put it in.
EXEC master.dbo.sp_addlinkedserver @server = N'DATABRIDGE_OLEDB', @srvproduct=N'mysql', @provider=N'OleMySql.MySqlSource', @datasrc=N'databridge', @catalog=N'riverford_rhdx_20060822'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'rpc', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'rpc out', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'use remote collation', @optvalue=N'false'
Many Thanks
David Hills
View 7 Replies
View Related
Nov 9, 2007
I made a page for a baseball league a couple of years ago using PHP and MySQL, and decided this winter to switch it to ASP.Net and SQL Server Express that comes with VWD 2005 Express Edition.
Anyways, I ran into a problem when trying to convert the query I made with MySQL into SQL Server.
My old code was something like this:
SELECT homeScore, visitorScore, ( homeScore > visitorScore ) AS homeWins, ( visitorScore > homeScore ) AS visitorWins FROM Schedule
This worked fine in MySQL, and returned the home team's score, visiting team's score, and then returned a 1 in homeWins if the home team won. Now, when I try running this query in SQL Server Express, I get an error saying "Invalid column name 'visitorScore > homeScore' ".
Can anyone please help me with what I should be doing differently so this works in SQL Server Express?! Thanks in advance!!!
View 17 Replies
View Related
Nov 9, 2011
I am trying to query 2 SQL databases on the same server and inner joining together.
Databases: Goldmine_MIOA
Goldmine_GMBase
From the "Goldmine_MIOA" database I need to query contact1.* and from the "Goldmine_GMBase" database i need to query cal.
I would then like to inner join both these together.
View 12 Replies
View Related
Mar 3, 2005
I have an internal Project Management and Scheduling app that I wrote internally for my company. It was written to use MySQL running on a Debian server, but I am going to move it to SQL Server 2000 and integrate it with our Accounting software. The part I am having trouble with is the user login portion. I previously used this:
PHP Code:
$sql = "SELECT * FROM users WHERE username = "$username" AND user_password = password("$password")";
Apparently the password() function is not available when accessing SQL Server via ODBC. Is there an equivalent function I could use isntead so the passwords arent plaintext in the database? I only have 15 people using the system so a blank pwd reset wouldn't be too much trouble.
View 7 Replies
View Related
Feb 11, 2008
hi,
i have a table as follows:
location1 location2 Accident
a b 3
b a 5
c d 3
b c 4
c b 5
a b 2
I want to get the following output:
location1 location2 Accident
a b 10
c d 3
b c 9
I am not being able to write the correct sql query for this. Can somebody please help?
thanks,
A
View 12 Replies
View Related
Feb 5, 2008
Hiya,
We've got a strange problem.
We are running on SQL 2000 SP4.
Our structure uses database pairs, we have a Current and a History database so old records that don't change and aren't needed very often are only loaded into memory when needed.
The following query (the names have been changed) deletes the quote from the current database when the order raised from the quote has been moved into the history.
Code Snippet
DELETE FROM t_CurrentUnpaid
FROM db_Mule_History.dbo.t_History INNER JOIN
t_Quote ON
db_Mule_History.dbo.t_History.uid = t_Quote.uid INNER JOIN
t_CurrentUnpaid ON
t_Quote.uid_Parent = t_CurrentUnpaid.uid
where t_CurrentUnpaid.uid_cont != -2
This query runs fine on 4 identical database pairs, on the 5th pair it fails. All these pairs are on the same server, with the same permissions and the exact same structure. Only the data would differ
The error returned is:
Internal server error 8624
level 16 state 1 line 1
We have looked at MS articles, but all that I can find are about bugs fixed in SP1, 2, 3 and 4.
Nothing post SP4 that we are running.
Many thans in advance.
Ian Wilkinson
View 1 Replies
View Related
Jul 2, 2003
We have SQL Server 2000 on a Windows 2000 server and a mySQL database running on a Windows 2000 server.
We have used MyOLEDB driver(OLEDB) to link the mysql database.
How can I access the data stored in a Linked server?
Any help would be appreciated.
Thanks!!
this is our codeˇG
exec sp_addlinkedserver @server='OLEDB_test',
@srvproduct=N'',
@provider=N'MySQLProv',
@datasrc=N'203.xx.xx.xx',
@catalog = N'Store'
exec sp_addlinkedsrvlogin 'OLEDB_test','false',null,'root',''
select * from OLEDB_test.Store.root.Books
or
select * from OLEDB_test.Store..Books
error message:
Can't create OLE DB Provider 'MySQLProv' instanceˇC
OLE DB error trace [Non-interface error: CoCreate of DSO for MySQLProv returned 0x80040154]ˇC
by the wayˇG
1.We Create an ODBC System DSN that points to our MYSql server
2.We use OLEDB for ODBC to create a linked server to mySQL
3.We have got the query to work with openquery
but we can't updateˇBdeleteˇBmodify the data stored in a Linked server
View 1 Replies
View Related
Oct 19, 2015
script to get the list of views in a database, involving tables from other databases?I AM using SQL server 2014
View 2 Replies
View Related
Jan 19, 2007
I am looking for a simple example or guidance on how to move the results of a query from a mysql database to sql server 2005 using SSIS.
It seems rather difficult to do this or at least I am stuggling to figure it out. It was easy to do in DTS, how do you do it in SSIS?
View 3 Replies
View Related
Sep 23, 1999
How to get result from Query by group of (n) rows ?
- Is cursors the better way (and the only) ?
-Is there something as ROWNUM in Oracle or LIMIT in MySql ?
Example plz !
Thanks.
Alex
View 3 Replies
View Related
Oct 5, 2006
im trying to convert this table for a friend 1 CREATE TABLE adminmessage (
2 adminmessageid INT UNSIGNED NOT NULL AUTO_INCREMENT,
3 varname varchar(250) NOT NULL DEFAULT '',
4 dismissable SMALLINT UNSIGNED NOT NULL DEFAULT '0',
5 script varchar(50) NOT NULL DEFAULT '',
6 action varchar(20) NOT NULL DEFAULT '',
7 execurl mediumtext NOT NULL,
8 method enum('get','post') NOT NULL DEFAULT 'post',
9 dateline INT UNSIGNED NOT NULL DEFAULT '0',
10 status enum('undone','done','dismissed') NOT NULL default 'undone',
11 statususerid INT UNSIGNED NOT NULL DEFAULT '0',
12 PRIMARY KEY (adminmessageid),
13 KEY script_action (script, action),
14 KEY varname (varname)
15 )
and was wondering how to do it when mssql doesn't have enums :(
View 1 Replies
View Related
Jul 5, 2004
I just started developing my site locally using SQL Server and am planning to move it to our work's MySQL server. Is there anything that I should be aware of before I continue any furthur? Will I lose any data or is it even an option to move from SQL Server to My SQL???
View 1 Replies
View Related
Nov 16, 2000
Hi Guys,
I am working for a client who needs to move database from MySQL application to MS SQL SERVER 7.0.
Is there anybody who has done it before?
I need some help about how to load data from one system to another system.
THanks in advance.
View 1 Replies
View Related
Sep 2, 2005
Hi there, I'm hoping someone out there can help me.
At my old job, I developed web applications that were based off of a MySQL server. I used PHPMyAdmin and learned the PHP coding, and although not formally trained in DBA or anything, I became very comfortable with using it and building database applications. I did everything through SQL/PHP script coding or through PHPMyAdmin.
At my new job, I decided to build a database, but only had access to MS Access, which I can use, but don’t necessarily like. One day, in earshot of one of our admins, I grumbled “if I only had access to a SQL server, I’d turn this thing into a very cool web application.� Well, he heard, and gave me access to the SQL server and the web server. Thing is, it’s not MySQL, but MS SQL Server. And I feel like I am at a total loss. I was able to build a basic database in the Enterprise Manager on the SQL server, and create a web site on the web server, but I don’t even know how to begin to connect the two – what is the equivalent of MySQLConnect? I know I would have to learn the VBScript and everything for the advanced stuff, but for right now, I just want to make a simple web page that will do a simple select query from a database and return the rows, and simple forms to input into the database. How do I begin? What do I need to know to begin? I have a feeling the applications already on the server were contracted out, so I don’t actually know if anyone here could help me.
Thanks for your help.
View 3 Replies
View Related
Feb 28, 2008
I need to pull data out of SQL Server 2005 and load it into a MySql 5 database, and can't find a way to do this efficiently in SSIS since there's no ODBC destination, and I couldn't find an Oledb driver for MySQL. Any thoughts on the best way to accomplish this, aside from exporting to text, and then loading it into MySql via the mysql client or mysql importer?
-A
View 8 Replies
View Related
Jul 23, 2005
Hey there,I'm curious about MySQL. Could anyone quickly summarize thedifferences between MySQL and SQL Server and outline why someone mightpick SQL Server over MySQL?(Please post replies here, email address is fake)Cheers,Geoff GlaveVancouver, Canada
View 2 Replies
View Related
Jan 28, 2008
Hello Guys,
I'm searching for a way to compare informations from one database against another database.
E.g. i want to check if serialnumbers of my first database (eg hardware.xls or hardware.csv ) are already stored in my sql server database.
I know i can use sql querys (Joins) for that task but i don't know how i can access 2 different databases at the same time. Do i need a tool for it? Does Excel is able to compare those data? But how? I'm searching for that thread since 2 days testing with some tools without any success...
So please help...
Kindly Regards...
Be
View 4 Replies
View Related
Dec 29, 2006
I don't know if this is unique to GoDaddy: I found the program for working with a MySQL database very intuitive (to the point of compliments). Today I started work with ASP.NET and SQL, and when I went to work with SQL Server (on GoDaddy), it wasn't intuitive, and there was almost nothing on which to click. By chance might there be a tutorial that would help a person who needs to work with SQL Server on a provider like GoDaddy?
View 4 Replies
View Related
Mar 6, 2008
Hello all,
I have an application in which the database is currently in MySQL. The app is being re-written(in .net 3.5) and I would like to move the data to SQL Server 2005. What is the best may to get the data from MySQL to SQL Server. Any good tools out there? Idealy, I would be able to manipulate the data during the move, as I have plans for some schema changes, but I suppose I could always make them after migrating.
Please suggest any tools or methods, with your thoughts. I will evaluate any suggested tools. Also, SSIS is available for me, is that the best way?
View 3 Replies
View Related
Apr 7, 2006
hi !
i am using SQL Server 2000...someone told me the new version of Mysql 5.0 is very powerfull and it is better than MS products?!!! any good resources about the benefit of using SQL server 2000 rather than open source?!!
Thanks!
View 10 Replies
View Related
Mar 7, 2001
I have created a linked server to a MySQL database using a DSN. Does anyone know how to run a select statement against a table in the MySQL database? The usual 4 part naming convention does not work.
I can run SELECT *
FROM OPENQUERY(Top50, 'SELECT * FROM orders') which does return records successfully. (Top50 being the name of the linked server)
My objective is to be able to insert records into the MySQL database and I am not sure how do to that using OPENQUERY. Any thoughts on that would be appreciated as well.
Thanks in advance.
View 2 Replies
View Related
Jul 14, 2002
Anyone know how to go about getting data from MySql to MS SQL server? Im a little confussed as to what ODBC driver is needed and all that. Is it possible to this all through enterprise manager? Thanks a lot.
View 1 Replies
View Related
Jul 20, 2004
I have used this mysql code in my programm before:
select * from address order by vorname asc limit 0, 10
It works fine. But now I want to use sql server, and it doesn't recognize the term limit.
So I have found out that I can use top instead.
I have changed my code into this:
select top 0 * from (select top 10* from address order by vorname) order by vorname asc
But it gives me an error message:
wrong syntax near the word Order.
Can anyone give me a solution?
Thank you.
View 5 Replies
View Related
Aug 4, 2004
Hello, anyone knows a good way to export a data base from MSSQL Server 2000 to MySQL? Any suggestion is accepted. Thanks
View 3 Replies
View Related
Dec 13, 2004
Hi all, hoping someone can help.
I have created an ODBC connection to a remote MySQL database.
I can then go into DTS wizard and specify this ODBC connection, it all goes through fine and I can see the tables on the remote server and import data.
The problem arises when I try and create a linked server using the same ODBC connection. I get the following error, when I try to view the tables.
I am so stuck. Any help would be very much appreciated.
View 3 Replies
View Related
Jan 18, 2005
We are trying to do a linked server to MySQL from MS SQL2k. We downloaded MyODBC drivers, setup the system dsn successfully but then SQL errors out using both the GUI and the stored proc to add the linked server to mysql. Does anyone have a good site to reference or any words of advice. An hr or so of google didn't really give up any helpfully information.
Thanks,
DMW
View 3 Replies
View Related
Nov 5, 2005
What is the difference between the SQL used in MySQL and on the MS SQL 2000 server?
Can anyone recommend a good reference on translating a mySQL dump to a format that could be easily uploaded to a MS SQL server?
Thanks!!!!
View 2 Replies
View Related
Feb 3, 2006
Hi everybody,
I have to port a database from MSSQL to MySQL.
I'm really a newbie with MSSQL and I need some hints on how to do this task.
I received a .bak file which my boss told me that this a backup of the database
I have to port.
Then I installed MSQL 2000 developer edition on my workstation and then started
playing with it.
The problem is that I don't know how to connect to the database... and with what
application do some queries. In mysql I use phpMyAdmin which is really useful.
Is there something similar for SQL server? Or something like sqlplus under Oracle?
Moreover how can I install the .BAK file they sent me on my MSSQL install in order
to recreate the db on my workstation??
Thank you.
Fabio
View 8 Replies
View Related
Mar 1, 2006
I use MS profiler to run traces to diagnose issues/problems with any MS SQL Server database. Is there an equivalent tool when using MySQL database? What about Enterprise Manger and Query Analyzer? Is it fair to assume that the administrative tools available for MySQL will do the job that MS tools do for MS SQL Server with comparable ease?
Thanks.
View 4 Replies
View Related
Mar 29, 2004
hi.. currently i need to convert from mysql to sql
how am i to convert it ? below are my previous codes
thanks!
Imports System.Configuration.ConfigurationSettings
Imports System.Web.HttpContext
Imports System.Data.Odbc
Public Class DB
Dim myDB As New OdbcConnection
Dim myCMD As New OdbcCommand
Public Sub New()
Dim db_server = AppSettings("db_server")
Dim db = AppSettings("db")
Dim db_user = AppSettings("db_user")
Dim db_pwd = AppSettings("db_pwd")
Dim DBConnection As String = "DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=" & db_server & ";" & _
"DATABASE=" & db & ";" & _
"UID=" & db_user & ";" & _
"PASSWORD=" & db_pwd & ";" & _
"OPTION=3;"
myDB.ConnectionString = DBConnection
myCMD.Connection = myDB
End Sub
Public Function q(ByVal mySTR As String) As OdbcDataReader
myCMD.CommandText = mySTR
Try
myDB.Open()
q = myCMD.ExecuteReader(Data.CommandBehavior.CloseConn ection)
Catch ex As Exception
Err(ex.ToString)
End Try
End Function
Public Sub c(ByVal mySTR As String)
Try
myCMD.Connection.Open()
myCMD.CommandText = mySTR
myCMD.ExecuteNonQuery()
myCMD.Connection.Close()
Catch ex As Exception
Err(ex.ToString)
End Try
End Sub
Private Sub Err(ByVal strError As String)
Current.Response.Write("<h1>An error has occurred.</h1><br>" & vbCrLf)
Current.Response.Write("Please report to us the error message<br>" & vbCrLf)
Current.Response.Write(strError)
Current.Response.Flush()
Current.Response.End()
End Sub
End Class
View 1 Replies
View Related
