Converting Data from SqlServer Express to SqlServer 2005 beta 2??

Hi,
Was wondering if anyone could tell me how to convert the an SQL Server
Express (MDF) file into SQL Server 2005 Beta 2. I've been looking for a day
or so now and can't seem to find how to do this!!!
Any ideas?
Many Thanks
Wayne Gibson
Hi
Detach the DB in Express and attach it in SQL Server 2005. Or Backup and
Restore.
The backup and data files have 100% the same format.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Wayne Gibson" <wayne.gibson@.rendersoft.com> wrote in message
news:d9gca4$t42$1$8300dec7@.news.demon.co.uk...
> Hi,
> Was wondering if anyone could tell me how to convert the an SQL Server
> Express (MDF) file into SQL Server 2005 Beta 2. I've been looking for a
> day or so now and can't seem to find how to do this!!!
> Any ideas?
> Many Thanks
> Wayne Gibson
>
|||You should find you can just attach it with sp_attach_db. Did you try
that?
Please ask SQL Server 2005 questions in the appropriate newsgroups:
http://communities.microsoft.com/new...=sqlserver2005
David Portas
SQL Server MVP
|||Hi Mike,
Thanks for responding..
Could you tell me how I go about making a backup of a MS SQLServer Express
file.
I got MS SQLServer Express as part of the Visual Studio 2005 Beta 2, but
can't see any tools apart from those in the IDE.
Thanks
Wayne

Converting Data from SqlServer Express to SqlServer 2005 beta 2??

Hi,
Was wondering if anyone could tell me how to convert the an SQL Server
Express (MDF) file into SQL Server 2005 Beta 2. I've been looking for a day
or so now and can't seem to find how to do this!!!
Any ideas?
Many Thanks
Wayne Gibson
Hi
Detach the DB in Express and attach it in SQL Server 2005. Or Backup and
Restore.
The backup and data files have 100% the same format.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Wayne Gibson" <wayne.gibson@.rendersoft.com> wrote in message
news:d9gca4$t42$1$8300dec7@.news.demon.co.uk...
> Hi,
> Was wondering if anyone could tell me how to convert the an SQL Server
> Express (MDF) file into SQL Server 2005 Beta 2. I've been looking for a
> day or so now and can't seem to find how to do this!!!
> Any ideas?
> Many Thanks
> Wayne Gibson
>
|||You should find you can just attach it with sp_attach_db. Did you try
that?
Please ask SQL Server 2005 questions in the appropriate newsgroups:
http://communities.microsoft.com/new...=sqlserver2005
David Portas
SQL Server MVP
|||Hi Mike,
Thanks for responding..
Could you tell me how I go about making a backup of a MS SQLServer Express
file.
I got MS SQLServer Express as part of the Visual Studio 2005 Beta 2, but
can't see any tools apart from those in the IDE.
Thanks
Wayne

Converting Data from SqlServer Express to SqlServer 2005 beta 2??

Hi,
Was wondering if anyone could tell me how to convert the an SQL Server
Express (MDF) file into SQL Server 2005 Beta 2. I've been looking for a day
or so now and can't seem to find how to do this!!!
Any ideas?
Many Thanks
Wayne GibsonYou should find you can just attach it with sp_attach_db. Did you try
that?
Please ask SQL Server 2005 questions in the appropriate newsgroups:
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005
--
David Portas
SQL Server MVP
--|||Hi
Detach the DB in Express and attach it in SQL Server 2005. Or Backup and
Restore.
The backup and data files have 100% the same format.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Wayne Gibson" <wayne.gibson@.rendersoft.com> wrote in message
news:d9gca4$t42$1$8300dec7@.news.demon.co.uk...
> Hi,
> Was wondering if anyone could tell me how to convert the an SQL Server
> Express (MDF) file into SQL Server 2005 Beta 2. I've been looking for a
> day or so now and can't seem to find how to do this!!!
> Any ideas?
> Many Thanks
> Wayne Gibson
>|||Hi Mike,
Thanks for responding..
Could you tell me how I go about making a backup of a MS SQLServer Express
file.
I got MS SQLServer Express as part of the Visual Studio 2005 Beta 2, but
can't see any tools apart from those in the IDE.
Thanks
Wayne

Converting Data from SqlServer Express to SqlServer 2005 beta 2??

