REPLICATION BETWEEN MSSQL SERVER And Postgresql/MySQL/ORACLE???

Nov 27, 2006

Hi Friends,
I want to know if there are a manner of replication(two-way) between MSSQL SERVER and (postgresql or mysql or ORACLE).

Thanks

View 3 Replies


ADVERTISEMENT

General Advice Needed Regarding MS Access, MS SQL Server, MySQL/PostgreSQL

Nov 15, 2006

I am working on two versions of an application, one of which will be awindows forms application (which will need to be redistributable) andthe other will be a web application.I have MS Visual Studio 2005 (along with the developer's edition of MSSQL Server), but not MS Access. I also have MySQL, PostgreSQL, Sun'sapplication server, Tomcat and Apache web server. I am working onWindows XP Pro, and have installed the .NET 3 SDK and all relevantrelated products I could find (e.g. 2 extensions packages for VisualStudio).I have one MS Access database, to which my users should have read onlyaccess. I have, and have used, a tool for importing MS Accessdatabases into MySQL. I expect that SQL Server has a similar utilityhidden somewhere (where I haven't yet looked, though I HAVE beenlooking - obviously in the wrong places). I have located a similarutility for importing MS Access databases into PostgreSQL. I have notyet decided which servers to use for the web version, but that isanother story, for which I may raise another thread in due course (butI welcome suggestions which may reduce the effort required givenrequired effort for the windows forms app).My problem is for the windows form aplication (intended for use by asingle family). I expect to use ADO.NET. The question is, should Iimport the Access database into MS SQL, and redistribute it, along withMS SQL Server Express (or is that necessary), or distribute it just asan Access database and use the jet engine to access it. A relatedquestion is, "Does ADO.NET support creating new databases for a givenengine?" Imagine a recipe database. It is easy enough to create a SQLscript that creates all the required tables, indices, foreign keys,&c., but can I submit that SQL script to an ADO.NET object, along witha file name, and have it create, e.g., an Access database with thesupplied name. Or do I have to create a database file with nothing init other than the schema?I have more questions, but they'll have to wait.ThanksTed

View 5 Replies View Related

Replication From MSSQL To MySQL

Jan 12, 2004

Hi all.

My goal is to make from time to time a (one way) replication from MSSQL server (Win2K) to MySQL (Linux, i mean no ODBC here).

Is it possible and how ?

The preferable way is to use the MSSQL's replication features, but I have another idea - a simple (php, perl - no matter) program on the linux machine which will be "cron"-ed to run at the requested time intervals.

What are your recommendings ?
Thanks in advance for every kind of help.

View 2 Replies View Related

Question: A MSSQL Replication To MYSQL, Possible?

Nov 5, 2007

Is it possible to make a data replication from MSSQL to MYSQL?

Thank you for your reply. :)

View 1 Replies View Related

Data Replication From MSSQL To MYSQL

Jul 20, 2005

Hi all.I need to set a oneway replication of some data from MSSQL (running underWindows 2000 server) to MYSQL (running under Linux).Do you have some ideas to solve the problem?Thank youLuca

View 1 Replies View Related

From MSSQL Server To MySQL

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

How To Create A Linked Server To MySQL From MsSQL?

Nov 7, 2005

I can create a linked server to another MsSQL from MsSQL,but encounter error when create a linked server to MySQL:
Error 7399:OLE DB provider 'MSDASQL' reported an error.
Data source name not found and no default driver specified.
......

Anyone can help me?
Thanks!

View 6 Replies View Related

Exporting MS SQL Server Or Oracle Databases To MySQL

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

MSSQL Linked Server To Oracle RDB

Jul 23, 2005

Hi,I am using MSSQL 2k, and I have a linked server set up to an Oracle RDBversion 7. It goes thru an OLE DB provider for ODBC drivers on a systemDSN, which is using an Oracle RDB ODBC driver version 3.0.2.The problem occurs when I send a query that returns zero rows - queryanalyzer just does not complete nor return. This problem is not seenwhen there are rows being returned.I ran a trace and this is the error message I get-:Non-interface error: OLE DB provider MSDASQL returned an incorrectvalue for DBPROP_CONCATNULLBEHAVIOR which should be eitherDBPROPVAL_CB_NULL or DBPROPVAL_CB_NON_NULLAnybody who experienced this before has a solution?Thanks,Lawrence

View 2 Replies View Related

Replication : SQL Server 2000 X MySQL 5.0.41 (Windows)

May 23, 2007



Good day!

I am carrying through a replication of the transacional and heterogeneous type between the SQL Server 2000 and MySQL 5.0.41, through driver of ODBC of the MySQL (version 3.51.15).

Unhappyly I am not having success!

I make all the necessary configurations, but in the hour to create schema in the MySQL, only the table msrepl7 is created (but nondata) and occurs the following error: €śDate too long will be column €śtimecol€? at row 1€? and later €śInvalid cursor state€?.

The first error must to the size of the column timecol that it is created as char (16), but the value that goes to be inserted is to char (19) - > ({ts'2007-05-01 20:45: 21 '}) The table that is published has only two entire fields and the same one is not created in the MySQL, exactly with the option to initiate schema. I looked for in some sites and I found one that said to bind query Log of the MySQL and to catch the command of insert for the table msrelp7 and to insert in the hand, after making this to come back to the SQL Server and to ask for to synchronize again. Did not function, now only with the error of €śInvalid cursor state€?! To complete one another person in one another site it placed that was to exclude the table msrepl7 that everything would function, did not function!

Thanks!!

Cristiano Rodrigues

View 1 Replies View Related

Have You Ever Installed MSSQL On A Server With Oracle Already Running ?

Apr 6, 2007

am i going to cause problems if i install MSSQL2005 on a server with Oracle already installed and running ?

thank you

View 6 Replies View Related

How Can I Link Server To A 32bit ORACLE From A 64bit MSSQL?

Dec 17, 2007

Hello,


How can I link server to a 32bit ORACLE from a 64bit MSSQL?


LiJun

View 1 Replies View Related

MySQL -&> MsSQL

Jan 16, 2007

Hello all,
 I spent the last two days trying to find an application that can export a mySQL database into msSQL syntax so that I can then use that to just create my msSQL database.  I have had no such luck, though I could find a bunch to do msSQL to mySQL.
 Please let me know if anyone has one or knows of one that works because I really do not want to hand port my 70 table database from mySQL to msSQL
 Thanks in advance,
Anthony F Greco

View 3 Replies View Related

Mysql To Mssql

Mar 25, 2007

i have dumped a mysql database to my my documents folder on my server, how can i convert this to a mssql database.
 
the database came from a site that was in php and of course using mysql, the database has all the users logon information and other information in there personal profile.
i would like to convert this to a mssql database and connect it to the new site i am doing in .net/C#

View 3 Replies View Related

MySQL Vs MSSQL

Oct 21, 2007

Hi, I've been coding in C#/ASP.NET for a little while now, but I've only ever used MS SQL.I'm starting a new project at work soon, and our host provides free MySQL databases but charges for MS SQL databases.
What are the pros/cons for each of these databases, and how much conversion would be required in an existing C#/ASP.NET application if I wanted to change from MS SQL to MySQL? I assume the syntax/commands to operate a C# app with MS SQL are different to the ones required to communicate with a MySQL database?
I'll probably stick with MS SQL because it's what I know, but I'd like to get familiar with MySQL as it might come in handy one day.Thanks, any information is greatly appreciated.

View 2 Replies View Related

Different Between MYSQL And MSSQL

Jun 14, 2005

i'm a newbie here. :D

as the topic stated, what is the diferent between the 2 database in term of, reliability, speed, price for licensing and etc. :confused:

any reply will be appreciated

thanks :)

