PASS ACCOUNTS "DATA" TO ANOTHER DATABASE


THERE ARE 2 WAYS TO DO THIS: 
1) IS USING AN EXTERNAL PROGRAM THAT ARM THE QUERY  
2) IS TO USE THE OWN SQL SERVER TO TRANSFER EVERYTHING BUT IN MY WAY RECOMMENDING THE FIRST OPTION, THEN ARMO ANOTHER POST TO SEE HOW IT IS USED SQL SERVER 2008 

First we download this. 



Navicat Premium x86 x64
https://mega.nz/#!vh8CCSLY!bXY0NY8zF03pO1LXGOY-mN_T4TBRnHjs5B5h4ld0mAc



If your computer detects as a virus do not worry because it is the keygen :) they 
can download quietly. 

I recommend for more fluids to do it from the VPS since if we have many accounts to pass this it would take longer. 

After installing the NAVICAT software and then VALIDATE it to be a FULL product, we proceed to make the connection of the server and the pc that you want to build the query. 


Then our server appears on the left bar: 

1) we double click on the name that we put
Spoiler  for  Hiden :  




2) again double click on MUONLINE 
3) then double on BOD

Spoiler  for  Hiden :  

4) Select "FILE" 
5) Select SQL SERVER 2008 R2 
6) Current Windows Codepage 
7) Then select in the database panel the table that says "MEMB_INFO" which is where the accounts are saved.

Spoiler  for  Hiden :  












Now we have our file "db.sql" that we must put in the new server that we want to pass the accounts and execute it so that the accounts are imported into the new database.

Comments