Database Migration and Sync from MS SQL to mySQL - Database Discussion Boards

mohammed.alchalabee28-Jan-16 7:48

28-Jan-16 7:48

I want to create an ACCESS database of e-learning includes two class and a number of students and 4 tests and find out any test students liked by data mining

Re: data base and data mining

ZurdoDev28-Jan-16 8:48

ZurdoDev

28-Jan-16 8:48

OK. Do you have a question?

There are only 10 types of people in the world, those who understand binary and those who don't.

Re: data base and data mining

Eddy Vluggen29-Jan-16 2:12

Eddy Vluggen

29-Jan-16 2:12

That's not data-mining; you simply need to track how often a student logs in on a test, and select the one with the most visits.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Sqlconnection

Member 1228733728-Jan-16 4:13

Member 12287337

28-Jan-16 4:13

Hi all.am really new to asp.net,c# as well as sql.i hope you will help me on this.
i want to call my stored procedure from my class file. and later create an instance of the class in the .aspx.cs file.to do this i have to create a connection object and pass in my configuration key from web.config. that is where am stuck because i had used this：
SqlConnection connection = new SqlConnection （ ConfigurationManager.ConnectionStrings [‘’B.F.M.S"].ConnectionString）；
B.F.M.S is my sql database.
Now when i run my application its giving a [NullReference Exception： Object reference not set to an instance of an object].
the error is with that line.
Can you please help on how i can rectify that.

[REPOST] Sqlconnection

Richard Deeming28-Jan-16 4:27

Richard Deeming

28-Jan-16 4:27

You have already posted this in the ASP.NET forum. Posting the same question in multiple forums duplicates work and annoys people.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Elvis Cristobal

Member 1176371525-Jan-16 7:57

Member 11763715

25-Jan-16 7:57

una ayuda por favor , se puede trabajar en una tabla con la llave primaria que tenga letras y números y que esta se generen automáticamente al hacer un mantenimiento desde ASP.NET??

Re: Elvis Cristobal

Richard Deeming25-Jan-16 8:37

Richard Deeming

25-Jan-16 8:37

This is an English-language site. Please edit your question and post it in English.

Este es un sitio en idioma Inglés. Edite su pregunta y que lo ponga en Inglés.
(Google Translate[^])

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Database Migration and Sync from MS SQL to mySQL

NickPace22-Jan-16 10:33

NickPace

22-Jan-16 10:33

I'm looking for a tool that can migrate a MS SQL Server 2014 database to the latest version of MySQL. The migration includes just tables (structure, keys, indexes, etc.) and their data. Then the product needs to sync any data changes made to the SQL Server database with the MySQL database until I'm confident that the changeover of codebases to MySQL are complete...basically inserts, updates, and deletes. There will not be any schema changes allowed during the migration.

Downtime of the database for a migration is not really an option. In addition, I'm not too keen on the idea of modifying the data access layers to work with both databases (there's a lot of customization I would have to work with). So it seems to me the best place to do this is at the database level itself.

I've been researching tools such as SymmetricDS and ConvertDB. Does anyone have experience with these products that they would like to share? Any other suggestions?

-NP

Never underestimate the creativity of the end-user.

modified 22-Jan-16 17:32pm.

Re: Database Migration and Sync from MS SQL to mySQL

Eddy Vluggen22-Jan-16 11:17

Eddy Vluggen

22-Jan-16 11:17

NickPace wrote:
Any other suggestions?

Yes; change your requirements.

NickPace wrote:
Then the product needs to sync any changes made to the SQL Server database with
the MySQL database until I'm confident that the changeover of codebases to MySQL
are complete.

That would include changes to structure and relations.

NickPace wrote:
Downtime of the database for a migration is not really an option

Then don't change your database structure while your database is up.

Take a look into the sync-framework Thumbs Up | :thumbsup:

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: Database Migration and Sync from MS SQL to mySQL

jschell22-Jan-16 14:14

jschell

22-Jan-16 14:14

NickPace wrote:
until I'm confident that the changeover of codebases to MySQL are complete

I am with the other responder in that the statement of your situation is either unclear or the actual requirements have not been defined.

I spun up a number of possibilities but there are just too many to cover. I would suggest that you start by defining exactly and specifically how you will determine that the new solution is working correctly before doing anything else.

Additionally unless very strict coding practices were followed the chances that no code changes are needed are rather slim.

Re: Database Migration and Sync from MS SQL to mySQL

