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

move objects between mdf files

what is the easiest way to move objects (tables with data and stored procedures) from one sqlexpress database mdf to another mdf?

You can use SELECT...INTO as documented at http://msdn2.microsoft.com/en-us/library/ms190750.aspx. Just identify your table using four part naming so that you can direct it to the table in the other database.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1