Import To Firebird
Feb 13, 2007Hi all
How to an import database from Firebird to Sql Server 2000? :(
Thanks.
ADVERTISEMENT
FireBird To SQL
Nov 30, 2006Hello every1. I am currently using a system thats written in Borland C++ and running off Firebird Server 1.5.1, which for some reason crashes constantly (internal gds software consistency check). I have MS SQL Server 2005 installed on another machine, and was wondering if it is possible for me 2 run my C++ apps on MS SQL Server 2005? If anyone can help me with either of those questions, it wud be highly appreciated.
Summary:
Question 1. : How do i solve the "internal gds software consistency check" in the FireBird server?
Question 2. : How do I run my C++ Apps (designed for Firebird) to run on MS SQL Server 2005 ?
DTS And Interbase/Firebird
Apr 22, 2004I have written several DTS pakages to copy data from an Interbase/Firebird db to SQL Server. They execute under Enterrpise Manager perfectly but when scheduled return an error.
I am aware that permissions are a normal source of these problems but I have hopefully excluded them from teh equation by using a local admin/domain/sysadmin user throughout for SEM, SQLServerAgent and even the SQLServerAgentProxy.
The problem appears to be related to the interaction between the Microsoft OLE DB Provider for ODBC Drivers and the Interbase/Firebird Driver. I have checked several forums and the MSDN website but few people seem to have experienced this type of problem in this environment.
Error msgs:
Step Error Source: Microsoft OLE DB Provider for ODBC Drivers
Step Error Description:[Easysoft][InterBase]unavailable database
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0
OR
Step Error Source: Microsoft OLE DB Provider for ODBC Drivers
Step Error Description:unavailable database
Step Error code: 80040E4D
Step Error Help File:
Step Error Help Context ID:0
My Setup:
MS SQL Server 2000 with SP3
MDAC 2.8 RTM
Interbase v6 /Firebird 1.03 db Server
Have tried the following driver/connectors:
Firebird ODBC v1.02.00.41
Easysoft ODBC v2.01.00.01
XTG Interbase6 ODBC v1.00.00.15
I have even tried OLE DB providers for Interbase/Firebird but they won't schedule either giving me an SQLCODE=-904
Any insight/help/sympathy appreciated. I have struggled with this single issue for nearly a week.
Trigger Before Delete In Firebird Or Mssql
Jul 20, 2005Hi everybody!I need create trigger in firebird and mssql.The trigger must do this:If someone try to delete record in table "mast_trans" and if column "ID"is equal 145 delete cannot be executed otherwise perform delete.How can I do this? My books dont have any examples for this :(Thanks for help, greetings, gregory.
View 2 Replies View RelatedSQL 2012 :: Create Linked Server For Firebird?
Jan 26, 2015i didn't figure out how to add a firebird linked server via ODBC
my system :
win 7 pro 64
SQL server 2012 express 64
firebird 2.5.3 64
Official ODBC drivers 64
i have created the odbc source without problem, and checked that in visual studio and ssms import data wizard , both show me the data from firebird database but when i try to create a linked server , i have something like this message (the image is from the web)
Problem In Retrieving Firebird/Interbase Tables
Aug 7, 2007I am using the following:
VS 2005
SQL 2005 Reporting Services
Firebird.Net Data Provider 2.0
Firebird Database 1.5
This is what I am trying to do:
In SQL Server 2005 Analysis project,
Create a Data Source
Create a Data Source View
And
Create a Report Model
I have successfully created the data source.
When I try to create a Data Source View, it lists all the tables in the Firebird database.
In the last step, when VS tries to import the metadata to its storage (I think), the Firebird Client throws the following exception:
<Error start>
===================================
Dynamic SQL Error
SQL error code = -104
Token unknown - line 3, char 8
[ (Microsoft Visual Studio)
------------------------------
Program Location:
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.DataWarehouse.Design.DataSourceConnection.FillDataSet(DataSet dataSet, String schemaName, String tableName, String tableType)
at Microsoft.AnalysisServices.Design.DataSourceDesigner.AddRemoveObjectsFromDSV()
===================================
Exception of type 'FirebirdSql.Data.Common.IscException' was thrown. (FirebirdSql.Data.FirebirdClient)
------------------------------
Program Location:
at FirebirdSql.Data.Client.Gds.GdsConnection.ReadStatusVector()
at FirebirdSql.Data.Client.Gds.GdsConnection.ReadResponse()
at FirebirdSql.Data.Client.Gds.GdsDatabase.ReadResponse()
at FirebirdSql.Data.Client.Gds.GdsStatement.Prepare(String commandText)
at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
<Error end>
Few notes:
If I remove the checkbox of €œCreate logical relationships by matching columns€?, the wizard proceeds smoothly. But when I open the data source view, there are no tables there and if I try to add more tables, I receive the same error as above.
I am also trying to follow this up the Firebird Client project since the error was thrown by Firebird DLL.
However, has somebody done this before and/or can provide me some direction/information as to what I might be doing wrong?
Regards
Shreekar
Connecting Execute SQL Task With Firebird Connection Manager
Jun 18, 2007Hi,
I'm using Integration Service between Firebird and MS SQL 2005. I can able to move data from Firebird db tables to MS SQL db tables using DataReader source (Firebird Connection Manager) and SQL Server Destination (SQL Server Connection Manager) component.
Now I want to execute parametrized SQL statement to fetch data from Firebird DB using Execute SQL Task Component. In this process while trying to set Connection property to this component I can able to view only MS SQL Connection Manager and it is not listing Firebird Connection Manager.
Now I need a help to get connect this Execute SQL Task component with Firebird connection Manager. Help me to find out where I'm making mistake.
FYI. I'm using Firebird .Net Provieder 2.0.1
Thanks in advance.
Suku
DB Engine :: How To Copy File From Firebird Database To Server
Apr 23, 2015I have a file in Fire bird Database (30 GB with .ydb extension). Â which needs to be restored to SQL Server. I Have created a linked server and done it but it is taking very long time to update the records.
View 8 Replies View RelatedNewbie: Why Do I Have To Use OPENQUERY To A Linked Server? (ODBC To Firebird Database)
Jan 17, 2008Hello,
pls. let me know where I could post if this is the wrong place.
I have a Firebird 1.5 application. I created a linked server from my SQL
Server 2000 to the firebird database. In SQL Server Query Analyzer I get errors from various ODBC drivers with "normal" queryies like
SELECT LVNR FROM LINKEDSRV...LVVERW
Pls. note, this all works perfectly in MS Access databases with ODBC-Links to Firebird!
From a programmer of a commercial ODBC driver I heard that this problem may be caused internally by SQL Server, there may be no solution possible in the ODBC driver. One workaround would be to use the OPENQUERY-Syntax like
SELECT * FROM OPENQUERY(LINKEDSRV, 'select LVNR from LVVERW ')
Are there any other solutions? Are there any known issues with firebird odbc-drivers and sql server? Are
there any known good drivers for the use with sql-server? What is the purpose of OPENQUERY - workaround ODBC problems? Are there any settings in SQL Server 2000 (2005 Express) that could help? Are there any settings in ODBC DSN that would help?
regards
arno
PS: Here are my favorite error messages
Error -2147217900 [OLE/DB provider returned message: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 89
"Col1014"] (Source: Microsoft OLE DB Provider for SQL Server) (SQL State:
01000) (NativeError: 7312)Error -2147217900 OLE DB-Fehlertrace [OLE/DB
Provider 'MSDASQL' ICommandPrepare:repare returned 0x80004005: ].
(Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 01000)
(NativeError: 7300)Error -2147217900 Der OLE DB-Provider 'MSDASQL' meldete
einen Fehler. (Source: Microsoft OLE DB Provider for SQL Server) (SQL
State: 42000) (NativeError: 7399)
This "tricky" query does not work:
SELECT LVNR FROM LINKEDSRV...LVVERW;
Error -2147217900 OLE DB-Fehlertrace [Non-interface error: Column
'ERHALTENABSCHLAG' (compile-time ordinal 35) of object 'LVVERW' was reported
to have a DBTYPE of 5 at compile time and 131 at run time]. (Source:
Microsoft OLE DB Provider for SQL Server) (SQL State: 01000) (NativeError:
7300)Error -2147217900 Der OLE DB-Provider 'MSDASQL' hat inkonsistente
Metadaten für eine Spalte übergeben. Die Metadateninformationen wurden zur
Ausführungszeit geändert. (Source: Microsoft OLE DB Provider for SQL
Server) (SQL State: 42000) (NativeError: 7356)
SQL Server Import And Export Wizard Fails To Import Data From A View To A Table
Feb 25, 2008A view named "Viw_Labour_Cost_By_Service_Order_No" has been created and can be run successfully on the server.
I want to import the data which draws from the view to a table using SQL Server Import and Export Wizard.
However, when I run the wizard on the server, it gives me the following error message and stop on the step Setting Source Connection
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Error)
Messages
Error 0xc020801c: Source - Viw_Labour_Cost_By_Service_Order_No [1]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0014019. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
(SQL Server Import and Export Wizard)
Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)
- Setting Destination Connection (Stopped)
- Validating (Stopped)
- Prepare for Execute (Stopped)
- Pre-execute (Stopped)
- Executing (Stopped)
- Copying to [NAV_CSG].[dbo].[Report_Labour_Cost_By_Service_Order_No] (Stopped)
- Post-execute (Stopped)
Does anyone encounter this problem before and know what is happening?
Thanks for kindly reply.
Best regards,
Calvin Lam
Integration Services :: Can't Import Excel 2013 Using SSMS Import Wizard (2008 R2)
Jul 29, 2015I am trying to import an xlsx spreadsheet into a sql 2008 r2 database using the SSMS Import Wizard. When pointed to the spreadsheet ("choose a data source")  the Import Wizard returns this error:
"The operation could not be completed" The Microsoft ACE.OLEDB.12.0 provider is not registered on the local machine (System.Data)
How can I address that issue? (e.g. Where is this provider and how do I install it?)
Import Data From MS Access Databases To SQL Server 2000 Using The DTS Import/Export
Oct 16, 2006I am attempting to import data from Microsoft Access databases to SQL Server 2000 using the DTS Import/Export Wizard. I have a few errors.
Error at Destination for Row number 1. Errors encountered so far in this task: 1.
Insert error column 152 ('ViewMentalTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 150 ('VRptTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 147 ('ViewAppTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 144 ('VPreTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 15 ('Time', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Invalid character value for cast specification.
Invalid character value for cast specification.
Invalid character value for cast specification.
Invalid character value for cast specification.
Invalid character value for cast specification.
Could you please look into this and guide me
Thanks in advance
venkatesh
imtesh@gmail.com
Error Trying To Import MS Access 2003 Database Via SQL Server Import And Export Wizard - Too Many Sessions Already Active
Nov 29, 2006I am trying to simplify a query given to me by one of my collegues written using the query designer of Access. Looking at the query there seem to be some syntax differences, so to see if this was the case I thought I would import the database to my SQL Server Developer edition.
I tried to start the wizard from within SQL Server Management Studio Express as shown in one of the articles on MSDN which did not work, but the manual method also suggested did work.
Trouble is that it gets most of the way through the import until it spews forth the following error messages:
- Prepare for Execute (Error)
Messages
Error 0xc0202009: {332B4EB1-AF51-4FFF-A3C9-3AEE594FCB11}: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Could not start session. Too many sessions already active.".
(SQL Server Import and Export Wizard)
Error 0xc020801c: Data Flow Task: The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009.
(SQL Server Import and Export Wizard)
Error 0xc004701a: Data Flow Task: component "Source 33 - ATable" (2065) failed the pre-execute phase and returned error code 0xC020801C.
(SQL Server Import and Export Wizard).
There does not seem to be any method of specifying a number of sessions, so I don't see how to get round the problem.
Does anyone know how I can get the import to work?
IMPORT New Data Since Last IMPORT - DTS/Stored Procs?
Jan 7, 2004Hello:
I am not sure how to implement the following, but I believe it entails using DTS, and hopefully it is fine that I post it here b/c ultimately I will need this backend data for my frontend .aspx pages:
On a weekly basis, I need to IMPORT some data located on a remote Oracle DB into SQL Server 2k. Since there is so much data to transfer, I would only like to transfer the data that is new to the table since the last IMPORT, i.e. a week ago and leave behin the OLD data.
Is DTS the correct way to go or do I have more control via DTS with STORED PROCEDURES? Does anyone have any good references for me?
On a similar note, once this Oracle data is IMPORTED into a certain table, I would like to EXPORT some of these NEWLY acquired rows matching certain criteria into another table for auditing purposes. For this scenario, should I implement a TRIGGER UPDATE event here on the first table?
Any advice will be greatly appreciated!
Error Regarding File Import Through Import Wizard
Jan 12, 2006Hi all,
when trying to Ãmport files to our database server from a client, I keep getting an error:
- Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source_txt" (1).
(SQL Server Import and Export Wizard)
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (175).
(SQL Server Import and Export Wizard)
... doing the same import when logged on the server, hasn't been giving me any errors, how come. I can from my client without trouble import tables from other DB servers but when ever it is files it won't do it.
I tried as mentioned in other threads rerun setup to re-install SSIS, but as it was already installed it wouldn't re-install. My next move would be to make a clean install, but not sure it would help, as I think this is a buck.
best regards
Musa Rusid
DTS Import Does Not Import All Rows / Records
Jul 23, 2005Hi,I am having trouble importing data from an excel spreadsheet into MSSQL Server 2000 using DTS Wizard. The DTS import process issuccessfull, no errors, but only 50 rows of approx. 1500 rows of dataare imported. I tried to remove 20 rows in the excel spreadsheet inthe interval row 0-50. When i later ran the import, only 30 rows wereimported. I deleted almost every row in the interval 0-50, with theresult of the import having 0 rows imported (but job ransuccessfully). I decided to delete rows 0-100 in the spreadsheet inorder to see if the resolved the problem, but it didn't. As Isuspected something in the excel file to be the cause, I exported theexcel spreadsheeet to a tab delimited textfile, with only one row. ADTS import resulted in importing approx 100 rows, double the amount ofthe textfile, but the other 1400 rows were not imported. The data inthe column is containing numeric values only.Please help me! What could possibly be the cause of DTS skipping rowslike that. DTS doesn't feel reliable at all :/Regards,Björn
View 3 Replies View RelatedImport To SQL
Apr 14, 2008What is the method or methods for importing delimited text files to SQLEXPRESS 2005 database?
View 5 Replies View RelatedXML Import
Jun 9, 2008I have some c# code where I import data to SQL from an xml file. Can this be done with type Image? I test for it and turn the gobbly gook into a byte[] array, but I get an out of memory error on my c# app when I try to view it.
Is this possible?
BCP Import Help
Apr 9, 2004I have a text file that I must import into a table I created but am having terrible difficulty trying to use the command line BCP utility to do so. Can anyone please tell me how to do this?
Text file and table properties below:
Text File
1
Untitled
Mark Rothko
Oil
1961
5'9"x4'2"
2
The Letter
Jan Vermeer
Oil
1666
1'5.25"x1'3.75"
3
Four Apostles
Albrecht Durer
Oil
1526
7'1"x2'6"
4
Big Self-Portrait
Chuck Close
Acrylic
1968
8'11"x6'11"x2
5
Three Angels
Andrei Rublyev
Tempura on wood
1410
4'8"x3'9"
6
Voltaire
Jean-Antoine Houdon
Marble
1781
7
Jaguar Devouring a Hare
Antoine-Louis Barye
Bronze
1851
1'4"x3'1"
8
The Peacock Skirt
Aubrey Beardsley
Pen and Ink
1894
9
Untitled Film Still #35
Cindy Sherman
Black-and-white photograph
1979
10"x8"
10
Reclining Figure
Henry Moore
Elm wood
1939
3'1"x2'6"
Table Properties
tbl_Items
ID(int) - Primary Key
Title (varchar - 50)
Owner (varchar - 50)
Canvas (varchar - 20)
Copyright (char - 4)
Sized (varchar - 20)
DTS Import
Mar 8, 2000Hi,
I am trying to do a DTS Import in SQL Server 7. I am importing from a text file to a SQL Server format. When I run the import to append the data I get the following error:
Error during Transformation 'DirectCopyXform' for row number 1.
Errors encountered so far in this task: 1
TransformCopy "DirectCopyXform'conversion error
Conversion invalid for datatypes on column pair 6(source column 'Col006'
(DBTYPE_STR), destination column 'END_DT'(DBTYPE_DBTIMESTAMP).
Could anyone tell me how to correct this problem?
Any help would be greatly appreciated.
Thanks
Phil
Import From AS/400?
Sep 28, 1998When I try to import an AS/400 table, I get to the screen where “You can
choose one or more tables to copy.” After selecting one table and clicking
Next, I get a DTS Wizard Error.
Error Description: [StarQuest][StarSQL ODBC Driver][DB2/400] Object
QSYS.QPGMR type *COLLECTION not found.
This ODBC driver is from Microsoft SNA Server version 4.0 and does work with
Microsoft Access.
Can anyone import AS/400 tables?
Thanks
Harley Ainsworth
hainsworth@rayberndtson.com
Import DBF Via DTS
Aug 27, 2002Hi,
I've never used DTS before, but would like to employ it to do a rather complicated data import (well complicated in my opinion).
I need to use DTS to import rows from a DBF File into a SQL Table. These DBF files reside on a separate server and can only be operated on once copied to another location so they aren't in an open state. Specifically I want to append the data from the DBF file into a SQL table. That is, a program writes data to a DBF file, and I want to import the new data not yet imported into SQL since the previous import. Another issue is that these DBF files change filenames (table names) every month. In other words, every month a new DBF table is created with the month number in the table name. I would have to import those, but make sure before I do so that all the rows from the previous month's table have been imported and then import the current month. Where I am find myself having the real problem is that in the DBF file, each row doesn't have a primary key I can reference it with. Only way to distinguish one row from another is to reference two columns, a timestamp and account number, those two columns can never be the same in another row. So I am not sure how to keep track of which row to start importing data from the DBF file.
Of course, lastly I'd like to automate this entire process so it happens every minute or two.
Hope that makes sense. Any help or thoughts would be greatly appreciated.
Regards,
-------------------------
Ayaz Asif
Versatile Technologies, Inc.
BCP Import
Sep 3, 2004Hi All,
I am using bcp utility to import text File data into SQL server table.I import about 50-60 such files. All other files except one file copies less no of rows to the database every time , than it has in the text file. All other files having either less or greater amount of data transfers it properly.I do not know why this happens to only one file.
Colmn delimiter used is | and row delimiters used is .
BCP is being run through a batch file.
Any idea how to solve this?
Thanks & regards
Rohit
BCP Import And EOF
Oct 13, 2004I am trying to centralize event logs with dumpevt to produce csv (comma or tab seperated) files for import via BCP. My problem lies in that it fails to put the CR/LF at the end of the last line.
So I get an "Unexpected EOF encountered" error.
Anyone else familar with this or how I might be able to script an insertion to those files of the CR/LF? Perhaps some way to just script appending a row terminator in the import file?
Any assistance would be GREALTY appreciated.
-Jonah
Bcp Import
Dec 29, 2005I'd like to bcp import a file that sometimes misses the last column/s. There's an EOL character instead. For some reason, bcp wraps around, ignoring the EOL character, and continues reading from the next row of the file. Instead, I'd like to replace the missing columns by null.
I've tried using bcp, bulk insert and the DTS Wizard. So far, I've only been succesfull using the DTS Wizard. I also do some other bcp imports, so I'd like to stick with bcp.
bcp table1 in myFile.csv -SServer1 -T -c -k -t -r
myFile.csv looks like... (replaced tabs by ;)
Col001;Col002;Col003;Col004
Col001;Col002
Col001;Col002;Col003
Col001;Col002;Col003;Col004
etc
are imported as:
Col001;Col002;Col003;Col004
Col001;Col002;Col001;Col002
Col001;Col002;Col003;Col001
etc
Any suggestions?
Import DBF
Feb 6, 2007Hi There! I have a problem with a DBF file. The problem is that somebody gaves me a data base in DBF format and he uses in SQL Server 2000 and EMS SQL Manager. Well, I have to instal the MDE and SQL Enterprise Manager and when I use the DTS tool to import the data I've got this error:
'Error not Especified'
and I don't know what's happen and how to solve it. Please! Any ideas!
("Sorry about my english")
Using BCP To Import
Aug 6, 2007Hi
I'm using the BCP facility to import a text file into a database. My problem is, in the table there are 10 fields but my file only contains data for 3 fields
e.g
Table - id,forname,surname,dob,gender,mob_number
File - forname,surname,mob_number
is there a way of only importing into the required fields or do i have to have columns in the order they are in, in the table????
can I use this file??
matt,jones,0775446644
chris,jones,066565465
or do i have to use this???
,matt,jones,,,0775446644
,chris,jones,,,066565465
Edit/Delete Message
Bcp Import Help
Nov 2, 2007I am trying to import data thru a bcp call to pull data from an access database. I am having trouble accessing the access database. Below is the bcp I tried, along with an openrowset attempt. Neither of them are working. Any help would be greatly appreciated.
bcp select datetime,groupNumber,lineSubgroupNumber,lineNumber ,lineName,inCall,noCallAnswer,
noOutCall,abandonCall,noCallAD,noCallABT,noHelpcal l,noTxcall,noNtcall,totalInNormalTime,
totalOutNormalTime,totalHoldNormalTime,totalAbando nTime,totalLineBusyTime,totalTransTime,
ansCallBin0,ansCallBin1,ansCallBin2,ansCallBin3,an sCallBin4,ansCallBin5,ansCallBin6,
abnCallBin0,abnCallBin1,abnCallBin2,abnCallBin3,ab nCallBin4,abnCallBin5,abnCallBin6
from Line Report in I:200711D1107.MDB -q -UXX -PXX
select datetime,groupNumber,lineSubgroupNumber,lineNumber ,lineName,inCall,noCallAnswer,
noOutCall,abandonCall,noCallAD,noCallABT,noHelpcal l,noTxcall,noNtcall,totalInNormalTime,
totalOutNormalTime,totalHoldNormalTime,totalAbando nTime,totalLineBusyTime,totalTransTime,
ansCallBin0,ansCallBin1,ansCallBin2,ansCallBin3,an sCallBin4,ansCallBin5,ansCallBin6,
abnCallBin0,abnCallBin1,abnCallBin2,abnCallBin3,ab nCallBin4,abnCallBin5,abnCallBin6
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'I:200710D1007.MDB';'XX';'XX', 'Line Report')
Import Possible
Apr 7, 2006using sql 2005 express for first time
using management studio express to import some tables
tried
In SQL Server Management Studio, connect to the Database Engine server type, expand Databases, right-click a database, point to Tasks, and then click Import Data or Export data.
does not appear to be avail in express version
Am I missing something here?
Andrew Clark
www.majorleaguecharts.com
How Do I Import?
May 7, 2006I had a database in a server, and I recently exported it to a .sql archive in my computer.
Then I went to the phpmyadmin (running on phpMyAdmin 2.6.4-pl2 with MySQL 4.0.25-standard) and... I can't find the "import" function, only the export one... What I'm doing wrong?
Help With BCP Import
Jul 13, 2007Hello, Let get right to it, OK?
Setup:
Windows 2003 web edition w/ SQL Express
Problem:
Error when importing text file to SQL Express. Not sure about the quality of the data since it is from a 3rd party and has over 1700 rows but it imports in to MS Access with no problems.
Error:
Unable to open BCP host data-file
Command:
bcp MLS_Data.dbo.tblFL_PuntaGorda in C:InetpubAdminScriptsDL_MLSpuntagorda_data.txt -T -S.SQLEXPRESS -f FL_PuntaGorda_bcp.fmt
Format File:
9.0
88
1 SQLCHAR 0 1 """ 0 Quote SQL_Latin1_General_CP1_CI_AS
2 SQLCHAR 0 50 "","" 1 MLS_ID SQL_Latin1_General_CP1_CI_AS
3 SQLCHAR 0 50 "","" 2 MLS_STATE_ID SQL_Latin1_General_CP1_CI_AS
4 SQLCHAR 0 50 "","" 3 MLS_LISTING_ID SQL_Latin1_General_CP1_CI_AS
5 SQLCHAR 0 50 "","" 4 TLN_FIRM_ID SQL_Latin1_General_CP1_CI_AS
6 SQLCHAR 0 150 "","" 5 MLS_OFFICE_NAME SQL_Latin1_General_CP1_CI_AS
7 SQLCHAR 0 50 "","" 6 MLS_OFFICE_PHON SQL_Latin1_General_CP1_CI_AS
8 SQLCHAR 0 50 "","" 7 TLN_REALTOR_ID SQL_Latin1_General_CP1_CI_AS
9 SQLCHAR 0 50 "","" 8 MLS_AGENT_NAME SQL_Latin1_General_CP1_CI_AS
10 SQLCHAR 0 50 "","" 9 MLS_AGENT_PHONE SQL_Latin1_General_CP1_CI_AS
11 SQLCHAR 0 50 "","" 10 LISTING_DATE SQL_Latin1_General_CP1_CI_AS
12 SQLCHAR 0 50 "","" 11 LISTING_EXPIRATION_DATE SQL_Latin1_General_CP1_CI_AS
13 SQLCHAR 0 50 "","" 12 SOLD_DATE SQL_Latin1_General_CP1_CI_AS
14 SQLCHAR 0 50 "","" 13 AVAILABLE_DATE SQL_Latin1_General_CP1_CI_AS
15 SQLCHAR 0 50 "","" 14 PROPERTY_TYPE_CODE SQL_Latin1_General_CP1_CI_AS
16 SQLCHAR 0 50 "","" 15 PROP_TYPE_DESCRIPTION SQL_Latin1_General_CP1_CI_AS
17 SQLCHAR 0 16000 "","" 16 REMARKS SQL_Latin1_General_CP1_CI_AS
18 SQLCHAR 0 50 "","" 17 STATUS_CODE SQL_Latin1_General_CP1_CI_AS
19 SQLCHAR 0 50 "","" 18 SALE_PRICE SQL_Latin1_General_CP1_CI_AS
20 SQLCHAR 0 50 "","" 19 SOLD_PRICE SQL_Latin1_General_CP1_CI_AS
21 SQLCHAR 0 50 "","" 20 PROPERTY_STATE_ID SQL_Latin1_General_CP1_CI_AS
22 SQLCHAR 0 50 "","" 21 STREET_NUMBER SQL_Latin1_General_CP1_CI_AS
23 SQLCHAR 0 50 "","" 22 STREET_NAME SQL_Latin1_General_CP1_CI_AS
24 SQLCHAR 0 50 "","" 23 STREET_TYPE SQL_Latin1_General_CP1_CI_AS
25 SQLCHAR 0 50 "","" 24 STREET_DIRECTION SQL_Latin1_General_CP1_CI_AS
26 SQLCHAR 0 50 "","" 25 UNIT_NUMBER SQL_Latin1_General_CP1_CI_AS
27 SQLCHAR 0 50 "","" 26 LONGITUDE SQL_Latin1_General_CP1_CI_AS
28 SQLCHAR 0 50 "","" 27 LATITUDE SQL_Latin1_General_CP1_CI_AS
29 SQLCHAR 0 50 "","" 28 CITY SQL_Latin1_General_CP1_CI_AS
30 SQLCHAR 0 50 "","" 29 CITY_ID SQL_Latin1_General_CP1_CI_AS
31 SQLCHAR 0 50 "","" 30 ZIP_CODE SQL_Latin1_General_CP1_CI_AS
32 SQLCHAR 0 50 "","" 31 ZIP_PLUS4 SQL_Latin1_General_CP1_CI_AS
33 SQLCHAR 0 50 "","" 32 MLS_AREA SQL_Latin1_General_CP1_CI_AS
34 SQLCHAR 0 50 "","" 33 COUNTY SQL_Latin1_General_CP1_CI_AS
35 SQLCHAR 0 50 "","" 34 FIPS_COUNTY_CODE SQL_Latin1_General_CP1_CI_AS
36 SQLCHAR 0 50 "","" 35 SUBDIVISION SQL_Latin1_General_CP1_CI_AS
37 SQLCHAR 0 50 "","" 36 COMMUNITY_NAME SQL_Latin1_General_CP1_CI_AS
38 SQLCHAR 0 50 "","" 37 YEAR_BUILT SQL_Latin1_General_CP1_CI_AS
39 SQLCHAR 0 50 "","" 38 ACRES SQL_Latin1_General_CP1_CI_AS
40 SQLCHAR 0 50 "","" 39 LOT_DIMENSIONS SQL_Latin1_General_CP1_CI_AS
41 SQLCHAR 0 50 "","" 40 LOT_SQUARE_FOOTAGE SQL_Latin1_General_CP1_CI_AS
42 SQLCHAR 0 50 "","" 41 LOT_SQUARE_FOOTAGE_LAND SQL_Latin1_General_CP1_CI_AS
43 SQLCHAR 0 50 "","" 42 BUILDING_SQUARE_FOOTAGE SQL_Latin1_General_CP1_CI_AS
44 SQLCHAR 0 50 "","" 43 BEDROOMS SQL_Latin1_General_CP1_CI_AS
45 SQLCHAR 0 50 "","" 44 BATHS_TOTAL SQL_Latin1_General_CP1_CI_AS
46 SQLCHAR 0 50 "","" 45 BATHS_FULL SQL_Latin1_General_CP1_CI_AS
47 SQLCHAR 0 50 "","" 46 BATHS_HALF SQL_Latin1_General_CP1_CI_AS
48 SQLCHAR 0 50 "","" 47 BATHS_THREE_QUARTER SQL_Latin1_General_CP1_CI_AS
49 SQLCHAR 0 50 "","" 48 FIREPLACE_NUMBER SQL_Latin1_General_CP1_CI_AS
50 SQLCHAR 0 50 "","" 49 TOTAL_ROOMS SQL_Latin1_General_CP1_CI_AS
51 SQLCHAR 0 50 "","" 50 SCHOOL_DISTRICT SQL_Latin1_General_CP1_CI_AS
52 SQLCHAR 0 50 "","" 51 SCHOOL_ELEMENTARY SQL_Latin1_General_CP1_CI_AS
53 SQLCHAR 0 50 "","" 52 SCHOOL_MIDDLE SQL_Latin1_General_CP1_CI_AS
54 SQLCHAR 0 50 "","" 53 SCHOOL_JUNIOR_HIGH SQL_Latin1_General_CP1_CI_AS
55 SQLCHAR 0 50 "","" 54 SCHOOL_HIGH SQL_Latin1_General_CP1_CI_AS
56 SQLCHAR 0 50 "","" 55 TOTAL_UNITS SQL_Latin1_General_CP1_CI_AS
57 SQLCHAR 0 50 "","" 56 TOTAL_BUILDINGS SQL_Latin1_General_CP1_CI_AS
58 SQLCHAR 0 50 "","" 57 TOTAL_LOTS SQL_Latin1_General_CP1_CI_AS
59 SQLCHAR 0 50 "","" 58 HOA_FEES SQL_Latin1_General_CP1_CI_AS
60 SQLCHAR 0 50 "","" 59 OWNERS_NAME SQL_Latin1_General_CP1_CI_AS
61 SQLCHAR 0 750 "","" 60 LEGAL SQL_Latin1_General_CP1_CI_AS
62 SQLCHAR 0 50 "","" 61 APN SQL_Latin1_General_CP1_CI_AS
63 SQLCHAR 0 50 "","" 62 TAXES SQL_Latin1_General_CP1_CI_AS
64 SQLCHAR 0 50 "","" 63 TAX_YEAR SQL_Latin1_General_CP1_CI_AS
65 SQLCHAR 0 50 "","" 64 SECTION SQL_Latin1_General_CP1_CI_AS
66 SQLCHAR 0 50 "","" 65 RANGE SQL_Latin1_General_CP1_CI_AS
67 SQLCHAR 0 50 "","" 66 TOWNSHIP SQL_Latin1_General_CP1_CI_AS
68 SQLCHAR 0 50 "","" 67 RENT_ON_SEASON SQL_Latin1_General_CP1_CI_AS
69 SQLCHAR 0 50 "","" 68 RENT_OFF_SEASON SQL_Latin1_General_CP1_CI_AS
70 SQLCHAR 0 50 "","" 69 PHOTO_IND SQL_Latin1_General_CP1_CI_AS
71 SQLCHAR 0 50 "","" 70 LAST_MLS_UPDATE_DATE SQL_Latin1_General_CP1_CI_AS
72 SQLCHAR 0 50 "","" 71 MASTER_BED SQL_Latin1_General_CP1_CI_AS
73 SQLCHAR 0 50 "","" 72 BED2 SQL_Latin1_General_CP1_CI_AS
74 SQLCHAR 0 50 "","" 73 BED3 SQL_Latin1_General_CP1_CI_AS
75 SQLCHAR 0 50 "","" 74 BED4 SQL_Latin1_General_CP1_CI_AS
76 SQLCHAR 0 50 "","" 75 BED5 SQL_Latin1_General_CP1_CI_AS
77 SQLCHAR 0 50 "","" 76 KITCHEN SQL_Latin1_General_CP1_CI_AS
78 SQLCHAR 0 50 "","" 77 BREAKFAST SQL_Latin1_General_CP1_CI_AS
79 SQLCHAR 0 50 "","" 78 LAUNDRY SQL_Latin1_General_CP1_CI_AS
80 SQLCHAR 0 50 "","" 79 DEN SQL_Latin1_General_CP1_CI_AS
81 SQLCHAR 0 50 "","" 80 DINING SQL_Latin1_General_CP1_CI_AS
82 SQLCHAR 0 50 "","" 81 FAMILY SQL_Latin1_General_CP1_CI_AS
83 SQLCHAR 0 50 "","" 82 LIVING SQL_Latin1_General_CP1_CI_AS
84 SQLCHAR 0 50 "","" 83 GREAT SQL_Latin1_General_CP1_CI_AS
85 SQLCHAR 0 50 "","" 84 EXTRA SQL_Latin1_General_CP1_CI_AS
86 SQLCHAR 0 16000 "","" 85 FEATURE_CODES SQL_Latin1_General_CP1_CI_AS
87 SQLCHAR 0 50 "","" 86 MLS_OFFICE_ID SQL_Latin1_General_CP1_CI_AS
88 SQLCHAR 0 50 "","" 87 MLS_AGENT_ID SQL_Latin1_General_CP1_CI_AS
89 SQLCHAR 0 200 ""
" 88 VIRTUAL_TOUR_URL SQL_Latin1_General_CP1_CI_AS
Please help,
Shawn
Import From PHP
Mar 4, 2008Hello
New to the forum and pretty new to SQL Server. I need to import data from a website written in PHP. The data is a leaderboard for a local poker league. It only contains about 5 columns with about 700 rows of data. I was wondering if there was a script to do this? I merely need to import the data into a table in SQL Server that is set up exactly the same way as the table on the website. Anyone help with this one? Thanks
Import Pr's
Jul 20, 2005Hey guys,I was curious how other people create several 100 SQL objects on anew database. Example: I have each procedure in its own text file (IE100 .sql files), so I just check them out of source control, then runa perl script that just dumps them into one txt file. Then I pastethat mess into Query Analyzer.So to reiterate my question, how do other people get sql objectsinto a database. Obviously I'd do an object copy if they resided insome other database.While my solution works, there is always a better way. Thanks foryour suggestions.- Cpt
View 3 Replies View Related