View 7 Replies View Related

MsSql And MySql

Oct 28, 2005

I was asked to program a site in coldfusion using mssql, but i have only used mysql in the past. i heard mssql has all the functions mysql has, but mysql does not have everything mssql does.. so if i programmed it in mysql, it should work? right?
is there a free download to test mssql or only a buy version?

View 2 Replies View Related

MSSQL Vs MySQL

Aug 22, 2005

I have this query in mysql
Code:

SELECT * FROM `bugs` LIMIT 60 , 30



Is there a similar command in MSSQL like LIMIT, where i can specify start record and number of records?

View 2 Replies View Related

Mysql To Mssql

Jul 18, 2005

hi,all
i have a database in MySQL with approximately 1600 records that must be converted into MSSQL. There are too many converters but they are not free to download. What would you recommend me to do among several solutions like first converting to access or excel and then importing them into MSSQL etc..?
Thanks all in advance.

View 1 Replies View Related

MySQL To MSSQL

Dec 22, 2006

i need a simple way to do this since im gonna need to do it every single week most probably so any help would be apreciated. if i dont have anything by monday it start coding one. Btw im using mysql 5 and SQL server express 2005

View 2 Replies View Related

MYSQL To MSSQL

May 15, 2007

Hey Guys, are you aware of anyone moving from MYSQL to MSSQL or vice versa - what were your experiences - Mark Smith

