Re: is it possible to move table(s) from one db to another?

From: Vinodk (vinodk_sct_at_NO_SPAM_hotmail.com)
Date: 05/21/04 

Date: Fri, 21 May 2004 14:35:06 +0530

Well Hari.

Cool. The select into clause is the easiest implementation. But having said
that this also copies the data not moves :) ... 

-- 
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Hari" <hari_prasad_k@hotmail.com> wrote in message
news:%230rs5FuPEHA.556@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> It seems tin  needs to move the table from one database to another
database
> in the same server. In this case he can select * INTO statement.
>
> For eg:
>
> You have 2 databases- 1 is HR and the 2nd is Finance..
>
> Incase if Tin need to move the EMPLOYEE table in HR to Finance then he can
> execute the below command from Query Analyzer.
>
> select * into FINANCE..Employee from HR..Employee
>
> Once the tabe is successfully copied then you can drop the table from
source
> database. But ensure that full data is copied to destination.
>
> Note:
> If you need the indexes then you have to create the indexes by scripting
> them using the Enterprise manager -- Databases-- Alltasks-- Generate
Scripts
> by selecting the current database and table.
>
>
> Thanks
> Hari
> MCDBA
>
>
>
> "Vinodk" <vinodk_sct@NO_SPAM_hotmail.com> wrote in message
> news:OhXlH0tPEHA.628@TK2MSFTNGP11.phx.gbl...
> > By move you mean you want the data to be copied right ? If yes, then you
> > have:
> >
> > 1. Create a DTS package has a wizard approach that will transfer the
same
> in
> > a few clicks.
> > 2. Script out all the data using available third party tools and script
> the
> > data and import the same. One such script present at :
> > http://vyaskn.tripod.com/code/generate_inserts.txt
> >
> > --
> > HTH,
> > Vinod Kumar
> > MCSE, DBA, MCAD, MCSD
> > http://www.extremeexperts.com
> >
> > Books Online for SQL Server SP3 at
> > http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
> >
> >
> > "Tin" <oe@fawcette.com> wrote in message
> > news:%23AM8vlrPEHA.1276@TK2MSFTNGP11.phx.gbl...
> > > thanks in advance.
> > >
> > >
> >
> >
>
>

Relevant Pages

  • [NEWS] IBM Informix Web DataBlade Local Root by Design
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... that ease development of "intelligent", interactive, Web-enabled database ... person who has access to change the Perl script. ...
    (Securiteam)
  • RE: Need some MySQL query help...
    ... attempting to run the script: ... passed to the database. ... passwd entry to the current database entry. ...
    (perl.dbi.users)
  • Re: Cannot Open SQL Server Table in Access.ADP File.
    ... I dont think that SQL Server will take 'veiw dependencies' into effect; ... Generate Script Wizard did not work on my original database, ... After fixing some of my tables and a few stored procedures and views, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Function that returns date of file.
    ... string after the date/time when it is used by itself. ... Is that your entire script? ... I make an IF statement that required the 'equals equals'. ... designed database your job will be all that much harder. ...
    (alt.php)
  • Re: script dies yet there are no errors in error log
    ... It might be better to ensure the case of the entries in the database, ... This kind of error usually is caused by a CGI or PHP failing to ... input could not be more simple, just a bunch of UPC codes, one per line: ... Given 15 such numbers, the script does fine. ...
    (comp.lang.php)