MS SQL Server import/export wizard

Hi everyone,
Plese help me out. I import one database from one server to another. This process able to copy all the tables and functions but it copied only few stored procedures.
so tell me how to copy or import remaining stored procedures?You could always right click on the database, go toall tasks and hit generate script and select the sps you need scripted and then run said script on the new server.|||Or better still

try using the Copy Database Wizard instead of the Import/Export Data Wizard

:-) GW

MS SQL export / import data

Hi there,

I need to dump some data from a db by using MS Query. I noticed couple of issues during my attempts to do so. However I tried to run a query like:

SELECT table.column
INTO OUTFILE '/tmp/result.txt'
FROM table

which generated an error message:
Didn't expect "OUTFILE" after the SELECT column list.

Next I tried was:

SELECT table.column
FROM table
INTO OUTFILE '/tmp/result.txt'

generated another error:
Syntax error in FROM clause.

I also tried to define not only relative path to te result file but absolute path as well but it didn't help me a lot :-(
Could anybody help me what is theright syntx of this statement or is there some special way of MS Query to dump or export or write rows from the database into a file ?

Every suggestion will be higky appreciated

Tanks in advancewhy not try select col1name1, colname2, ... from tablename
then highlight the results, copy it and paste in a text editor eg notepad.
You can then save it and eventually open with excel.

MS SQL database Transfer

How can I transfer an online MS SQL Database with all data to a local machine MS SQL server. I am using Import Export Tool provided by MS SQL Enterprise manager but the referential integraity breaks (Primary and secondary key relationship). Thus the Data concurrency is lost and the database becaomes of no us.

Most of our database projects have Stored procs, Views, Triggers and contain data. Sometimes we have to take back up of the running database.

The same problem comes when we try to install an offline database with data online. We have to run the scripts through Query Analyser on the online server to install database tables, procs, triggers etc and then repopulate the database once again.

But if you see mySQL one can import the complete database with all data using phpmyAdmin tool. Most hosts provide this tool so becomes easier.

Though MS SQL has a database restoration option but 90% hosts do not allow you to automatically generate back up and download. You have to request them and then they generate the backup and upload to web server folder for us to download and restore.

Can anyone explain a solution to this daily problem..axaya

This is the DTS import/export wizard. Have you tried the "Copy objects and data Between SQL Server databases" option ?? This should copy all objects when doing the export. this copied all constraints, indexes...

Hope that helps :-)|||Any other way. DTS takes huge time and connection fails.|||How about detaching and attaching the DB, check out the link.

http://support.microsoft.com/kb/224071/

MS SQL 2000 and MS Word Document

I need one information. Is any possible to import word document into table
field ?
thnx
borisDo you want to insert the whole document into SQL Server or do you want to
extract information from the document and insert into SQL Server.
If you want to insert the document as a binary object I would recommend that
you look at the following section in Books Online:
http://msdn.microsoft.com/library/d...r />
_07zo.asp
Simon
This posting is provided "as is" with no warranties and confers no rights.
"Boris" <boris@.osijek.hr> wrote in message
news:ehKokfXJFHA.2640@.TK2MSFTNGP09.phx.gbl...
>I need one information. Is any possible to import word document into table
>field ?
> thnx
> boris
>

MS SQL 2000 and MS Word Document

I need one information. Is any possible to import word document into table
field ?
thnx
borisDo you want to insert the whole document into SQL Server or do you want to
extract information from the document and insert into SQL Server.
If you want to insert the document as a binary object I would recommend that
you look at the following section in Books Online:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_md_03_07zo.asp
Simon
This posting is provided "as is" with no warranties and confers no rights.
"Boris" <boris@.osijek.hr> wrote in message
news:ehKokfXJFHA.2640@.TK2MSFTNGP09.phx.gbl...
>I need one information. Is any possible to import word document into table
>field ?
> thnx
> boris
>

MS SQL 2000 and MS Word Document

I need one information. Is any possible to import word document into table
field ?
thnx
boris
Do you want to insert the whole document into SQL Server or do you want to
extract information from the document and insert into SQL Server.
If you want to insert the document as a binary object I would recommend that
you look at the following section in Books Online:
http://msdn.microsoft.com/library/de...md_03_07zo.asp
Simon
This posting is provided "as is" with no warranties and confers no rights.
"Boris" <boris@.osijek.hr> wrote in message
news:ehKokfXJFHA.2640@.TK2MSFTNGP09.phx.gbl...
>I need one information. Is any possible to import word document into table
>field ?
> thnx
> boris
>