|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
June 28th, 2004, 10:29 AM
|
|||
|
|||
|
Importing a table - How?
I have a MS SQL table that I want to import into a test db in my SQL 2000. The table is filename.sql and has the script in it to set up the table, etc.
How do I import this table into the sql 2k db? I tried the wizard and I cannot get a choice to locate the file. How does one go about importing a copy of a sql table? The help file wasn't much of a help, thanks for your input. 
|
|
#2
June 28th, 2004, 10:38 AM
|
||||
|
||||
|
Open the script in Query Analyzer and run it there
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
#3
June 28th, 2004, 10:52 AM
|
|||
|
|||
|
I tried to run it in the Query Analyzer, but it ran for like 50 minutes then only imported about 100 rows. This is a 64+mb file.
I did not know if I was doing something wrong. I guess the Query Analyzer is the option, so I'll keep trying it. Thanks
|
|
#4
June 29th, 2004, 12:56 AM
|
|||
|
|||
|
That's quite a large file
 If it's all INSERTs, you might want to try a non GUI tool like "osql" or another tool. I would be interested to know if this runs fine in Database Workbench ( www.upscene.com ) as a 3rd party tool. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com
__________________
Martijn Tonies Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle Upscene Productions http://www.upscene.com
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Importing a table - How? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
