Link to home
Start Free TrialLog in
Avatar of tut404
tut404

asked on

EMS MS SQL Manager Lite Database

Hi All,

I have a Windows 2003 Server installed the EMS MS SQL Manager Lite 1.8.5.2 and Database inside.

I want to copy out the Database from above Server into another server which is installed the latest version of EMS MS SQL Manager Lite (SQL Manager 2005 Lite for SQL Server 2.3.0.4)

I am not sure where is the Database location, is possible for me copy out the DATABASE to another Server? Where is the Database store?

If you have familiar EMS MS SQL Manager Lite, please advise.

Thanks. Tut404
Avatar of ptjcb
ptjcb
Flag of United States of America image

I have used EMS MS SQL Manager Lite 2.2 +. Under Tools there is an EXTRACT Database. This tool will let you script the data structure and data. You can save this script to a location. I tried this on a small database and it worked. You would then have to copy this script to the other server and then run the script.
Avatar of tut404
tut404

ASKER

Hi,

Can you explain more details? Under the Tool, I can see:-

Show SQL Editor
New SQL Editor
SQL Monitor
SQL Script
Login Manager
Grant Manager

I cannot see EXTRACR Database option there....

Are you asing me write the SQL Scritp copy out the database?
ASKER CERTIFIED SOLUTION
Avatar of ptjcb
ptjcb
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tut404

ASKER

I still can not find where is the "Extract Database" function from the EMS MS SQL Manager Lite 1.8.5.2.

Anyone can help?