View 8 Replies View Related

Mssql - Mysql

Aug 27, 2006

Hi!

As a newbie I'm wondering if there is a difference between mySql and msSql.

Will mySql -code and -tables work in a msSql database?

Thank you!

View 1 Replies View Related

MySQL To MsSQL 2005

Nov 5, 2007

Hi!
How can i convert this code to work with MsSQL 2005?
/Tomas
 Partial Class skaalb
Inherits System.Web.UI.Page

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim strConnectionString As String
Dim strQuery As String
Dim MyConnection As OdbcConnection
Dim myCommand As OdbcCommand


Dim path As String = Server.MapPath("~/album") & "/"
Dim albName As String = Trim(Replace(txtAlbum.Text, "'", "''"))
Dim folderName As String = Trim(Replace(txtAlbum.Text, "'", "''"))
folderName = Replace(folderName, " ", "_")


Try
If Not My.Computer.FileSystem.DirectoryExists(path & folderName) Then

My.Computer.FileSystem.CreateDirectory(path & folderName)
labelStatus.Text = "Folder <b>" & folderName & "</b> created!"

Dim Beskrivning As String = Trim(Replace(txtBeskrivning.Text, "'", "''"))

strConnectionString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=xxxxxxxx; DATABASE=xxxxxxx; UID=xxxxxxxx; PASSWORD=xxxxxxxxx; OPTION=3"
MyConnection = New OdbcConnection(strConnectionString)
MyConnection.Open()
strQuery = "INSERT INTO tbl_albumet(alb_Namn, alb_Beskrivning, alb_Mapp) VALUES (?, ?, ?)"

myCommand = New OdbcCommand(strQuery, MyConnection)
myCommand.Parameters.AddWithValue("?", albName)
myCommand.Parameters.AddWithValue("?", Beskrivning)
myCommand.Parameters.AddWithValue("?", folderName)


myCommand.ExecuteNonQuery()
MyConnection.Close()


Else
labelStatus.Text = "Folder excist, pick another name!"
End If
Catch ex As Exception
labelStatus.Text = "Unable to create folder!"
End Try


End Sub
End Class 

View 1 Replies View Related

Help Converting From From MySql To MSSql

Jun 7, 2007

Hello,
I'm trying to use sql to create a db, but the file the guy gave me is MySql. I tried a few things, and then I asked him to try to migrate it to MSSql for me, but it's still giving me this error:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'meteor'.

Here's the code i'm using in Studio Express:

CREATE DATABASE 'meteor';
USE 'meteor';
CREATE TABLE 'address' (
'address_id' int(11) NOT NULL auto_increment,
'address_1' varchar(255) default NULL,
'address_2' varchar(255) default NULL,
'city' varchar(255) default NULL,
'state' varchar(255) default NULL,
'zip_code' varchar(10) default NULL,
'country' varchar(255) default NULL,
'phone_1' varchar(255) default NULL,
'phone_2' varchar(255) default NULL,
'fax' varchar(255) default NULL,
'site' varchar(255) default NULL,
PRIMARY KEY ('address_id')
);




Thanks for any assistance with this!

View 5 Replies View Related

Migrating From Mysql To MSSQL

Nov 25, 2005

Hi i have recently developed a perl/mysql application but now i need to migrate all my databases and tables from mysql to mssql can anybody explain the simplest way to do this. I already have used Mysql's migration toolkit to migrate from access to mysql does mssql have any tools like this? Please let me know

Thanx.

View 3 Replies View Related

Mssql - Mysql Converter

Nov 18, 2004

