473,320 Members | 2,088 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Copying tables in SQLEXPRESS

Hello,

I have a program, running in several places, using SQLEXPRESS as database.
The different places are stand-alone, and not connected to a network.
Regulary, I have to apply changes on certain tables of the database.

In a previous program, written in VB6 with an Access database, I used JRO
through VB6-code to delete the table in the different databases and to copy
the new one.

Is something similar possible with SQLEXPRESS. I would like to be able to
update tables in an SQLEXPRESS database file by deleting them and replace
them with the new table. Is this possible through VB.NET code?

Many thanks and greetings from Brugge (Bruges - Belgium),

Michel
Aug 16 '07 #1
2 1318
Michel,

With normal SQL script you can do that, have by instance a look at the drop
command.

Cor

"Michel Vanderbeke" <mi***************@skynet.beschreef in bericht
news:46***********************@news.skynet.be...
Hello,

I have a program, running in several places, using SQLEXPRESS as database.
The different places are stand-alone, and not connected to a network.
Regulary, I have to apply changes on certain tables of the database.

In a previous program, written in VB6 with an Access database, I used JRO
through VB6-code to delete the table in the different databases and to
copy the new one.

Is something similar possible with SQLEXPRESS. I would like to be able to
update tables in an SQLEXPRESS database file by deleting them and replace
them with the new table. Is this possible through VB.NET code?

Many thanks and greetings from Brugge (Bruges - Belgium),

Michel

Aug 16 '07 #2
hello Michel

You can do this with SQL -DMO objects or with DDL-SQL ( wich suits you the
best )

regards
Michel Posseth
"Michel Vanderbeke" <mi***************@skynet.beschreef in bericht
news:46***********************@news.skynet.be...
Hello,

I have a program, running in several places, using SQLEXPRESS as database.
The different places are stand-alone, and not connected to a network.
Regulary, I have to apply changes on certain tables of the database.

In a previous program, written in VB6 with an Access database, I used JRO
through VB6-code to delete the table in the different databases and to
copy the new one.

Is something similar possible with SQLEXPRESS. I would like to be able to
update tables in an SQLEXPRESS database file by deleting them and replace
them with the new table. Is this possible through VB.NET code?

Many thanks and greetings from Brugge (Bruges - Belgium),

Michel


Aug 17 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: andrewcw | last post by:
I am trying to use the NorthWind database or anything with SQLEXPRESS on VS 2005 RC. I can see SQLExpress started with the tool SQL Server Configuration Manager. But when i select DataBase | New...
2
by: Nedu N | last post by:
Hi Techies, I am facing problem in copying content of table from a untyped dataset into to a table inside the typed dataset. I wanted to copy the data into typed dataset in order to ease the...
2
by: Crash | last post by:
Windows XP MS SQLExpress VS 2003 ..NET 1.x SP1 {for Application} ..NET 2.0 {for SQLExpress} MS Enterprise Library June 2005 This works from a command prompt osql -E -S localhost\SQLEXPRESS
13
by: Matt Fielder | last post by:
First off, if this is better posted in another group that qualifies as a manged group, please let me know. I currently have an application written in VB.Net using MSDE as the database. Current...
7
by: koonda | last post by:
Hi guys, I am trying to create a web interface in C# using ASP.NET. The database being used is SQL Server. I have some problems loading the tables in the datalist controls. When I run the program...
4
by: Torben Laursen | last post by:
Hi I am trying to find find the sqlserver express that is running on my computer using: DataTable dtSQLServers = SmoApplication.EnumAvailableSqlServers(false); It returns one row that holds...
5
by: =?Utf-8?B?bXVzb3NkZXY=?= | last post by:
Hi, I wonder if someone could shed some light on this one for me. I have developed a web app in VS2005 with the built in server. It uses an sql database, everytihng works. I need to test it...
2
by: troy_lee | last post by:
What is the best way of copying all the records from a linked table into a replica table that is local on my computer? This is for development work at home where I can not access the main table. Is...
1
by: tshad | last post by:
Running on VS.net 2005, I am trying to copy rows from my datatable to another datatable in the same dataset. The schema would be identical. I need to make the table name "forms" as I am...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.