Database Export

[bNet]

Hi,

I am having a problem exporting DB,
I want to Export a DB but writing the export query on the export wizard, when I do that on the destination DB it doesn't create the table name instead it says query.

When I check on the wizard it says exporting from query to query instead of table names.

can nybody help how can I solve this?

Thanks in advance.

[NeoPa]

Your question confuses me. First you talk about backing up your database, then you say the result is a query instead of a table. You do understand a database is not the same as a table yes?

Can you clarify exactly what it is you are trying to do.

[bNet]

All Im trying to say:

On the destination a Table name has been changed to query.
i.e suppose I am exporting a DB having a Tamble named TTable1 on the destination the name of TTable1 is changed to Query.

I am not sure if this will clarify.

[NeoPa]

Not greatly I'm afraid. You haven't explained the confusion I'm having trying to determine if you know the difference between a database and a table (which is critical to determining how to proceed).

Let me ask another question to see if this will help. Are you using the SQL Server Import and Export Wizard (found by right-clicking on the database and selecting Tasks / Export Data...)?

[bNet]

Yes I am using that wizzard

[NeoPa]

One of the pages of the wizard should have a title of Select Source Tables and Views. There are two columns showing, Source and Destination. The Destination has a ComboBox which defaults to [dbo].[Query]. I suggest you select from this list what you actually want to send your table to.

[bNet]

I dont want to use the option of "copy data from one or more tables and view" since this will coppy all the dataon tables, instead I want to specify the data that I want, and I selected "Write a query to specify the data that you want to transfere", I then wrote my select sql statement, then I executed, no what is happening is instead of puting the corect table name it put that default [dbo].[Query], now I want it to put the correct table name on the destination server

[NeoPa]

If you look back at post #6 you should find instructions on how to go about doing that.

I'm not sure I understand why you didn't do that this time, but they're still there so when you get to that bit again, just make sure to choose an option from that ComboBox that suits you.

Obviously, if you leave it at [dbo].[Query] again, you will experience the same problems again.