Re: Truncate all tables in SQL Server db

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Vlad (vovan.c_at_verizon.net)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 10:46:25 -0500

Thank you very much, everyone answered my question.
Vlad

"Vlad" <vovan.c@verizon.net> wrote in message
news:uq2$E2PDEHA.3080@TK2MSFTNGP10.phx.gbl...
> I'm moving VB 6 project from Access to SQL Server. First step is to
continue
> to use Access with linked to SQL Server tables. A made already all
required
> changes in code.
> I have prepared a copy of Access database with data in SQL Server by
running
> DTS. Then I restored lost primary keys and made some other changes.
> A also prepared a copy of Access database without data (just linked
tables).
> Then because the current Access db is in use all the time I will need to
> stop its use for as short as possible time to transfer data to SQL Server
> and start to use a database with linked tables.
> I need to truncate all tables in SQL Server first and then to run DTS to
> transfer the most current data from Access.
> Is there any way to truncate all tables in SQL Server in one step? Or I
need
> to run "truncate table table1" then "truncate table table2" and so on? Due
> to number of tables it's going to take a lot of time which is not
desirable.
>
> Thank you
> Vlad
>
>

Relevant Pages

  • Re: tool to re-reference forms after usizing?
    ... Speed Ferret (which I hate to admit that I've never been able to get to ... tblCustomerAddress, remember that changing tblCustomer to something else ... >>> I am in the process of upsizing an access database to sql server. ...
    (microsoft.public.access.conversion)
  • Re: ODBC parameters and system resources
    ... Install MSDE or use an existing SQL Server. ... I connect to an Access database of about 500MB in size. ... there is the "Not enough space on temporary disk". ... What can a "System resource" be apart from disk space and RAM? ...
    (comp.databases.ms-access)
  • Re: Migrating away from MS-Access
    ... Ive just stepped into a role to migrate an access database to VB.Net. ... At some stage we have to migrate the access backend to SQL Server. ... A dot-net front end with an MDB file back end is the worst of all worlds. ...
    (comp.databases.ms-access)
  • RE: ODBCDirect Workspace
    ... successfully ported my tables to SQL Server and have created an Access ... Are you using one Access database to work inside of another Access database? ... Set daoDbs = Nothing ... However if you are going to be using this query again to populate the combo ...
    (microsoft.public.access.modulesdaovba)
  • RE: ODBCDirect Workspace
    ... successfully ported my tables to SQL Server and have created an Access ... Are you using one Access database to work inside of another Access database? ... Dim strSql As String ... However if you are going to be using this query again to populate the combo ...
    (microsoft.public.access.modulesdaovba)