[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 467
  • Last Modified:

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
0
tut404
Asked:
tut404
  • 2
  • 2
1 Solution
 
ptjcbCommented:
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.
0
 
tut404Author Commented:
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?
0
 
ptjcbCommented:
On my version of EMS SQL Manager Lite I have:

Show SQL Editor
New SQL Editor
SQL Monitor
SQL Script
New SQL Script
Extract Database
Login Manager
Grant Manager
External Tools
0
 
tut404Author Commented:
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?
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now