Does anyone know of an efficient way to import DBFs into SQL Server 2008 (besides the “import into Access, then import the Access files into SQL server-method”)? I don’t work with SQL Server much, but I do it enough to have had this problem before (to be exact, it seems I have this problem once [...]
Answer Question | June 4, 2010 3:28 PM
DBF file, SQL Server 2008, SQL Server import/export
hi ALL, i have a strange situation, there is few people who is not able to load data from sql server using dsn file. I have used correct method, i have used odbc driver -sqlserver… i believe every thing should be fine. I have check the access permission for that user. that is not the [...]
Answer Question | February 16, 2009 7:09 PM
Database connectivity, DSN connection, Microsoft Access, Microsoft Excel, SQL Server connectivity, SQL Server import/export
I want to transfer data from access to sql table and vice versa through windows service. so, plz help me.
Answer Question | December 9, 2008 8:00 AM
Database migration, Microsoft Access, Microsoft Access import/export, SQL Server 2000, SQL Server 2000 import/export, SQL Server import/export, Windows Services
hi, Please tell me , how can i upload data from excel into SQL2005 thanks & regards Ambrish Srivastav
Answer Question | November 25, 2008 12:59 PM
Microsoft Excel, Microsoft Excel import/export, SQL Server 2005 import/export, SQL Server import/export
i am not able to update table in ms sql2000 from oracle . can u sugegstyour views on this . the error i got is ORA-00904: “NAME”: invalid identifier.
Answer Question | October 22, 2008 8:58 AM
Microsoft SQL Server 2000, ORA-00904, Oracle error messages, Oracle import/export, SQL Server 2000, SQL Server import/export
Hi to all, I have a Dell PowerEdge server having an SQL 7 DB on it and I want to transfer these DB to the new IBM Server having an SQL 2005 Server Standard Edition. I am not experienced enough to database administration. Can someone guide me thru this pls. Thanks, Bert
Answer Question | December 11, 2008 9:33 AM
Dell PowerEdge, SQL Server 2005, SQL Server 7.x, SQL Server import/export, SQL Server migration
Hi, I am at total lost at trying to copy system db(master, model, distribution, etc) from a 2005 server on one machine to another 2005 server on a different machine, so all the logins, job, etc are also copied to the new server. I have tried to google this problem and am at a lost [...]
Answer Question | October 9, 2008 3:38 AM
SQL Server 2005, SQL Server import/export, SQL Server migration, SQL Server replication
How to create a xml file using sql server 2005? what are all the steps to do for this?
Answer Question | October 9, 2008 4:54 AM
SQL Server 2005, SQL Server import/export, XML
I want to Save Word File in SQl Server, how it is possible
Answer Question | September 19, 2008 6:31 AM
Microsoft Word, SQL Server 2000, SQL Server import/export
SSMA warning messages: * O2SS0356: Conversion from NUMBER datatype can cause data loss. BEGIN FETCH emp INTO @emps$emp_name, @emps$emp_id IF @@FETCH_STATUS = -1 BREAK IF @emps$emp_name = ‘Avi’ /* * SSMA error messages: * O2SS0013: EXECUTE IMMEDIATE statement was converted into EXEC(…) statement, but dynamic string was not converted. It must be converted manually. * [...]
Answer Question | August 16, 2010 7:31 AM
O2SS0013, O2SS0356, Oracle error messages, Oracle import/export, Oracle migration, SQL Server import/export, SQL Server Migration Assistant, SSMA, SSMA for Oracle, SSMA warning messages
i have a xml file.i want to insert the contents of the xml file into a table in sql server 2005.
Answer Question | September 8, 2008 5:33 AM
SQL Server 2000, SQL Server import/export, XML
How can I save query results into .xls format directly from Microsoft SQL server Management studio?
Answer Question | September 5, 2008 1:43 AM
Microsoft Excel, SQL Server 2005, SQL Server import/export
i have a xml file.now i should upload the tags of the xml as fileds in a table in sql server.automatically the values should be inserted in the table data.
Answer Question | March 4, 2011 8:58 AM
SQL Server 2005, SQL Server import/export, XML
When I migrated a small database from Oracle to SQL Server using Microsoft SSMA, it converted CURSOR types to varchar(8000) **SSMA Warning** O2SS0259:CURSOR type was converted to varchar(8000) ** Do we just leave this as is or does it require attention. Thanks.
Answer Question | August 25, 2008 1:42 AM
Database migration, Oracle import/export, SQL Server 2005, SQL Server import/export, SSMA for Oracle
Oracle database has two user defined types as the following: CREATE OR REPLACE type arrayType1 is table of int CREATE OR REPLACE type arrayType2 is table of varchar2(255) How do we represent these in SQL Server 2005?!! (Note: Microsoft SSMA fails to migrate these) Thanks
Answer Question | August 28, 2008 1:38 AM
Database migration, Oracle import/export, Oracle migration, SQL Server 2005, SQL Server import/export, SSMA for Oracle
How do I automate 2 sql servers to replicate .xml files
Answer Question | August 22, 2008 9:13 AM
SQL Server 2005, SQL Server import/export, SQL Server replication, XML
i want to create xml file from sqldatabase.i hav many record and i want dynamically create xml file.ihave a multi table taht i want in xml file
Answer Question | August 7, 2008 5:22 AM
SQL Server import/export, XML