Re: Import User Records

From: diane walker (ett9300_at_yahoo.com)
Date: 06/16/04


Date: Wed, 16 Jun 2004 07:35:50 -0700

Thanks for your quick response.

Do I need to export records first from SQL 6.5?

Thanks.

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:%23mRcLq3UEHA.3512@TK2MSFTNGP12.phx.gbl...
> You can, fro SQL2K, use DTS. Other options include BCP, BULK INSERT.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "diane walker" <ett9300@yahoo.com> wrote in message
news:eH%23oXkyUEHA.1604@TK2MSFTNGP12.phx.gbl...
> > We have a Help Desk software that runs under SQL 6.5. We would like to
> > import the user information (name, phone number, dept.) from SQL 6.5 to
SQL
> > Enterprise Edition 2000. Is it possible to perform this task? If it
is,
> > is there a utility that we can use?
> >
> > Thanks.
> >
> >
>
>



Relevant Pages

  • Re: C2 Audit and BCP
    ... I'd like to be able to identify that an "insert bulk" statement has ... All of the SQL Statements that are run are identified solely by the ... events but nothing legible in the text data column. ... This isn't an issue with the functionality of BCP, ...
    (microsoft.public.sqlserver.security)
  • Re: can not bulk insert a network file onto a remote SQL server 2005
    ... SQL 2000 DTS can import the same file with no ... Bulk Insert task and when using the Import Column in a data flow task. ... There are clearly multiple people out here fighting it. ... > I get this error when run from Query analyser in remote machine ...
    (microsoft.public.sqlserver.dts)
  • Re: How do I run a .BAS file saved from a DTS package?
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... > Thanks for your reference to the Bulk Export Task. ...
    (microsoft.public.sqlserver.dts)
  • Re: Use a sequence to bulk collect into a collection?
    ... Patrick Demets wrote: ... And this cursor returns one record. ... FETCH ew_eqmt_asgn_csr BULK COLLECT INTO ... SQL> create sequence testseq; ...
    (comp.databases.oracle.server)
  • LINQ to SQL with bulk insert
    ... I am using a combination of LINQ to SQL and bulk insert. ... One problem I am having is trying to use a 'transaction' to wrap ...
    (comp.databases.ms-sqlserver)