Printable View
I was wondering if it is possible to copy the contents of a SQL datatable into another completely separate datatable using VB2008 Express, if they are both have the same name and table definitions. The reason for this is because I created a small program as a database learning tool, now I created a larger project and would like to import the data that I have been entering and storing on my first program.
What is the database? Access?, SQL Server? Oracle? They all provide a method to just move the data if this is a one time thing.
Both Databases are SQL Server.
But neither of them have any relations to each other. They are 2 completely different databases.
does not matter open SQL Server Management Studio and there in an imprt/export option whenyou right click on a database and select tasks
Thanks Gary, I will try that later tonight. Again I appriciate you time. This will be the 2nd time you got me out of a jam. I will post my results and let you know how it worked out.
Are these databases on the same SQL Server instance? If so, you could script out something to import / export as well. You can access different databases (as long as you have permission) via [Database].[Schema].[Table] syntax.
Hi Gary, sorry it took so long to get back to you but i ran into another, more serious problem that I am trying to fix. I did try that server managment program with no success. I am still going to attempt it after I find a cure for this other problem which I am posting because I need all the help I can get on it.
http://www.vbforums.com/showthread.p...08#post3737108
Kasracer, thanks for the advice. I am a nooby when it comes to databases. Scripting out something at this point is way over my head, but I appriciate you taking the time to reply.
Try Microsoft SQL Server Database Publishing Wizard, it will generate an SQL script, and from there you can remove the code that pertains to other tables...