• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

How to migrate from .mdf to .sql

Hi
I install database publishing wizard for upgrade /downgrade .mdf file
I select database master But it shows pop up message
There are no objects in database      ‘master’   of the types scriptable by this wizard but it need .sql file

My question is how to migrate data using a .mdf   file for data
0
prashanth ag
Asked:
prashanth ag
1 Solution
 
Lokesh B RDeveloperCommented:
Hi,

Check this link for the steps.

https://msdn.microsoft.com/en-IN/library/ms190209.aspx
0
 
prashanth agsoftware engineer Author Commented:
my question is

HOw to downgrade a sql server database file (.mdf) from 2005 to 2000(older version)
                                        or
How to downgrade my mdf file from version 661 to 655 or earlier?
0
 
Anthony PerkinsCommented:
HOw to downgrade a sql server database file (.mdf) from 2005 to 2000(older version)
You cannot do that.  The best you can do is
1. Create a database in SQL Server 2000
2. Script all the objects in SQL Server 2000
3. Fix all the incompatibilities (varchar(MAX) to text, etc)
4. Miigrate all the data from SQL Server 2005 to SQL Server 2000.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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