Posted by John Bell on 09/07/06 13:19

Hi Tom

If the objects are on source code control you may just want to check out the
scripts and run them through SQLCMD.

If you want the whole database then you can either use backup/restore or
sp_detach_db/sp_attach_db, failing that you could use the import/export
wizard, If SQLExpress is does not allow external connections then you will
need to push it (export) from the SQLExpress machine.

Check out http://support.microsoft.com/kb/314546

John


"tlyczko" <tlyczko@gmail.com> wrote in message
news:1157561832.911996.148780@b28g2000cwb.googlegroups.com...
> Can anyone refer me to good 'recipes' or sources of information on this
> topic??
>
> I have Visual Studio Tools for Office, which installs SS 2005 Express
> locally to my XP box, and I want to develop in SS 2005, then copy the
> tables or queries or reports etc. to a SS 2005 Standard server.
>
> Thank you, Tom
>

• Next in forum: Re: move/copy database objects from SQL Server Express to SQL Server Standard??
• Prev in forum: Re: Are these DB's required??
• Thread view: Re: move/copy database objects from SQL Server Express to SQL Server Standard??

[Reply to this message]