|
|
Posted by tlyczko on 09/07/06 13:37
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" <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
> >
Navigation:
[Reply to this message]
|