MySQL Forums - Microsoft SQL Server

migrate from SQL Server 2005 to MySql 5.1.39 (3 replies)

gioia guiducci — Fri, 10 May 2013 18:12:31 +0000

Hi, i have to migrate a database from MS Sql Server 2005 to Mysql 5.1.39.
I first tried to migrate a table . In this table there is a field whit this definition : [ [id] [numeric](19, 0) IDENTITY(1,1) NOT NULL] . The Workbench proposes me this conversion: [`id` DECIMAL(19,0) NOT NULL ].

If I use this definition the copy is performed successfully, but I have to migrate to this definition [ `id` BIGINT(20) NOT NULL AUTO_INCREMENT ].
If I use this second definition I have an error in the copy data phase:

ERROR: `ALFRESCO_TEST`.`alf_qname`:Type mismatch fetching field 1 (should be string, was MYSQL_TYPE_LONGLONG)

Why ? Is it possible make this target definition ?
Thanks for the help

Disalow persistent connexion on MySQL 5.1 running under WINDOWS with ASP (no replies)

Damien BONVARLET — Thu, 02 May 2013 21:14:06 +0000

Hi,

how can i disable /disolow / limit persistent connexions on MySQL 5.1 running under windows with IIS 7.0 (ASP) ?

When google bots or another search engines robots (i presume) visits differents websites host on my windows server, a lot of persistents connexions are created and after serverals minutes / hours my max_connections=300 set in my.ini file is is reaches...

screen copy here http://www.autourdunet.fr/images/mysql.jpg

convert MSSQL job to MySQL (3 replies)

Craig Tompkins — Mon, 06 May 2013 12:18:41 +0000

I have an application that dumps logs into 2 databases. They have been on MSSQL for years and I recently needed to move them to MySQL. In MSSQL 30 days worth of logs would be 150GB. So I had a job running at night that trimmed everything older than 30 days, then did a backup with truncate_only and a shrink log as such:
DELETE FROM ESSyslogMain WHERE recorddate < getdate()- 30
backup log syslog with truncate_only
DBCC SHRINKFILE(syslog_log, 1)

How can I accomplish this in MySQL?
DELETE FROM ESSyslogMain WHERE recorddate < curdate()- 30
seems to take care of the first line, but I'm stuck after that.

Can anyone tell me the code "conversion" for the 2nd and 3rd lines? Can anyone tell me how to schedule a job in MySQL? I have version 5.2.47CE of the workbench installed.
TIA
Craig

Move Data from MySQL to SQL Server via SSIS (no replies)

Andrew Venuto — Mon, 29 Apr 2013 23:47:10 +0000

-------------------------------------------------------------
How to connect and load data from MySQL to SQL Server
-------------------------------------------------------------

1 - Download the 32 bit ODBC driver.

go to the MySQL website and download: “mysql-connector-odbc-5.2.4-ansi-win32.msi”
NOTE: Do not use the 64 bit driver on BIDS 2008. BIDS 2008 is 32 bit. You will get a mismatch error when creating SSIS’s connection manager: “The specified DSN contains an architecture mismatch between the Driver and Application”

2 - Create a User DSN

You need to open the using windows 32 ODBC admin tool. DO NOT open the regular ODBC admin, in control panel. Open the ODBC admin located here: c:\Windows\SysWOW64\odbcad32.exe. If you use the default ODBC admin…it will not work. Additionally you must create a “User DSN” - NOT a System DSN. Otherwise it will not show up in SSIS
NOTE: the screens look the same so you will have no way of knowing whether you are in 32 BIT ODBC Admin tool or not.

3 – Create a new SSIS package and create an ADO.NET connection manager. Create your ADO.NET destination connection and object.(where you want to send the data)

4 – Change the Source ADO.NET properties.

You will get validation errors and your package will not run. You need to change the “ValidateExternalMetadata” to FALSE (in the “Advanced Editor” dialog box) of the ADO.NET source It will also give you metadata error…that’s ok…just click ok. It will still pull the metadata (column names/data types). You cannot select the tables as you would in SQL server. You need to type the SQL select statement.

5 - Run the package and should run and load normally.

money type (1 reply)

