Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
|
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics 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 May 2nd, 2007, 08:13 AM
Authorized User
 
Join Date: Apr 2007
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for your answer Peter,

However, it does not help me because it is not what I am asking.

I can connect to SQL Express on my local development machine but not on the server where it will be running. However, I can import the content of a sql or CSV file using a web tool provided to me by godaddy.

So what I need is a way of turning the mdf/ldf files into a sql/CSV file locally on my development machine. How do I do this file conversion?

 
Old May 2nd, 2007, 08:54 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

hi there..

if you install SQL server management studio express (the express enterprise manager, that is free too), you can connect to your database (mdf file) and one of the task is generate scripts (for the database and all the objects in it, it's one sql file)...

you can import that anywhere.... and no more problem...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
 
Old May 2nd, 2007, 01:50 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Didn't we do this here: http://p2p.wrox.com/topic.asp?TOPIC_ID=59720

Did you give the Database Publishing Wizard a try?

If so, why didn't it work for you?

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.
 
Old May 3rd, 2007, 12:38 AM
Authorized User
 
Join Date: Apr 2007
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes you are right Imar, sorry about that, and thank you both for helping me. As you know I was successful generating an sql file from the mdf file using the Database Publishing Wizard. However, the tool I was using claim that the sql file generated by Database Publishing Wizard contain syntax errors (as you know from the other post), so it is good that I have two methods to try.

Imar and Gonzales, I really appreciate your help with this.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Where are the .mdf and .ldf files? mike72 BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 3 March 18th, 2008 11:11 AM
I don't want VWD to generate mdf files, how? ThomasWikman BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 12 May 21st, 2007 01:39 AM
.mdf files no good papakev123 BOOK: Professional ASP.NET 2.0 Server Control and Component Development ISBN: 978-0-471-79350-2 4 April 3rd, 2007 02:35 PM
how to prepare database with .ldf and .mdf files beetle_jaipur SQL Server 2000 2 March 8th, 2007 11:54 PM
SQL 2000 MDF files fchaffin BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 3 July 5th, 2006 12:08 PM





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