Hi does anybody know where i can get a full free working copy of a converter to convert an sql database to a mysql database.

I can only find trials which only convert few tables.

Cheers

Andy

View 1 Replies View Related

Mysql To Mssql Like Statement

Nov 4, 2005

I'm converting to mssql. I've been using the following statement in a php query with mysql.

$result = mysql_query ("SELECT * FROM inks i, sample s, customer c, press pr WHERE s.JobNum like '$JobNum%' and c.CustName like '$CustName%' and pr.PressID like '$PressID%' and s.InkID like'$InkID%' and c.CustNum=s.CustNum and pr.PressID=s.PressID and i.InkID=s.InkID and s.Bindery like'%$Bindery%'");
This allowed me to select a press and/or certain paper and/or certain ink, etc. Allowed me to select any combination needed to find.

Now when I use this statement I don't get any results. I have the following which works if I select items in all categories, but that isn't always possible. I need a wildcard selection if we don't know or don't care what press it was run on or what paper was run on a press or what ink was used to print, etc

$result = mssql_query ("SELECT * FROM text t, cover cv, sample s, customer c, press p WHERE (s.PressID like '$PressID' and p.PressID = s.PressID and c.CustNum=s.CustNum and t.TextPaperID=s.PaperTextID and cv.CoverPaperID=s.PaperCoverID) and (s.PaperTextID = '$TextPaperID' and t.TextPaperID=s.PaperTextID and p.PressID = s.PressID and c.CustNum=s.CustNum and cv.CoverPaperID=s.PaperCoverID) and (s.PaperCoverID = '$CoverPaperID' and t.CoverPaperID=s.PaperCoverID and p.PressID = s.PressID and c.CustNum=s.CustNum and cv.TextPaperID=s.PaperTextID) order by CustName");

I'm lost
Thanks For the help.

View 3 Replies View Related

Urgent MySQL Vs MSSQL

Aug 18, 2004

Hi

I'm developing website for online test/assessments and I want to know what database is best for my project between Mysql and MSsql. There will be a lot of users writing concurently/ similtaneously to database.

Thank you in advance

View 1 Replies View Related

Like LIMIT For MySql But For MSSQL

Feb 3, 2005

Hi everyone,

I am looking for a function in MSSQL that performs similar to the LIMIT function in MySQL. Here is the LIMIT function's definition:


The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments, which must be integer constants.

With two arguments, the first argument specifies the offset of the first row to return, and the second specifies the maximum number of rows to return. The offset of the initial row is 0 (not 1):

mysql> SELECT * FROM table LIMIT 5,10; # Retrieve rows 6-15


I am aware of TOP and SET ROWCOUNT functions in MSSQL but neither provide the Offset functionality.

Any help would be appreciated,

Piet

View 1 Replies View Related

What Is Wrong (MySQL Vs MsSQL)

Jan 28, 2008

I have been using MySQL for a long time but because of company policy changes I have started to switch from MySQL to MsSQL

OMG MsSQL is very slow with every thing it does compared to MySQL. I.e updating 300.000+) data in a table with 15 million+ records using 'update' syntax. In MySQL it was done in 4 minutes. In MsSQL it was not done in 20 minutes (and then I stoped it in anger)

I have a script that I have created to give our daily revenue. In MySQL that takes 30 sec to finish. In MsSQL it takes atleast 1.30 minutes.

I have 1,5G of memory and MsSQL uses it all. MySQL uses 200mb at most.

What am I doing wrong. Is it the memory or what can it be? I have indexed the tables in the same way. I really don't know what to do anymore.

Perhaps You can give me some hints

Tx in advance ;-)

View 8 Replies View Related

How To Do The Same Thing In Mssql As Mysql?

Apr 13, 2006

in MySql:

SELECT * FROM table LIMIT 5,10

How to do this in MicroSoftSql?

View 9 Replies View Related

From MySQL To MSSQL 2005

Dec 12, 2005

Hello! I'm installing the MSSQL 2005.

View 24 Replies View Related

Disconnected Datasets Between MsSQL And MySQL

Dec 6, 2007

I have a mobile application written in vb.net using MsSQL and I want to use disconnected datasets to sync up to a remote MySQL database. is this possible? Its a two way sync, i.e I download and upload info.

Any suggestions, articles, etc would be great.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved