move/copy database objects from SQL Server Express to SQL Server Standard?

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, TomHi 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.comwrote in message
news:1157561832.911996.148780@.b28g2000cwb.googlegr oups.com...

Quote:

Originally Posted by

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
>

|||I should have said SS 2005 Developer, not Express, I am installing SS
2005 Dev to my workstation here.

But everything you said should work, I just have to learn how!!!!!!!!

I will read the KB article, I suppose I could learn SSIS for just
tables or queries etc., or even just re-create the queries on the SS
dev box.

Thanks a lot for answering!!

:) tom

John Bell wrote:

Quote:

Originally Posted by

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.comwrote in message
news:1157561832.911996.148780@.b28g2000cwb.googlegr oups.com...

Quote:

Originally Posted by

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

|||tlyczko wrote:

Quote:

Originally Posted by

I should have said SS 2005 Developer, not Express, I am installing SS
2005 Dev to my workstation here.

I found this link, I can't remember where:

http://blogs.msdn.com/euanga/archiv.../18/668916.aspx
HTH tom