Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Move data from MSDE to SQL 2000

I want to be able to use the MSDE for my development work and creating the database then when completed move the data over to SQL Server 2000. How do I go about doing this . I am using VB.Net as the front end interface.
0
Idarac
Asked:
Idarac
  • 2
2 Solutions
 
Jeff CertainCommented:
The connection strings should be identical for SQL and MSDE, assuming you have the same user in both servers, with the same password and same permissions...
0
 
Jeff CertainCommented:
Sorry... post to the wrong question...
0
 
andrewbleakleyCommented:
backup the MSDE then restore it to sql server - that is about the simplest way
0
 
bainesy21Commented:
MSDE files can be mounted through Enterprise Manager in the same way as a normal SQL Server DB.  You can use any method supported by Enterprise Manager/Query Analyzer to mount the MSDE files in SQL Server.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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