Re: Import User Records

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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: Help needed in BCP and Bulk Insert
    ... So by using /n creation of file takes extra time but loading it via bulk ... BULK INSERT Testbed.dbo.TestTable2 ... understand your alternate strategy better? ... dynamic SQL. ...
    (microsoft.public.sqlserver.programming)
  • Re: Cannot fetch a row from OLE DB provider "BULK" for linked serv
    ... Bulk load: An unexpected end of file was encountered in the data file. ... Anyway, there was an error in the format file, at least in regards to ... This is probably when you need to look at SQL Server Integration Services, ...
    (microsoft.public.sqlserver.programming)
  • 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: Bulk import issues
    ... BULK INSERT holdings ... How do I get the system to not import the qualifiers("")? ... is SQL 2005. ... Note that if your file does not use quotes consistently, ...
    (microsoft.public.sqlserver.programming)