How to develop a tool for conversion the database from sybase to sqlserver
Hello.....this is sudeep from india...i need to Develop a tool to process the data migration procedure. This tool must be able to migrate databases from Sybase to SQL or Sybase to Oracle or SQL to Oracle or vise-versa.
please give me the detail solution ..........
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
To create a website with attractive designs is not so easy.it can be done with strong design and implementation techniques.to develop such sites we must need the help of website design development companies .there are so many companies which offers web development.we have to pick the right one.its the initial task.
Recover and repair MDF files with simple and efficetive tool to repair and recover MDF files from corrupt and damaged SQL server, which tool support all king of SQL server version and Windows OS. Visit here: http://www.en.mdfrepair.net
Read blog post: http://exchangerecovery.hubpages.com/hub/How-to-perform-SQL-Database-Recovery Corrupt MDF File Repair Utility
Need more detail in order to help you. Let's start with:
Is this a home or office PC (or Mac, or Linux machine)? Is the database stored on your machine, or are you connecting to a database server? What type of database (Oracle, MS Access, Sybase, etc.)? What type of client / business software are you trying to use to connect to this database?
If your database log gets filled. You can alter the log size if required in future too. If the log suddenly got filled and it is not occuring everyday then you have to find which query causing the log filled by executing the below
select * from syslogshold where dbid=db_id("your db name")
find out the spid and then run sp_showplan and dbcc sqltext for the particular spid and then decide upon the query whether you can stop(kill the process) it or allow it run by increasing the log space.
Be careful in production environment. Don't it kill any process without confirmation of user.
If the same query is running everyday and log is getting fill everyday then you can alter the database log space with proper approval.
If the same query is running everyday but today only log space got fill then check the growth of data decide accordingly log size of your database.