Hi,
Was wondering if anyone could tell me how to convert the an SQL Server
Express (MDF) file into SQL Server 2005 Beta 2. I've been looking for a day
or so now and can't seem to find how to do this!!!
Any ideas?
Many Thanks
Wayne GibsonHi
Detach the DB in Express and attach it in SQL Server 2005. Or Backup and
Restore.
The backup and data files have 100% the same format.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Wayne Gibson" <wayne.gibson@.rendersoft.com> wrote in message
news:d9gca4$t42$1$8300dec7@.news.demon.co.uk...
> Hi,
> Was wondering if anyone could tell me how to convert the an SQL Server
> Express (MDF) file into SQL Server 2005 Beta 2. I've been looking for a
> day or so now and can't seem to find how to do this!!!
> Any ideas?
> Many Thanks
> Wayne Gibson
>|||You should find you can just attach it with sp_attach_db. Did you try
that?
Please ask SQL Server 2005 questions in the appropriate newsgroups:
http://communities.microsoft.com/ne...p=sqlserver2005
David Portas
SQL Server MVP
--|||Hi Mike,
Thanks for responding..
Could you tell me how I go about making a backup of a MS SQLServer Express
file.
I got MS SQLServer Express as part of the Visual Studio 2005 Beta 2, but
can't see any tools apart from those in the IDE.
Thanks
Waynesqlsql

convert SQL 2005 express .mdf to SQL 2005

Hi Forum, I need some good info regards remote host requirements.

I dev web app using VS 2005 express edition and SQL Server Management Studio express. Everything is ready to transfer to host running SQL 2005.

My ? do I have to convert my SQL 2005 express .mdf to a SQL 2005 file type. (hosting company state I do, then save as .bak)

much appreciate good data, Paul

A mdb file is Access based, an mdf file is the data file of SQL Server. They are not convertible. You will have to import the data from access or export / upsize from access to make them stored on the server.

|||

check out this link

http://aspalliance.com/888

|||

There are two easy solutions:

1) Attach you .mdf file to your database with the hosting company.

2) Make a backup for your database (e.g. on the local machine) and restore it in your database with the hosting company.

Good luck.

|||

CS4Ever:

There are two easy solutions:

1) Attach you .mdf file to your database with the hosting company.

2) Make a backup for your database (e.g. on the local machine) and restore it in your database with the hosting company.

Good luck.

There are two more solutions but some time it does not work due to security issues from the hosting company.

1) Use SSIS (SQL Server Integration Services) a wizard that will copy your data and objects from local machine to the hosting server.

2) Use Database Copy Wizard.

Good luck.

|||Thanks everyone for info, I ended up creating a blank db on host server and configing through SQL server manager, cheers P|||

What do you mean by:

plkilroy:

configing through SQL server manager

Please mark Answer the post(s) helped you, so it will help other to get the soltion.

Thanks.

convert mdf to mdb

hi all,

I'm using visual web developer and created a project with a mdf data file. how can I convert this file to MS ACCESS mdb file?

Thanks

Normally migration proceeds the other way!

Open your SQL Server management tool, select the database, go tasks, export and on the output select a pre-existing access database.

|||

I just installed Visual Web Developer and SQL Server 2005 Express Edition. Seems cannot find the tool you mentioned..

If programatically convert it I'm concerning some reserved words problem like "Value" in SQL server is ok while ion ACCESS is a reserved word..

And DateTime in SQL is one field while in ACCESS is in 2 fields..

|||

Hi stardust25,

TATWORTH :

Normally migration proceeds the other way!

Open your SQL Server management tool, select the database, go tasks, export and on the output select a pre-existing access database.

The solution TATWORTH has suggested you should work on SQL Server 2005. But since you haveExpression Edition installed, things are a little different.Based on my understanding, SQL Express doesnot have DTS/SSIS shipped with. We can only useBCP, Bulk Insert, Openrowset, Code..etc to do export/export (based on the datatype you want to deal with). You can take a look at this thread I answered recentlyhttp://forums.asp.net/t/1139369.aspx, I hope it can help you better understand the converstion process.thanks

Convert from Clarion to MS SQL Server or Access

Hello!

Somebody knows how to convert the data from Clarion (tps) to mdb or mdf files?
Any variants?

Thanks to all!

I don't know much about Clarion, well, nothing.
There seems to be plenty of ODBC drivers for it though.
You could then use SSIS to import the data into SQL. You cannot as such "convert" anything to mdf. You can import it into SQL though.

http://www.google.co.uk/search?q=clarion+odbc+drivers&sourceid=navclient-ff&ie=UTF-8&rlz=1B3GGGL_enGB213GB213|||Crispin, thanks for the time, given to my question.