Julien Jeanneret — Fri, 03 May 2013 16:18:14 +0000

Hi,

I try to migrate a SQL database to MySQL with MySQL Workbench 5.2 and i have a problem with a field that have a money type with this error 'NoneType' object has no attribute 'numericPrecision'

Do I need to change the field? Or is there a workaround?

Julien

Can I query MSSQL from a MySQL session? (no replies)

Paul Trejo — Thu, 28 Feb 2013 20:42:14 +0000

I have a MySQL database running on Linux. I want to link MySQL to a MSSQL database running on Windows. Not a MySQL database. Not data migration. Not data replication. Not log shipping. I want to open MySQL, enter a query, and obtain data from the MSSQL database itself. I suppose I'm asking how to setup MySQL Linked Server to MSSQL.

WorkBench Migration error (2 replies)

PHILIPPE CHAUVIN — Mon, 04 Mar 2013 23:52:50 +0000

Hello,
i'm trying to migrate an MS SQL Server 2008 R2x64 database to MYSQL 5.1.36 using WorkBench migrating tool.
I've successfully setup the source and target RDBMS (test connection OK).
But for the next step (Fetch shema list), there is a error connecting to DBMS source:

Starting...

Connect to source DBMS...

- Connecting to source...

Traceback (most recent call last):

File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 173, in getServerVersion

ver_string = execute_query(connection, "SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)").fetchone()[0]

File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 62, in execute_query

return get_connection(connection_object).cursor().execute(query, *args, **kwargs)

pyodbc.ProgrammingError: ('42000', '[42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.36]FUNCTION SERVERPROPERTY does not exist (1305) (SQLExecDirectW)')

Traceback (most recent call last):

File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 173, in getServerVersion

ver_string = execute_query(connection, "SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)").fetchone()[0]

File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 62, in execute_query

return get_connection(connection_object).cursor().execute(query, *args, **kwargs)

pyodbc.ProgrammingError: ('42000', '[42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.36]FUNCTION SERVERPROPERTY does not exist (1305) (SQLExecDirectW)')

Traceback (most recent call last):

File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\workbench\wizard_progress_page_widget.py", line 66, in run

self.func()

File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\migration_source_selection.py", line 415, in task_connect

raise e

SystemError: ProgrammingError("('42000', '[42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.36]FUNCTION SERVERPROPERTY does not exist (1305) (SQLExecDirectW)')"): error calling Python module function DbMssqlRE.getServerVersion

ERROR: Error during Connect to source DBMS: ProgrammingError("('42000', '[42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.36]FUNCTION SERVERPROPERTY does not exist (1305) (SQLExecDirectW)')"): error calling Python module function DbMssqlRE.getServerVersion

ERROR: Exception in task 'Connect to source DBMS': SystemError('ProgrammingError("(\'42000\', \'[42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.36]FUNCTION SERVERPROPERTY does not exist (1305) (SQLExecDirectW)\')"): error calling Python module function DbMssqlRE.getServerVersion',)

Failed

Thank for any help.

Write query to test the logic (no replies)

Laksmi Patange — Wed, 13 Feb 2013 05:52:55 +0000

Primary Source: SIEBEL
Source Table: SBL.dbo.S_ORG_EXT
Source Column:PRTNR_TYPE_CD, OU_TYPE_CD, OU_NM, NAME
Secondary Source: SFDC
Source Table: SFDC.dbo.T_ACCOUNT
Source Column: PARTNER_TYPE__C, ACCOUNT_CSN__C, NAME

Siebel Logic: (c=child, p=parent)
,CAST(CASE
WHEN c.[OU_TYPE_CD] IS NULL AND c.[PRTNR_TYPE_CD] IS NULL
THEN 'UNKNOWN'
WHEN UPPER(c.[OU_TYPE_CD]) = 'INTERNAL'
THEN 'INTERNAL'
WHEN UPPER(COALESCE(p.[NAME],c.[NAME])) = 'AUTODESK INC'
THEN 'INTERNAL'
WHEN c.[PRTNR_TYPE_CD] IS NOT NULL
THEN 'PARTNER'
ELSE 'CUSTOMER'
END AS NVARCHAR(50))
AS ACCOUNT_CATEGORY_NM

