from Express to sql Server 2005

30 Jun 2006 9:00 AM

Dave Johnson

how to transform a database from sql server express edition to SQL
Server 2005 !!??

thanks i am just new to this :)

Sharing makes All the Difference

--
Sent via .NET Newsgroups
http://www.dotnetnewsgroups.com

30 Jun 2006 1:46 PM

Kerry Moorman

Dave,

I'm wondering if you can't just detach the database from express (using
Management Studio Express), copy the .mdf and .ldf files to 2005's Data
folder, and then attach to 2005?

Kerry Moorman

Show quote

"Dave Johnson" wrote:

> how to transform a database from sql server express edition to SQL
> Server 2005 !!??
>
> thanks i am just new to this :)
>
>
>
> Sharing makes All the Difference
>
> --
> Sent via .NET Newsgroups
> http://www.dotnetnewsgroups.com
>

1 Jul 2006 11:14 PM

Johnny

Actually all you have to do is to import, the SQL 20005 Server will see The
Express server just as another SQL server.

Show quote

"Kerry Moorman" wrote:

> Dave,
>
> I'm wondering if you can't just detach the database from express (using
> Management Studio Express), copy the .mdf and .ldf files to 2005's Data
> folder, and then attach to 2005?
>
> Kerry Moorman
>
>
> "Dave Johnson" wrote:
>
> > how to transform a database from sql server express edition to SQL
> > Server 2005 !!??
> >
> > thanks i am just new to this :)
> >
> >
> >
> > Sharing makes All the Difference
> >
> > --
> > Sent via .NET Newsgroups
> > http://www.dotnetnewsgroups.com
> >