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

[tlyczko]

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

[John Bell]

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" <tl*****@gmail.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.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

[tlyczko]

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:

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" <tl*****@gmail.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.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

[tlyczko]

tlyczko wrote:

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/archive...18/668916.aspx

HTH tom