Multi-column Primary Key (1 reply)

Mark Parr — Wed, 20 Feb 2013 09:42:10 +0000

Running under a MySQL 5.0.45 server, I have created a MyISAM Table containing the columns:

user :: varchar(8)
datetime :: datetime
seqno :: int(11) -- autoincrement
subject :: varchar(20)
text :: text

and have set my Primary Key as multi columns using (user, datetime, seqno).

I did a few INSERTS and all was looking ok but then I had a new INSERT of data appear out of order on the next SELECT. A few more INSERTS worked as expected w/ newer entries appearing at the end of SELECTED data but then another entry again jumped ahead of the older entries.

A current example portion of my data for columns (user, datetime, seqno, subject, text) gets ordered as follows when returning data from a SELECT:

USER1, 2013-02-06 02:24:17, 19, subject 19, text 19
USER1, 2013-02-06 02:24:55, 22, subject 22, text 22
USER1, 2013-02-06 02:24:30, 20, subject 20, text 20
USER1, 2013-02-06 02:24:42, 21, subject 21, text 21

Any ideas why Entry #22 would get placed between 19 and 20 in the data?

Thanks

connect to SQL Server from mysql (4 replies)

SAM B — Wed, 24 Apr 2013 13:20:09 +0000

I am a newbie to this. We do not have SSIS or an ETL tool. How can I connect to MSSQL Server, execute a query and retrieve data into MySQL database? Do I have to write a python script? Are there any other options? Can you provide some details on this?

no connection (no replies)

allison ose — Sun, 20 Jan 2013 04:48:37 +0000

l'm using mySQL 5.1, l wasn't having any issues with connecting but now am.

l ran the wizard a few different ways, the default port is 3306 which l left there.

Have tried rebooting, etc.

SQL Server to MySQL (4 replies)

Robin Oaks — Fri, 11 Jan 2013 20:29:48 +0000

Migrating a SQL Server 2008 R2 database to MySQL Server 5.5 using Workbench 5.2 throws create table error for varchar(max) data types.

The CREATE TABLE script generated for the SQL Server fields of type varchar(MAX) are defined as just varchar with no size like varchar(255). These should be TEXT or one of its variation and when I edit to TEXT, it works. Is there a setting or configuration somewhere that I can set to persist this correction?

Migration error on script view when changing target (no replies)

Support CM2D — Wed, 19 Dec 2012 13:53:53 +0000

Hello,

Thank you for the integration of "Migration".

Thank you for the integration of Migration.
In step "Manual Edditing", it is really convenient to change the target schema name.
But in the case of query views, the migration script automatically adds references to the source, which causes an error.
For example:

