MySQL To MS SQL(Not This Topic Again!! ;-))
Feb 26, 2008
Hi,
I am trying to extract data from a MySQL DB. I have installed the MySQL Connector (mysql-connector-odbc-3.51.23-win32), then set up an ODBC connector in the Control Panel > ODBC.
Then in BIDS I have setup a new ODBC connection in Connection Managers, and then used the ODBC connection I setup above so at that point everything looks cool.
Now what? Do I setup a Execute SQL Task or how do I get the data out and into a Data Flow Task?
Thanks
View 3 Replies
ADVERTISEMENT
Feb 14, 2006
Hi,I wanted to know how actually a database converter works.I am working on a converter from DBF to MS SQL server 2000using Visual Basic 6.0. I wanted to know that once a legacy databaseis enterd in the program, how does it get normalised.I have aboout 40 tables in DBASE IV format. I want to convert theminto relational database and store them on server. But on conversion,how can the converted data be normalised by itself.Awaiting the replies,Thanks
View 2 Replies
View Related
Jun 20, 2003
Does anyone know if there is a way to set a screensaver to auto log off users?
thanks for your time.
View 4 Replies
View Related
Dec 4, 2006
I absolutely agree with you.
I managed to find the error, it was a typo.
Here is the code, if somebody is interested about it. It is oracle, not SQL server, but the idea is the same.
drop view a;
drop view b;
drop view figure5_9;
create view a
as
select d.donorID, dt.donortype, dt.donortargetq1
from donortype dt, donor d
where d.donortype=dt.donortype;
select * from a;
create view b
as
select a.donortype, sum(c.ContributionAmount) as amount
from Contribution c, a
where c.ContributionDate between '01-JAN-06' and '31-MAR-06' and a.donorID=c.donorID
group by a.donortype;
select * from b;
create view figure5_9
as
select b.donortype, a.donortargetq1, b.amount, b.amount/a.donortargetq1 as percentage
from a, b
where a.donortype=b.donortype
group by b.donortype, a.donortargetq1, b.amount;
select * from figure5_9;
Thanks for the help anyway ;-)
View 2 Replies
View Related
Sep 14, 2006
I'm in China doing TechEds in Shanghai, Guangzhou, Beijing and Hong Kong - returning to the office Monday 2nd October.
There may be significant delays in my replies to any topics on this forum. Just fyi so you don't sit waiting for me to respond.
Thanks
Paul Randal
Lead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
View 4 Replies
View Related
Dec 13, 2006
It's been pretty quiet here recently - hopefully people either aren't experiencing corruptions or they're finding what they need in the previous threads.
Just a quick note to say that I'll be totally offline from tomorrow until January - going diving in Indonesia (http://www.wakatobi.com).
Happy holidays and may your pagers be silent throughout
Cheers
Paul Randal
Principal Lead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
http://blogs.msdn.com/sqlserverstorageengine/default.aspx
View 4 Replies
View Related
Jul 23, 2005
Plz helpHow to find my previous topic??CheersDishan
View 1 Replies
View Related
Sep 23, 2005
I'm thinking of doing some basic parsing of address. I want to seprateout the house number from the street name from the suffix. I have thesuffix's from the USPS, but I cant find a database of US street names.Anyone come across one or know where I can get one?TIARob/end off topic
View 2 Replies
View Related
Nov 15, 1999
Hi all!
Is there a possibility to call (and receive records) SQL Server (or other databases) procedure from MS Access?
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
Aug 1, 2006
I have 2 problems:
1) When I run this, etch time I keep getting the error saying that constraint isn't found when I try to drop because my creation of the constraint at the end for some reason isn't creating it or being run
2) The first insert doesn't insert anything, although I get no errors
ALTER PROCEDURE Categories_I
3) I also get this when trying to run just the first 2 insert statements together
Msg 2627, Level 14, State 1, Line 7
Violation of PRIMARY KEY constraint 'Category_PK'. Cannot insert duplicate key in object 'Category'
ALTER PROCEDURE [domainnamemyaccountname].[Categories_I]
AS
BEGIN
/* delete contents from Category table and reseed
Cannot use truncate on a table which contains constraints therefore
use DBCC to reset the seed and DELETE to clear the records
*/
DELETE dbo.Category
DBCC CHECKIDENT ('Category', RESEED, 0)
-- Now, insert the initial 'All' Root Record
ALTER TABLE dbo.Category DROP CONSTRAINT Category_Category_FK1
PRINT 'Dropped FK'
SET IDENTITY_INSERT Category ON
INSERT INTO dbo.Category
(CategoryId, ParentCategoryID, [Name], [Description], DisplayOrder, DisplayInExplorer, Keywords, Active, CreateDate, CreateUserID)
SELECT 1, 1, CategoryName, '', 1, 1, '', 1, GETDATE(), 1 FROM CategoriesStaging WHERE CategoryName = 'All'
PRINT 'Inserted All Record'
INSERT INTO dbo.Category
(CategoryID, ParentCategoryID, [Name], [Description], DisplayOrder, DisplayInExplorer, Keywords, Active, CreateDate, CreateUserID)
SELECT 2, 1, CategoryName, '', 1, 1, '', 1, GETDATE(), 1 FROM CategoriesStaging WHERE CategoryName = 'Store'
PRINT 'Inserted Store Record'
SET IDENTITY_INSERT Category OFF
/* Finally, insert the rest and match on the Parent
Category Name based on the CategoryStaging table
*/
WHILE (@@ROWCOUNT <> 0)
BEGIN
INSERT INTO dbo.Category
(ParentCategoryID, [Name], [Description], DisplayOrder, DisplayInExplorer, Keywords, Active, CreateDate, CreateUserID, UpdateDate, UpdateUserID)
SELECT c.CategoryID, s.CategoryName, '', 1, 1, '', 1, GETDATE(), 1, GETDATE(), 1
FROM Category c INNER JOIN CategoriesStaging s ON c.[Name] = s.ParentCategoryName
WHERE NOT EXISTS (SELECT 1 FROM Category c WHERE s.[CategoryName] = c.[Name])
END
PRINT 'Inserted Rest of Category Records'
PRINT 're-create FK Call'
ALTER TABLE dbo.Category
ADD CONSTRAINT Category_Category_FK1 FOREIGN KEY
(
ParentCategoryID
) REFERENCES Category (
CategoryID
)
PRINT 'create FK2'
END
Other errors:
(1 row(s) affected)
Checking identity information: current identity value '2', current column value '0'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 3728, Level 16, State 1, Line 6
'Category_Category_FK1' is not a constraint.
Msg 3727, Level 16, State 0, Line 6
Could not drop constraint. See previous errors.
ALTER TABLE statement conflicted with COLUMN FOREIGN KEY SAME TABLE constraint 'Category_Category_FK1'. The conflict occurred in database 'Chefs2', table 'Category', column 'CategoryID'.
Schemas & Data:
http://www.webfound.net/category.bmp
http://www.webfound.net/category.sql
http://www.webfound.net/categoriesstaging.sql
http://www.webfound.net/stagingdata.txt
View 1 Replies
View Related
May 7, 2004
Hi,
The subject say it all :)
I have a field which stores date which the datetime datatype... The problem is that I am also getting time information in this stored field.
I just want to extract the date part in dd-Mmm-yy format (e.g. 07-May-04). I tried convert (char (8), MyDateField, 112) but it gives me date in yyyymmdd format. How do I get the results in dd-Mmm-yy format instead?
Thanks.
View 7 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
May 14, 2007
Hello,I'd noticed when looking at the prices of hosting ASP websites that it was much cheaper if you useda mysql database instead of mssql so this is the way that I coded everything. I've been using the logincontrol too though so does this mean... 1) that I *need* a mssql database?2) that this database will take up my 1 allocated mssql database with the webhost?3) can I use mysql in the same website; it seems to be working ok with the developer server... Many thanks folks,Adam
View 5 Replies
View Related
Nov 29, 2001
Has anyone ever connected to a MySQL DB? If so, did you encounter difficulties? Did you do it through DTS? Can you give me some specifics?
DenverDBA
View 1 Replies
View Related
Apr 27, 2004
puuuuuuuuuuuuuuuleeeeeeeeeeze
Sorry....
View 6 Replies
View Related
Feb 19, 2007
Can anybody see what is wrong with this?
create table transaction
(txn_id int not null IDENTITY(1,1),
txn_date datetime not null,
account_id int not null,
/*txn_type_cd enum('DBT','CDT')*/check(txn_type_cd('DBT','CDT')),
amount double(10,2) not null,
teller_emp_id smallint ,
execution_branch_id smallint ,
funds_avail_date datetime,
constraint fk_t_account_id foreign key (account_id)
references account (account_id),
constraint fk_teller_emp_id foreign key (teller_emp_id)
references employee (emp_id),
constraint fk_exec_branch_id foreign key (execution_branch_id)
references branch (branch_id),
constraint pk_transaction primary key (txn_id)
I'm getting an error when I try and run in, but I can't see what it is!
Incorrect syntax near the keyword 'transaction'.
The code has been generated as mysql, and I am attempting to change it to SQL.
Thank you!
View 3 Replies
View Related
Jan 9, 2006
HiHow is SQL Server 2000 better than MySQL? I need to convince my boss as weare contemplating doing a website with either SQL Server 2000 or MySQL asbackend.ThanksRegards
View 4 Replies
View Related
Jul 20, 2005
Hi all, i've just set up an mysql server on my computer and now i want toconnect to a mysql database with an ASP page but i can't find the correctconnection string. I always get an error that the datasource can not befound.ConnString ="Driver={MySQL};SERVER=mysqlhost;DATABASE=myDB;UID= userID;PASSWORD=pasword"What's wrong with it?
View 1 Replies
View Related
Jul 20, 2005
hellosomeone could tell me how could I insert SQL statement in a C++ code ?If you know online documents easy to read about this subject, it will bevery welcome(in english or in french)..Thanks
View 1 Replies
View Related
Jul 20, 2005
hola! alguno sabe como uso el top en el mysql??? debo hacer lasiguiente consulta y no le gusta al mysqlSELECT TOP 10 * From ControlDeCaja WHERE CodUsuario = "xxx"alguien sabe? Gracias de todas maneras!!
View 1 Replies
View Related
Jan 31, 2006
Is SQL Server Express the same as MySQL?
View 1 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
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
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
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
Mar 26, 2004
hi..
may i know how to convert from mysql to microsoft sql server ??
is it very troublesome ??
coz its quite a big project..
i need to convert frm mysql to sql..
is there any example or reference?
thanks
View 7 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
Mar 7, 2000
Does anyone know of a page that compares the performance of SQL Server 7 to mysql?
View 2 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
Mar 31, 2003
Hi
I am a newbee to both php and MySQL.
I was wondering if I could get some assiatance on a matter:
I have a userdatabase in flatfile format. The user info is divided into many files:
First the main file where all the usernames are listed in one column. Then one separeate file for each user, named [username].dat containing their userinfo with encrypted password.
Is there a way I can import all these files (almost 300 of them) into a single MySQL table? If so, could someone please explain this to me in easy terms? Thanks.
Charlotte
View 3 Replies
View Related
Mar 23, 2004
Hello there...
Well i want to ask that.... is it posible to Convert MS Sql server Tables/Views + Database to MySql server.....? or is there any software which can automatically convert MS Sql Server database into MySql database.
I'll be REALLY GLAD if someone can please help me asap...
take care...
Regards
Nabeel Qaisar
View 1 Replies
View Related
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
