Wrox Programmer Forums
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 7th, 2004, 04:50 PM
Authorized User
  
Join Date: Jun 2003
Posts: 97
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to planeswalk
Default Export SQL db to MSDE
Hi,

Can anyone tell me how to export an SQL database to an MSDE engine? I'm trying to get this Windows 2003 server's MSDE populated with values from an existing SQL 2000 db but it's rejecting the .sql script I generated from the SQL 2000. Is there an easier way to do this other than going through the webadmin panel of the MSDE?

Many thanks!!!

Regards,
Marlon




Marlon Villarama
 
Old October 8th, 2004, 03:44 PM
Friend of Wrox
  
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default
You posted this on SQL Server DTS , see answer http://p2p.wrox.com/topic.asp?TOPIC_ID=20380

Jaime E. Maccou
Applications Analyst





Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I export an access db table to xml? solos VB How-To 4 April 3rd, 2007 11:56 PM
Export SQL 2000 to MSDE planeswalk SQL Server DTS 3 October 12th, 2004 08:33 PM
Export to XML from DB HamishF SQL Server 2000 8 December 21st, 2003 05:42 PM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.