Alternative Way to Import SQL to MYSQL

[earvinnill]

Before, I asked a question in here how to linked the SQL to MYSQL. It was a success and I can also query from it. The problem is upon searching why "I can't find SQL SERVER AGENT" in SQL SERVER MANAGEMENT STUDIO EXPRESS EDITION is because it is "EXPRESS". All the ideas that I will be working using SQL Scheduler will unable to continue because the management studio that I have is not capable of it.

Can I have alternative way where in I can create scheduler or scheduled time for Transferring the SQL to MYSQL.


Thank you.

[jmcilhinney]

There's a Task Scheduler built into Windows, which you can access from Control Panel -> Administrative Tools.

[DEXWERX]

SQL SERVER AGENT? get off my lawn!

but seriously... script it and put it in the crontab is how it's been done since the dawn of computing.


edit: not to confuse the issue, but Task Scheduler is the Windows equivalent of cron.

[earvinnill]

There's a Task Scheduler built into Windows, which you can access from Control Panel -> Administrative Tools.

what should i use to create script like that to implement in task scheduler

[jmcilhinney]

Whatever you can do from a command prompt, you can do from Task Scheduler. You can invoke an EXE written in VB or a PowerShell script or whatever you want.

[ChrisE]

Can I have alternative way where in I can create scheduler or scheduled time for Transferring the SQL to MYSQL.
Thank you.

Hi create your own Countdown ....

Option Explicit

Private NextAction As Date
Private Interval As Long
Private IntervalType As String

Private Sub Command1_Click()
   
   Dim i As Long
   
      'next full hour
      i = Hour(Now)
      Interval = 1
      IntervalType = "h"
      NextAction = DateAdd(IntervalType, Interval, Date + CDate(i & ":00:00"))
      Timer1.Interval = 1000
      Timer1.Enabled = True
      
      Label2.Caption = Format(NextAction, "dd.mm.yyyy hh:nn:ss")
      Command4.Caption = "Stop"
End Sub

Private Sub Command2_Click()

   Dim i As Long
   
      'every 10sec.
      Interval = 10
      IntervalType = "s"
      NextAction = Now
      Timer1.Interval = 1000
      Timer1.Enabled = True
      Label2.Caption = Format(NextAction, "dd.mm.yyyy hh:nn:ss")
      Command4.Caption = "Stop"
End Sub

Private Sub Command3_Click()

   Dim i As Long
   
      'every 2min.
      Interval = 2
      IntervalType = "n"
      NextAction = Now
      Timer1.Interval = 1000
      Timer1.Enabled = True
      NextAction = DateAdd(IntervalType, Interval, Date + CDate(i & ":00:00"))
      Label2.Caption = Format(NextAction, "dd.mm.yyyy hh:nn:ss")
      Command4.Caption = "Stop"
End Sub

Private Sub Command4_Click()

      Timer1.Enabled = False
      Command4.Caption = "Stopped"
End Sub

Private Sub Form_Load()

      Command1.Caption = "every hour"
      Command2.Caption = "every 10sec."
      Command3.Caption = "every 2min."
      Command4.Caption = "Stop"
End Sub

Private Sub Timer1_Timer()

   Dim s As String
   
      s = "Countdown " & Format(NextAction - Now, "hh:nn:ss")
      If NextAction > Now Then
         If Label1.Caption <> s Then
            Label1.Caption = s
         End If
         Exit Sub
      End If
      
      NextAction = DateAdd(IntervalType, Interval, Now)
      Timer1.Enabled = False
      'your action here
      
      List1.AddItem "Action " & Format(Now, "dd.mm.yy hh:nn:ss")
      Timer1.Enabled = True
      Label2.Caption = Format(NextAction, "dd.mm.yyyy hh:nn:ss")
End Sub