Source on Toga_dev1
CREATE
ALGORITHM = UNDEFINED
DEFINER = `root`@`localhost`
SQL SECURITY DEFINER
VIEW `facture_euro` AS
select
`i`.`idimplantation` AS `idimplantation`,
`m`.`time_by_day_idtime` AS `time_by_day_idtime`,
`m`.`valeur` AS `facture_value`
from
((((((`mesures` `m`
join `implantation` `i` ON ((`m`.`implantation_idImplantation` = `i`.`idimplantation`)));

Target on Toga_dev8
USE `Toga_dev8`;

CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost`
SQL SECURITY DEFINER VIEW `Toga_dev1`.`facture_euro` AS
select `i`.`idimplantation` AS `idimplantation`,
`m`.`time_by_day_idtime` AS `time_by_day_idtime`,
`m`.`valeur` AS `facture_value`
from
((((((`Toga_dev1`.`mesures` `m`
join `Toga_dev1`.`implantation` `i` on((`m`.`implantation_idImplantation` = `i`.`idimplantation`))) ;

Is there an option or a solution to address this problem

upload client side data to the MySQL server (1 reply)

Preethi K — Thu, 17 Jan 2013 01:35:58 +0000

Can someone tell me how do i upload the data created in mysql command line client into the Mysql server,
I mean, i have created some tables using mysql command line client in my system, it is accessible only to me. how do i upload it into the mysql server so that i can access those table contents even from other systems.

Conversion problem with cast function (3 replies)

Alberto Molero — Wed, 05 Dec 2012 07:50:14 +0000

Hi all, i have a little problem with cast function in mysql.
I want convert one database (with procedures) in SQL Server to MySQL.
In SQL Server i can do this: Cast(258 As Binary(4)) and return [0, 0, 1, 2], but in MySQL return [32, 35, 38, 00]. The cast function in MySQL convert the number into char and then convert it to binary(4).

I only want do the same that i do with SQL Server...
someone know any solution for this issue?

Table definition:
Create Table If Not Exists TResult(info varbinary(8000));

Insert sample
Insert into tresult (info) values (cast(258 as binary(4)));

SQL Server to MySQL (5 replies)

Deepak Vasudevan — Wed, 19 Dec 2012 12:08:59 +0000

I have a SQL Server database. I would need to have the data structures and procedures migrated to a MySQL database. Are there some jump start tools for this objective?

Is it possible to develop Window using PHP & SQL (no replies)

Deep programmer1 — Fri, 28 Sep 2012 04:06:52 +0000

hello guys ,
i am trying to start building my own operating system , is it possible to develop OS using php and SQL . Thanks in advance

Php Training In Ludhiana

may i set default schema in migration wizard (no replies)

wei hu — Sat, 08 Sep 2012 12:11:45 +0000

may i set default schema in migration wizard when i want to connect to sql server 2005,thx.

i haven't privilege to see the sql server shema.but in dbsync,it has defualt schema,so it can work.

need my sql query pls help (no replies)

salman mohd — Thu, 06 Sep 2012 10:39:12 +0000

I have a table PicUpload and I want to write a query that on a particular date time how many photos uploaded, suppose on 5 September 2012 between 9.00 a.m to 9.10 a.m suppose 20 photos uploaded i.e between 10 mins how much photo uploaded, for this I want a query , I can choose any interval time of day suppose it can be 10 mins, 20 mins, 1 mins etc.waiting for the reply.Please look out the url below for your help

http://img809.imageshack.us/img809/1648/picupload.jpg

need my sql query (1 reply)

salman mohd — Wed, 19 Sep 2012 06:43:39 +0000

How to use MySQL Migration in Workbench (5 replies)

Peter Jin — Wed, 17 Oct 2012 13:46:29 +0000

Just downloaded the newest version of MySQL Workbench, but don't see the migration option in Workbench. How do you access it?

Sync MS SQL data to MySQL (2 replies)

PBL Narasimha Rao — Fri, 24 Aug 2012 06:17:35 +0000

In my organization we use both MS SQL and MySQL.
Some data will be in MS SQL and some will be in MySQL.

We wan to sync the required table fields from MySQL to MS SQL and vise versa when every there is an update/insert/delete of record on specified field on MySQL.
And sechudled sync from MySQL to MS SQL.

how can i fullfill my requirements.

Once Again 4-part Queries are failing with linked Server (no replies)

Randy Pitkin — Wed, 22 Aug 2012 20:02:47 +0000

A recent and complete rebuild of my MSSQLServer and Latest Version of MySQL ODBC is failing to connect to External MySQL Server

That is, a query like:

SELECT * FROM [TRACKER]...[issues]
SELECT * FROM [TRACKER].[bitnami_redmine]..[issues]
worked prior to this migration, but now issues the following error:

Msg 7313, Level 16, State 1, Line 1
An invalid schema or catalog was specified for the provider "MSDASQL" for linked server "TRACKER".

SELECT * FROM OPENQUERY([TRACKER], 'SELECT * FROM Issues')
Returns Expected Results

Tried
SELECT * FROM [TRACKER]..[bitnami_redmine].[issues]
A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.

In forums, I have scene and added "option=3" to the connection string but I do not know what that option refer too.

mssql to mysql query conversion (4 replies)

chris Sellers — Thu, 16 Aug 2012 19:31:58 +0000

I am trying to get started in converting some queries from mssql to mysql.
The information I have gathered so far seems that I need to change the "stuff" statements to group_concat. I am unclear on if the cast statements need modified. and I have tried to modify this darn thing to what I believe it should be, but I can't get it to run! Arrrgg! Anyone have some advice for this conversion? There is no query migration tool that I can find, which seems logical given the complexity of such a tool. I would like to add I know nothing of mssql, but I am fair at mysql.

Here is one of the queries in question.

SELECT DISTINCT c.name Cluster, s.name Server. stuff( ( SELECT cast(', ' as varchar(max)) + sc2.name FROM Server_contact AS sc2
WHERE sc2.Server_ID=s.Server_ID ORDER BY sc.name
for xml path('')
), 1, 1, '')
AS 'Server Contact',
(SELECT c.name FROM Cluster c WHERE c.Cluster_ID=s.virtual) 'Virtual on', a.name Application,

stuff( ( SELECT cast(', ' as varchar(max)) + ac2.name FROM app_contact AS ac2
WHERE ac2.App_ID=ac.App_ID ORDER BY ac.name
for xml path('')
), 1, 1, '')
AS 'Application contact',
stuff(
(
select cast(',' as varchar(max)) + s3.name
from Server s3
LEFT JOIN App_affect apaf on apaf.App_ID=a.App_ID
LEFT JOIN affected aff on aff.aff_ID=apaf.aff_Id
WHERE aff.Server_ID=s3.Server_ID AND apaf.Server_ID='".$_REQUEST['server']."'
ORDER BY s.Name
for xml path('')
), 1, 1, '')
AS 'App Affected Server',

stuff(
(
select cast(',' as varchar(max)) + a3.name
from Application a3
LEFT JOIN App_affect apaf on apaf.App_ID=a.App_ID
LEFT JOIN affected aff on aff.aff_ID=apaf.aff_Id
WHERE aff.App_ID=a3.App_ID AND apaf.Server_ID='".$_REQUEST['server']."'
ORDER BY s.Name
for xml path('')
), 1, 1, '')
AS 'App Affected Application'

FROM Server s
LEFT JOIN Server_Cluster scl ON s.Server_ID = scl.Server_ID
LEFT JOIN Cluster c ON c.Cluster_ID = scl.Cluster_ID
LEFT JOIN Server_contact sc ON s.Server_ID = sc.Server_ID
LEFT JOIN Server_App sa ON s.Server_ID = sa.Server_ID
LEFT JOIN Application a ON a.App_ID = sa.App_ID
LEFT JOIN App_contact ac ON a.App_ID = ac.App_ID
LEFT JOIN Server_affect saf ON s.Server_ID = saf.Server_ID
LEFT JOIN Affected aff ON aff.aff_ID = saf.aff_ID
WHERE s.Server_ID='".$_REQUEST['server']."'
ORDER BY c.name DESC, s.name ASC
";

Moving from Microsoft SQL SERVER 7.0 to MYSQLSERVER 5.5 (2 replies)

Mananchai Rojamornkul — Wed, 17 Oct 2012 10:04:57 +0000

Hi,

I've just moved from Microsoft SQL SERVER 7.0 to MYSQL SERVER 5.5
I've installed MYSQL SERVER 5.5 and MySql Workbench 5.2 CE

I changed the version due to the new server I've bought to replace my PC working as a server.

So, the first problem I encountered was that I can't import my old database into this new version of MYSQLSERVER 5.5.

The old database from Microsoft SQL SERVER 7.0 were consisted of two files: "dataname".mdf and "dataname".ldf

My question is would it be possible for me to import .mdf and .ldf file including its tables' content to this new version of MYSQL server 5.5.

If applicable, please advice
If not, please tell me the other ways

Thank you in advance

Copy the data from different host and database (no replies)

ashin aseneta — Fri, 20 Jul 2012 04:04:43 +0000

Hi everyone,

how can i copy the data from db1.table to db2.table with different username and password?

Example.
the username/pass of db1.table is username: host1 password: host1
and
the username/pass of db2.table is username: host2 password: host2

So how can i make the command here?

thanks

during migrating data from msql 2008 server to mysql server i am faced with the error message.-- Any help would be appreciated (no replies)

chandan vijayvargiya — Sat, 14 Jul 2012 11:20:00 +0000

ALTER PROCEDURE [dbo].[proc_ltcmigrate_residents]
AS
BEGIN

/*
PersonFriendlyId is ported as NULL.
FacilityId is determined based on the following rules in order
a. If there is a valid facilityid in ltcperson that is taken
b. Check the last bed activity in ltcbedschedule and choose that facility
c. Check the last batch activity and choose that facility in batch
d. default to 1
*/

Insert lee_mig...ltcperson
(
ltcPersonID
,FirstName
,LastName
,PersonFriendlyID
,ApplicableAdmissionDate
,Archived
,ArchivedDate
,ArchivedByUserID
,ProgressNoteDays
,ltcOrganisationID
,oldPersonID
,CreatedBy
,CreatedDate
)
SELECT
P.PersonID
,FirstName
,LastName
,PersonFriendlyID
,ApplicableAdmissionDate
,Archived
,ArchivedDate
,case when ArchivedByUserID=-1 then null else ArchivedByUserID end
,ProgressNoteDays
,COALESCE(case when P.FacilityID>0 then P.FacilityID else null end, LastActiveFacility.FacilityId, (select top 1 FacilityID from ltcbatch b where b.PersonId=P.personid and FacilityID>0 and FacilityID is not null order by BatchID desc), 1)
,OldPersonID
,(select top 1 userid from ltcbatch b where b.PersonId=P.personid and b.UserID<>0 order by BatchID)
,(select top 1 DateCreated from ltcbatch b where b.PersonId=P.PersonID order by BatchID)
FROM ltcPerson P
left join
(
SELECT DISTINCT v.OrgID FacilityId, LBS.PersonID from ltcBedSchedule LBS inner join
(Select Max(ID) ID, PersonID from ltcbedschedule where PersonID>0 and BedPK>0 group by PersonID) MLBS on LBS.ID=MLBS.ID
inner join vwBeds v on v.BedPK=LBS.BedPK
) LastActiveFacility on LastActiveFacility.PersonID=P.PersonID
where exists(select * from ltcBatch b where P.personid=b.personid)

insert lee_mig...ltcbeds
(
BedPK
,RoomID
,PersonID
,BedName
,Status
,DateFrom
,BedGPSX
,BedGPSY
)

select

BedPK
,RoomID
,case when PersonID <=0 then null else PersonID end
,BedName
,Status
,DateFrom
,BedGPSX
,BedGPSY

from ltcbeds

After executing this procedure I get an error
OLE DB provider "MSDASQL" for linked server "lee_mig" returned message "[MySQL][ODBC 5.1 Driver][mysqld-5.5.12]Cannot add or update a child row: a foreign key constraint fails (`ltcdb_prod`.`ltcperson`, CONSTRAINT `fk_ltcperson_ltcuser1` FOREIGN KEY (`ArchivedByUserID`) REFERENCES `ltcuser` (`UserID`) ON DELETE NO ACTION ON UPDATE NO ACTION)".
Msg 7343, Level 16, State 2, Line 1
The OLE DB provider "MSDASQL" for linked server "lee_mig" could not INSERT INTO table "[lee_mig]...[ltcperson]".

To debug the error I executed a query and found that there are some UserID which doesn’t exist in ltcuser. And the UserID is a primary key in ltcuser.

Please let me know if u guys need some further information.

I am facing an error while migrating data from sql server 2008 to mysql server (no replies)

chandan vijayvargiya — Sat, 14 Jul 2012 11:11:29 +0000

insert data from MySQL into SQL Server (5 replies)

vincent arc — Wed, 08 Aug 2012 08:48:30 +0000

Hi,

i want to make my SQLServer can automatically get data from mysql and insert it into my SQLServer table, anyone know how to do this?

mysql table :
tbl_downtime (date datetime, downtime varchar, uptime varchar)
2012/07/09, 09:34:00, 10:00:00
sql server table :
tbl_downtimeMS (date datetime, downtime varchar, uptime varchar)

i cant change the apllication to get data and insert it into MSSQL, because i dont have the source. thats why i need to make it from the database.

Thanks

importing data from sql server (5 replies)

harishanker srivastava — Fri, 10 Aug 2012 21:27:23 +0000

hi ,

i want to change my server's database from sql server to mysql. I have tried this by exporting data in .sql format and importing in mysql server. But it gave me error and leave the whole task in middle can please anybody help