Solved

ASpnetdb.mdf to sql server 2000

Posted on 2008-10-24
6
459 Views
Last Modified: 2013-11-08
I have created a local aspnetdb.mdf with the asp.net configuration utility in visual studio 2008.

How do I get that database information over to my remote sql server 2000 database?

thanks.
0
Comment
Question by:Starr Duskk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 19

Assisted Solution

by:elimesika
elimesika earned 500 total points
ID: 22808751
0
 
LVL 2

Author Comment

by:Starr Duskk
ID: 22808941
I am not attaching to a desktop engine. I am trying copy the entire mdf to my sql server 2000.
 
0
 
LVL 19

Expert Comment

by:elimesika
ID: 22808972
I know, and still this article shows you how to copy the mdf & log file and attach them to your sql 2000 database.
0
Linux Academy Android App Now Supports Chromecast

We have some fantastic news for our Android fans. We’re so excited to announce that the Linux Academy Android app is now available with Chromecast support. That’s right – simply download the latest update of the Linux Academy App and start casting your favorite course videos!

 
LVL 2

Author Comment

by:Starr Duskk
ID: 22809024
okay, I'll check it out this week. thanks.
 
0
 
LVL 2

Author Comment

by:Starr Duskk
ID: 22862548
Okay, I had a chance to go through it. None of that makes sense to me.
Isn't there a way to use the sql server Import and Export utility to import the mdf files?
 
0
 
LVL 2

Accepted Solution

by:
Starr Duskk earned 0 total points
ID: 22876035
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question