Copy data from tables with script!

Hello!

I cant figure out how to copy data from tables in my default database to my new automate-generated database.

I can generate Store Procedures, I can generate the Tables but are there anyone one who knows how to copy the data from tables and put it into my new automate-generated shell. The automate-generate funktion i have built just creating a shell/empty database. How to fill it with a sql-script or similar?

Anyone have any tip?

Regards

If you mean you want to script out the data into the same script with the DDL for the tables try the Database Publishing Wizard:

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=29B4FFD8-AC3A-4481-B352-9B185619A901

|||

It worked perfectly!

Thanks!

Copy data from SQL Server to SQL Mobile

Hello

I'm developing an application that need to create everyday information to be stored in a SQL Mobile Database.

The SQL Mobile database will have:

Last schema from tables (in SQL Server database);

Last information in the tables;

I don't want to copy all the tables from SQL Server database than this mecanism should give me the way to choose the tables.

I have been reading about the SqlCeReplication but I don't undestand what is InternetUrl property. The SQL Mobile database is created in the PC and after is copy to the the Mobile Device.
How can I avoid the InternetURL property?

tkx in advance
Paulo Aboim Pinto
Odivelas - Portugal

Olá Paulo,

The Merge Replication process is based on an agent running on a DLL on IIS, so that's why you need the InternetURL property.

You may also consider the tools from www.primeworks-mobile.com which avoid IIS and may be used over TCP/IP or ActiveSync (RAPI). BTW, these tools are developed very close from where you live...

If you prefer to follow this in Portuguese, try the microsoft.public.pt.pocketpc newsgroup

Alberto Silva
http://msmvps.com/AlbertoSilva

copy a database from one SQL server to another.

Hello:
I'm new in the SQL server world. But I need to copy one SQL database
on machineA to machineB. By looking at the tool bar, I think export
will do the job for me, is anybody can provide the detail info? DO I
need to create an empty database on MachineB first, any documentation
repository I can read and learn?
Thank you so much!
Sincerely,
QGThree different approaches can be found in the following links:

http://support.microsoft.com/defaul...b;en-us;Q304692
http://support.microsoft.com/defaul...B;en-us;q224071
http://support.microsoft.com/defaul...b;en-us;Q274463

--
- Anith
( Please reply to newsgroups only )|||Hi

To add my favourite link!

http://support.microsoft.com/defaul...b;en-us;Q314546

John

"Grace Gu" <qing.gu@.engelhard.com> wrote in message
news:147725ae.0307071218.7b361934@.posting.google.c om...
> Hello:
> I'm new in the SQL server world. But I need to copy one SQL database
> on machineA to machineB. By looking at the tool bar, I think export
> will do the job for me, is anybody can provide the detail info? DO I
> need to create an empty database on MachineB first, any documentation
> repository I can read and learn?
> Thank you so much!
> Sincerely,
> QG