Mr.Roga23-Jan-16 21:29

Mr.Roga

23-Jan-16 21:29

You can use an application named sqlyog. You'll have to copy all the queries used in ms sql server and this can be used to create a database that is same , for mysql. I hope my answer is useful.

Accessing SQL server w/Oracle SQL Developer

Member 1228129922-Jan-16 6:19

Member 12281299

22-Jan-16 6:19

I have SQL Developer 4.1.3 on my PC. I am able to access SQL Server 2008 on a remote server, but only if I specify a USERID/PWD combination. Ideally, I would like to let SQL Server interegate our UID/PWD combination from our DOMAIN login. Does anyone have experience with getting SQL Server to allow login by the UID/PWD values obtained from Domain login?

Re: Accessing SQL server w/Oracle SQL Developer

Eddy Vluggen22-Jan-16 7:02

Eddy Vluggen

22-Jan-16 7:02

Google for "How to set up Windows Authentication Mode security" and read this[^].

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

access data base

mohammed.alchalabee21-Jan-16 10:39

mohammed.alchalabee

21-Jan-16 10:39

i have a student data base in access i need help to add some question forms and a counter for which form is active ie which form the student like ??

Re: access data base

Corporal Agarn22-Jan-16 0:40

Corporal Agarn

22-Jan-16 0:40

So, do you want to keep track of which form is used and how often? Do you want to track counts by student?

Mongo: Mongo only pawn... in game of life.

Re: access data base

mohammed.alchalabee22-Jan-16 8:55

mohammed.alchalabee

22-Jan-16 8:55

yes

MySQL Transaction

Gilbert Consellado20-Jan-16 23:28

Gilbert Consellado

20-Jan-16 23:28

It could be a dumb question, and tried to search for it and found nothing.

I been using mysql for years(not that to long) but i never had tried mysql transactions. Now my question is, what would happen if i issue an insert or delete statement from multiple clients using transactions? does it would lock the table and prevent other client to perform there query? what would happen if other client issue a transaction query while the other client still have unfinished transaction?

I appreciate for any help will come.

P.S. most likely i will use insert using a file or csv it could be a big chunk of data or just a small one.

Re: MySQL Transaction

Eddy Vluggen22-Jan-16 1:42

Eddy Vluggen

22-Jan-16 1:42

Depends on how you want the server to react;

MySQL :: MySQL 5.7 Reference Manual :: 13.3.6 SET TRANSACTION Syntax[^]

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Not able to Login to the database after restoring on the different Server

indian14320-Jan-16 15:52

indian143

20-Jan-16 15:52

Hi All,

I have two database servers, one Dev and another one Test, I made lots of changes on Dev hance I tried to restore the backup of Dev Database on Test Server with same name everything same. Now with the same Credentials Login and Password my web application is failing to access the database on Test, by saying failing to access the Database.

Can anybody please help me in getting out of this situation. All I did was, Dev and Test are two different physical servers, took backup of Dev and restored it on the test, now Login fails.

Any help a link code snippet or even a suggestion helps a lot. Thanks in advance.

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."

Re: Not able to Login to the database after restoring on the different Server

Mycroft Holmes20-Jan-16 16:33

Mycroft Holmes

20-Jan-16 16:33

After restoring a database I run this script to drop and add the expected users. It assumes the users are already created on the new server. The underlying ID for the user name will be different on each server.

SQL

Declare @Usr varchar(50),
    @SQL as varchar(5000)

Declare csrPV Cursor Fast_Forward For
    Select name
    From sysusers
    Where issqluser = 1
        and hasdbaccess = 1
        AND name NOT IN ('dbo','IBMSQLDBA')

OPEN csrPV 

FETCH NEXT FROM csrPV INTO @Usr

WHILE @@FETCH_STATUS = 0
BEGIN

    Set @SQL = 'DROP USER [' + @Usr + ']'
    Print @SQL
    exec (@SQL)

    Set @SQL = 'CREATE USER [' + @Usr + '] FOR LOGIN [' + @Usr + '] WITH DEFAULT_SCHEMA=[dbo]'
    print @SQL
    exec (@SQL)

    Set @sql = 'ALTER LOGIN [' + @Usr + '] ENABLE'
    exec (@SQL)

    EXEC sp_addrolemember N'db_owner', @Usr

    FETCH NEXT FROM csrPV INTO @Usr
END
CLOSE csrPV
DEALLOCATE csrPV